Webmaster Forum / ColdFusion / Database Access / December 2004

I've hammered out this select statement with a friend of mine but he is a SQL
Server guy and I'm running an Access DB on an ODBC.  The code seems to be fine
but I'm getting error messages.  The specific message is:  [Microsoft][ODBC
Microsoft Access Driver] Syntax error (missing ...

I was wondering if any of the CF or SQL Gurus here could help me with an issue
that has been racking my brain for a week now.
I am working on a price guide/ checklist website that lists items on a picture
guide/checklist. It pulls the item info from one table, but it also pulls ...

I am trying to escape a CF string variable in a SQL Insert statement.   SQL
seems to be crashing on the variable, because the variable contains all sorts
of special characters.  Can anyone point me in the right direction for finding
information on how to escape these variables ...

I'm looking for some insight on how to do this the 'best' way. The first step
on my web site is to ask the user to gather the data they want to view.  From
that I get a very large query (can return 10,000 - 1,000,000)...but I'm only
displaying the number of records.  A few steps ...

Greetings,  I'm calling a SQL server stored procedure using CFSTOREDPROC and
keep getting the following error message:  ODBC Error Code = S1C00 (Driver not
capable)  [Microsoft][ODBC SQL Server Driver]Optional feature not implemented  
Below is the code I'm using for the SP:  ...

Hi there,   I'm doing my first database conversion and it's gone well except
for a few things.  In Access I had set the default value of a date/time field
to 'now()' so that with each update of the table the time and date stamp was
updated and I never had to worry about doing the ...

Dear MM , and Felow developers .... i have an application that reads data from
an AS/400 server and display the information. english data is working just fine
, BUT when i read Hebrew or Arabic or Chinese strings i am unable to display
the correct string !?!? i only get garbage . ...

Hello.  I'm having trouble with getting CF to run a SQL Server stored
procedure, which in turns runs a SQL Server DTS package that imports data from
an Excel spreadsheet into a SQL Server db table.  All of the pieces appear to
be working, but just not together.  In other words:  ...

Hi, Can someone please tell me why the code below does not work?  I have tried
a million different things and always get a 'ODBC Error Code = 37000 (Syntax
error or access violation) / [Microsoft][ODBC Microsoft Access Driver] Syntax
error in INSERT INTO statement' error on the ...

anyone can tell me wat is my problem?
i try to
select distinct * from table
i need to distinct table's foreign key.

Trying to do an INSERT via SQL to a valid datasource.  One of the fields is a
date (stored as Text in the database).  The exact query looks like this:
    <CFQUERY name="add_economy_entry" datasource="#variables.dsn#">
        INSERT INTO Economy

I am in the process of moving my  DreamWeaver MX/Coldfusion environment from a
Windows XP Home Edition system to a Windows XP Professional system.
I've installed Dreamweaver, Coldfusion, and MS SQL Server 2000 Developer

Is there a way to connect to multiple DSN's in a SQL environment? I want to
query two databases which exist in different SQL databases, storeDirectory and
hostDirectory. I can get to each individually, but not both at the same time.
Do I have to run two local queries, and then a ...

i am currently using mssql 2000 and trying to migrate over to mysql, however
having problems with performing multi-query. basically i wanna do this:  
<cfquery datasource='test'> update tbl set name='test1' where id=1; update tbl
set name='test2' where id=2; </cfquery>  there is a ...

I am new to Coldfusion and am trying to set up my DSN connection, however in
the drop down menu do not have the option  in the "Please select a Valid Driver
Type" for Microsoft Access.   Don't know if i have done anything wrong when
installing  but merely went through the wizard ...