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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by nicfoster
-
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 have found the problem and it is me. I have not set the display flag to 1 in the production database. Sorry everyone - I just noticed this when I was making the previous posting. So, I guess I need to thank you for at least getting me to see this. Thanks. Nic- nicfoster
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Stored Procedures Stopped Working
No Luck. I had cut and pasted the stored procedure select into the Query Analyzer and ran it. Same effect - no rows returned and no errors. Here is the query: IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'dbo.procSearchKeywordOnly') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)...- nicfoster
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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
The solution turns out to be that the CF implementation of SQLOLEDB provider does not support some SQL functions - FORMSOF being one of them. They suggested using a DSN and ODBC connection. I did and it worked. Thanks for the help. Nic -
CFSTOREDPROC with OLEDB datasource
To begin with, one of the reasons for using SQLOLEDB instead of ODBC is that you do not need a DSN for the datasource. This is part of the SQLOLEDB connection string established in CFAdministator. Did you create the SQLOLEDB entry in the CF Administrator for backdata2? All you need in your... -
CFQuery and Full Text Searching
ram123, if you mean SQL92 standard, I would think so. I use cfquery with all of my SQL Server7 queries and stored procedures. GunJack, I am not using ODBC connections. I use OLEDB connections and we are running the MDAC 2.51. I think it has to do with the single quote marks not being parsed... -
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
The solution to this problem was that the dll sqlftqry.dll was not updated when SP3 was installed. Installing the SP3 version of the dll solved the problem.- nicfoster
- Post #2
- Forum: Microsoft SQL Server: Programming
-
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?
Thanks everyone. It was the frame idea that I had forgotten. -
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...
