Webmaster Forum / ColdFusion / Database Access / January 2008

after changing the Oracle DB-driver from the one provided with CF Enterprise
to Oracle JDBC thin I run into ora-00933 "Command not properly ended"
exceptions. The SQL code syntax ist correct (runs in SQL*plus) and worked fine
before. It seems to be related mostly to insert from ...

I'm hoping someone can steer me in the right direction on writing an SQL
query. Sorry if this gets a little long but I want to provide enough info to
get the help I need.
Here's the skinny:

Hi i am doing a site where clients can do a seach based on caseworker name. i
need to get the information from 2 tables.
[i]<cfquery name="caseworker2" datasource="webconveyancer"
dbtype="ODBC">select caseworkerid from caseworker

I am a web designer/ medium-level developer who use adobe products from when
they were macromedia, flash being my favorite. I have a job am working on; the
most challenging so far. I wish to build a verification application that works
like using gift certificates to purchase ...

I can run a query against my connx 10.5 odbc DSN 2 or 3 times and then the
query will no longer run.  Looking at the database statistics, the connection
pool shows open connections for however many queries I ran.  I must reboot to
recover functionality.

I have a problem with the second query in this code (gives me a syntax error in
my HAVING line)
<cfquery name="getDupes" datasource="#application.ODBC1#" dbtype="ODBC"
username="#application.userNameODBC1#" password="#application.userPassODBC1#">

This is probebly really simple but i cannot manage to sort it. I have a site
which tracks an update of a clients case. the solicitors have certain steps
they need to follow and they update each stage with a short date.  i have the
short date format in access. When it is displayed ...

Has anybody had success retreiving relative record number of a DB2 (8.1) DB?
I've used SELECT RRN(column), SELECT rrn, column and a mulititude of other
options. Tried CF 6.1,7.02 and 8, none of which have worked. Using latest JDBC
drivers (I think)

The following SQL statement brings back records using query analyzer on the SQL
server.  However when I run it in a cold fusion page it comes back with no
results.  Any idea why????????
SELECT     COUNT(h.userID) AS hits, u.OCD

The user needs to be able to select from one or more items on the page:
course_title, request_date, start_date, person's last name or first name or all
of the above.
When I select one or two of the first items the query works fine. If I skip

The problem I'm having is that if I use CFUPDATE or CFINSERT and go over around
400 characters in the submitted text area it bombs out. I don't know the exact
amount of characters but if I remove some text there is no issue. Does anyone
know why this is happening? If I uses a ...

First i would consider myself an "advanced" beginner at coldfusion.
I had a setup of coldfusion 8 with mySQL5 w/GUI interface. I do my development
in eclipse.
I wrote a VERY simple code,  with a simple database table, and it submitted

I have a inventory web site, and I'm trying to create multiple search engine,
so I have a lot of text boxes and search buttons in one page and I wanna be
able to search by each category. I'm suppose to have 121 records in my
database, but it shows only 71 records after I did ...

I've run into an odd problem since moving to ColdFusion 8 Enterprise Edition.
Any text string submitted to an action page through a form will return an error
("Executing the SQL statement is not allowed.") if it contains text that
conforms to a disallowed SQL command. For example ...

Hello - I've looked through this a hundred times and can not figure out
what the issue is. Can I borrow another set of eyes to tell me what I am
missing?
SELECT Members.member_ID, Members.member_FirstName,