Webmaster Forum / ColdFusion / Database Access / September 2005

When I try to call my database procedure from within my source code, I receive
the follow error:
[Macromedia][SequeLink JDBC Driver]Output parameters with batch updates are
not supported.

Hi people please help
when i enter the login and password in the Login.CFM
i enter to Index.CFM and have some query that only work when i log on my page
but when i click in the link Index2.CFM the querys doesnt work

Hello.  I have a function in a package in an Oracle database.  
Running CFMX 6.1 I have been trying to use CFSTOREDPROC to no avail.  
The problem I am experiencing is I am getting oracle error codes complaining
about the bindings of variables.  I am thinking it is to do with the ...

I have a CFM Page with 2 queries,I need to limit the no of connections
established to the database server..has it crashes by servers.Is there a way i
can limit the no of times a viewer views a page.
I tried limiting the connection in the Datasource as well as cachedwithin .No

I have a database column field defined as a text. I store dates in format:
dd/mm/yyyy.
The user passes a Start date search string in the same format. I need to
filter for dates larger or equal then this string. Can this be done?

We have a stored procedures in Oracle that we are trying to call from
ColdFusion MX 7 using the Oracle Thin Client.  The request hangs -- we never
get an error (that we can see in the CF logs or in the browser).  There are a
lot of messages about issues with this, but I'd like to ...

I have laboured through the joys of importing a CSV file and sticking the
values in a MySQL database. So far so good.
However the CSV file contains a value as follows :-
"W\'hampton/Birmingham"

I have a field in my db that stores both negative numbers and positive numbers.
I want to sum only the negative numbers. Is there a way to do this. I know a
simple sum query
<CFQUERY NAME="GetSun" DATASOURCE="myds">

I am trying to write what I think is a pretty basic script.
The coding would be a bit like hot scripts; basically a review system.
I am having problems from the get go with designing the database.
It would look something like this

I'm having problem with dropped data between the Coldfusion 6.1 server and the
DB server.
Submitting using cfinsert:
 cfinsert datasource="mydatasource" tablename="MYTABLE"

I've moved a web site that I've built from a server that uses CF 5 to a server
that uses CF MX.
As seen in the page - http://www.yes-od.com/kesher.cfm
The static hebrew HTML text apears just fine, but the dynamic hebrew text from

I have got this query
<CFQUERY NAME="GetImportData" DATASOURCE="ExcelNordic"
USERNAME="#Application.SQLUserName#" PASSWORD="#Application.SQLPassword#">
    SELECT *

We have just installed a new W2k3 server with CFMX7 and MySQL 4.0.21 and moved
an application from an older W2k server with CF4.5 and MySQL 4.0.12. Everything
works fine expect one thing. It would appear that whenever we exact a datetime
from a datetime field in the database an ...

 I have followed this:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.6ef02
53&extid=6ef0253&dialogID=4592751&iterationID=1&sessionID=96306f83bd8c675604a1&s
tateID=0%200%204598981&mode=simple.

I keep getting the following error each time I attempt to add a recordset to a
database using an insertion form created in Dreamweaver, this is for a very
important company project and I have tried everything that I know of to fix the
problem with no luck, if someone out there ...