I am trying to get an cf query to work properly:
<cfquery name="rsResults" datasource="#mm_gottagoautos_dsn#">
SELECT *
FROM Classifieds
WHERE (
<cfif IsDefined ('form.search_make')>
(...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21015050...
SQL Exception:
Syntax error or access violation: You have an error in your SQL syntax near '; ' at line 1
ANSI-92 SQL State: 42000
Vendor Error Code: 1064
Is anyone familiar with this error...
http://www.experts-exchange.com/Database/MySQL/Q_20450198.html
Zones:
MySQL ServerDate Answered: 02/04/2004 Grade: A Views: 23
We recently had to rebuild our SQL server, on readding the master database everything seemed to come up fine except for a couple of jobs which were failing.
All of our maintenance plans were no ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20828022.html
i created a new user defined function and executed it (to create) from sql query analyzer. but during execution it got stuck and i hvae to cancel the task from task manager.
now i database ( in wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20857377.html
I have two network printers connected to my PC: HP LJ 5000 DTN and a HP LJ 42000 DTN, the former printer is set as my default printer.
I have a created a word template, set the page setup, Paper...
http://www.experts-exchange.com/Hardware/Peripherals/Printers_Scanners/Q_21192868.html
Zones:
PrintersDate Answered: 12/25/2004 Grade: A Views: 0
Hi Experts out there,
I have two MS SQL servers running on Windows XP pro and another one on Windows 2000 Server. I have completely backed-up (database-complete) a database (called book) from Wi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21704893.html
Zones:
DatabasesDate Answered: 01/21/2006 Grade: A Views: 0
Hi
I am having a real headache with this one. Essentially I have a number of tables which are used according to the users selection from some dropdown boxes. This works fine, and I can set the ...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21932691.html
Good Morning/Afternoon
Can you all help shed some light on my DSN creation problem?
1)I add a System DSN with the SQL Server driver
2)Use (local) for the server
3)SQL Server Authentication
...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_22054809.htm...
the error i get is :
microsoft sql-dmo (odbc sqlsate:42000)
cannot associate files with different databases.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20953967.html
When I restore Intershop database from device, there is a notice:
Microsoft SQL-DMO (ODBC SQLState: 42000)
The backup set holds a backup of a database other than the existing 'Intershop' databa...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21014943.html
Zones:
DatabasesDate Answered: 07/06/2004 Grade: C Views: 0
