Recent content by nicfoster

Has anyone run across a problem with <CFQuery> Insert statement executing twice when it is called only once?

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

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

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

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

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

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

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

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.

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

Thanks everyone. It was the frame idea that I had forgotten.

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.

I am using CFStudio 4.5.2 on Win98. The last two days I have been getting this error when exiting CFStudio: &quot;Exception EAccessViolation in module CFSTUDIO45.EXE at 000FA1FC. Access violation at address 004FA1FC in module 'CFSTUDIO45.EXE'. Read address 01A771F8.&quot; This error occurs...