Webmaster Forum / ColdFusion / Database Access / December 2006

Why does this not work (returns 0 records)
<cfquery name="poll" Datasource="#Application.Datasource#">
SELECT    *
    FROM    voting

Im getting "Too few parameters. Expected 1." when trying to update a form, and
I need a second pair of eyes if anyone can help?
/*  ***************  profileFusebox.cfm  *************** */
    <cfquery datasource="lsm" name="editProfile">

Hi guys  can any one tells me what wrong here  I have list and I want to
updated  the error I get is ( Syntax error (comma) in query expression
'bizname=?,?'. )   it is list from form and it is , delemeted, so whats wrong
here  check the code, any suggestion greatly approciated., ...

Hi, I am running CF MX version 7,0,2,142559  Standard Edition and ColdFusion is
hanging everytime I attempt an insert or update statement again Oracle 8i and
9i using the jdbc thin driver and an odbc socket driver.
Select statements work fine. I have tried everything I could ...

Is there a way to retrieve the actual SQL string (e.g., plain-text) that was
sent to the DB? I have a complex, dynamic query that will change based on what
the user plugs into an advanced search page. However, to help in debugging, I'd
like to see the actual SQL that was ...

in a cfquery how do i get information from the "from" in more than one db? for
example say in one db i have their first name and in another db i have their
last name... so for example my db's are something like this:  db name is
FirstDB and in that db i have memberNumber, ...

Attached code.  Clearly their are records to delete, what am I missing?
Using MS Access database.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query expression

hey, i need to have coldfusion to count the amount of rows that are inputted in
my table.  i want it to tell me which are the top 3.
this is what i want to find out, i have a table with names  for example: bill,
joe, mark, sue, and kim and bill submitted information into the ...

I am having a problem connecting to my database. I have a database in MySQL
called vc_rsvp. I logged into the coldfusion administrator and connected to the
database. It connects perfectly without any error, the verify says ok but when
I open a .cfm webpage that reads the database ...

I'm having problems querying text with french characters in it.  It's being
outputed as question marks.
I was able to reproduce the problem on a local test server with CFMX 7.01 and
MYSQL 4.x and the problem went away when I added

Hello all -
I have an archive page on my website that lists a few hundred articles from
over the years. I recently revamped it (with the help from this forum) and have
one final tweak that is eluding me.

I have two CF servers, A and B, A has an Access database I need both to connect
to.  I have created a datasource on A that succssfully verifies the connection,
but I cannot do this on B, even when the db file is browsed to and the filepath
cut and pasted.    However, if I try to ...

I have a problem now conecting to my SQL data file.  It has worked for around a
year and now it doesn't.  I loaded IE 7 which gave me some problems.  I have
turned off the firewall and all virus and addware programs in the hope this
might be the problem.  So fare nothing has ...

I am updating a table A and there is a trigger on that table which updates
table B. If i try to update the table A too fast i am getting a deadlock error.
I am interested to capture the deadlock error and dispaly a custom message to
the user. I used cfcatch, i am not seeing any ...

I have JSP on Cold Fusion 6.1 MX with IIS using JSP engine and using Oracle
connection with everything working for past 2 years. We just upgraded to CF MX
7 and now my JSP has this error:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver