Now I installed latest PHP 5.2.3 Uder IIS as ISAPI. And I use SQL server 2005.
I have a table(tbl) and in field(fd1) have some info like "ABC".
I do a select query like
$query = "select fd1 from tbl where fd1='ABC' ";
$rs = mssql_query($query);
$rel = mssql_fetch_row($rs);
Then $rel[0] give me...
Currently I have two SQL server sitting in two different machine. I call then SQL1 and SQL2. There are database DB1 in SQL1, database DB2 in SQL2.
Now I connect to SQL1.DB1, can I write a query like "select * from SQL2.DB2..table2 " to get data from the tables in SQL2, DB2?
In a table I create links for user to download Word documents.
Here is my code:
<A href="someWordDoc.doc">Doc description</A>
I only want to user right click to save this document instead click to open the file. Is there any good way to do that?
Thanks
I am using MS SQL server2000.
I create a SQL function in database, let's call it func1.
Then I create a query statement like:
$query = "select * from table A where col1=func1(0)";
I am trying to use mssql_query($query) to run it, but it doesn't work.
How can I handle this?
Maybe you guys are right. I need re-install it.
In another machine I installed the same version of Apache server and PHP, there is no problem at all. The problem is from production server, I hate to update it.
I want to call a VB application in my java code. I need set bunch of properties and run it. It looks like Runtime.exec() cannot handle this. Is there anyway to call a COM object in java? like
obj = new COM(myVBapplication);
obj->property1 = blur1;
obj->property2 = blur2;
...
obj->run;
Could be. But if it is with RAM, why only Apache has problem. Other applications such as SQL server never has this problem? I am going to check it. Because it is production server, I feel real headache to change anything.
Actually I have two PC, one is local test server, the other is the production server. They have the same OS, same Apache server, same PHP. I don't know why only production one has the problem while local one works fine. And Apache/PHP has been running almost two years, then suddenly this error...
Currently I always got some error message like :
"Apache.exe error"
"The instruction at '0x6f68fbe' reference memory at '0x000004'. The memory couldn't be read".
I don't know whether my Apache server has problem or PHP programming cause the problem. Though those annoying message was generated...
Current I always got some error message like :
"Apache.exe error"
"The instruction at '0x6f68fbe' reference memory at '0x000004'. The memory couldn't be read".
I am running PHP 4.2.3 on Apache server 1.3.20 , my OS is WINDOWNS NT.
Thanks.
Thanks All. Especially to Sleipnir214.
I tried PHPMail, it is very powerful and easy to use. When I finish my work, I am going to dive into its code to discover how mail works.
Unfortunately, I found even jpg file doesn't work for that source code? Who has tried to send attachment?
I tried to give $filename a real path, but it doesn't work either.
I wonder problem is on
$data = fread($fd, filesize($filename));
When I give a wrong $filename here, I got the email with...
Besides rename table, you can try like this:
SELECT cust_id, cust_name, rainbow_order_id FROM [customer], [order]
WHERE customer.cust_id = order.cust_id
AND customer.cust_id = '1'
I want to email a pdf file as attachment. I read the thread in FAQ.
His code is :
$filename = "myfile.jpg";
$content_type = "image/jpeg";
$fd = fopen($filename, "r");
$data = fread($fd, filesize($filename));
fclose($fd);
While I don't know $content_type of pdf, so I left it empty. Then code...
PDF sometimes drive you crazy. You got the error message because your code is not correct, pdf file is not generated successfully. But sorry, at a brief glance, I can't find error.
Method 1: use
PDF_open_file ($p, "D:\\Apache\\htdoc\\test\\test.pdf");
<A href='test.pdf'>
This is will generate...
I want to import some tables(include data) from SQL server to Access automatically.
Currently I select records from SQL server and insert into Access one by one. This is a very slow way. When I use "import table" in SQL server to transfer tables to Access, it works very fast. I think there must...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.