Search results for query: *

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?

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;

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.

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...

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...

I want to add a search page on a website to search for pages within this website. Such as when user input a key "tek-tip", they will find a list of page(with website) which contain "tek-tip" info. Thanks

I tried to print out chr(128)-- chr(255), but the chars showed on screen are totally different from ASCII table. Chr() only works for tose who are less than 128? Thanks.

My OS is win2000, DB is mssql2000 When content inculde unicode chars in DB, I use PHP to select these content, it will convert these unicode chars to different one. Such as : in DB: ß-IFN After selection: á-IFN How can I handle this situation? Thanks.

My working environment is Apache/PHP. I have three PC in a intranet. My Apache server is on one of them -- (server C), the other two install SQL server 2000 (And both are win2000 OS). I can connect to one server(A) either with name-pipe or URL, while I can't connect the other server(B) in both...

For a table such as tblA, it has two fields &quot;name&quot;,&quot;status&quot;. If I want to insert a record (&quot;jianbo&quot;,&quot;I'm confused&quot;), finally in database it becomes &quot;jianbo&quot;,&quot;I''m confused&quot;. Then I do a select &quot;select status from tblA where...

One of my database shows &quot;(recovering)&quot;, icon became gary, no item under the list from SQL server Enterprise Manager. I wait for a long time, but it is still in that status. What shall I do for this? Thanks. Mine is SQL2000.

I tried to split a string with delimiter &quot;|&quot;. Normally it works fine with explode, but if in this case: &quot;|&quot; is right near a number like &quot;abc1990|na&quot;, I can't split it even with ascii code chr(124) instead of &quot;|&quot;. How can I handle this situation? Thanks.

One of my database's transaction log file increase to an unbielivable 7GB. I wonder how I can shrink it. And Which operation will cause the transAction log file increasing? Thanks.

For a textbox, can I set cursor move from right to left? Thanks.

How can display from right to left when I input some text in a textbox. Such as I input &quot;a&quot;,&quot;b&quot;,&quot;c&quot; in order in a textbox, while it display like &quot;cba&quot; ? Thanks.

I want to do a selection query, while I only want to display like from 51st to 60th records. How can I do this? Thanks