Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CFQuery Insert Problem
Has anyone run across a problem with <CFQuery> Insert statement executing twice when it is called only once? -
Stored Procedures Stopped Working
I had tested new versions of the stored procedures we use for searching for products on my development machine. Once tested, I used the Query Analyzer to install the new stored procedures in the production database on our web server. When I went to run a search, the stored procedure returned 0...- nicfoster
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
CFQuery and Full Text Searching
I am using full text searches in SQL Server7 DB. All seems to work except for queries with the FORMSOF verb. I get the following error: OLEDB Error Code = 170 Line 1: Incorrect syntax near 'FORMSOF' I cut and paste the query into SQL Server7's Query Analyzer tool and it runs wtihout any... -
SQL 7 Full Text Search Failure - 7607
I have two tables each with one column full text indexed. I get the following error message when I try to query using contains verb: Server: Msg 7607, Level 17, State 1, Line 1 Search on full-text catalog 'ProductName' for database ID 7, table ID 1342627826 with search condition...- nicfoster
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
How do I control the URL displayed in the Address Box?
I would like to show only the base URL of my site in the browser Address box, ie. http://www.mysite.com when I move from page to page even if I am passing variables via the URL to the destination page. -
EAccessViolation in CFSTUDIO45.EXE
I am using CFStudio 4.5.2 on Win98. The last two days I have been getting this error when exiting CFStudio: "Exception EAccessViolation in module CFSTUDIO45.EXE at 000FA1FC. Access violation at address 004FA1FC in module 'CFSTUDIO45.EXE'. Read address 01A771F8." This error occurs...
