Webmaster Forum / ColdFusion / Database Access / May 2005

Hmmm... I posted earlier today, but the message naver made it to the forums.
I'll try again
We have been trying to install an app (prototype designed at another facility)
onto a test server environment in our data center. The equipment consists of

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data
available to read.
We get the above error "randomly" -- I cannot replicate, but it occurs often
enough that our users are starting to report it now too. We have applied all CF

I had somone start a site for me and now I'm trying to finish it. The site
currently deals with apointments and work orders for my computer repair
business. I'm trying to add functionality for dealing with inventory that will
be sold to clients on site. I just feel like im going ...

I'm sure this is basic level stuff but I've been away for a year so please bear
with me.
Basically I want a date entered into a form inserted into Access. I have tried
the following

Hi,
I've developed a simple registration form, a html version and a rich form
(flash) one. The problem is that when you complete the form and press send it
enters the data in the database and enters a black entry/row into the database.

well in the hopes of getting some more help here goes
why doesnt this query work
i get a 500 internal sevrer error message and no debug info
:confused;

Could someone please tell me what the select statement for MSACCESS would be
to select the number of times a player appears in the following table, where
the season is unique. Eg. If a player plays in two teams in one season we only
want to count that row once....

i am using this statement to execute an update on a mysql database bute get
syntax error,
cant work it out any suggestions from you guys
<cfquery name="UpdateEmployee" datasource="852realestate.com-property">

   I have a binary field that contains SessionId. Iam retriving the sessionid
from the database and trying to pass that value in the <cflocation> tag. It is
giving errro as "ByteArray Object cannot be converted to Strings". Any solution
for this error?

I've created a vehicle maintence cf database. On the new record page the user
enters the service details and then picks parts from a like that have been
replaced. When the submit button is pressed the action page creates a new
record in the MaintenceRecord table and then needs to ...

I am trying to apply the following hotfix:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=e917887
But I cannot figure out how tod etermine what sequeLink version I am running?
The instructions in the hotfix do not give me any results. please help!

I have followed the instructions on getting this to work.
I installed the .jar file in C:\CFusionMX\wwwroot\WEB-INF\lib
This is the .jar file name: mysql-connector-java-3.0.16-ga-bin.jar
I went to the CFM Admin and selected the - Java and JVM Settings page.

   I'm having a problem retriving dates when i use this query:
    <cfif Form.TxtDate GT "">
        <cfif Form.FindDate EQ "EQUALS">
            <cfset WhereClause = WhereClause & " and O_Date = " &

Here is my goal: I want to enter a note in a table called ClientNotes for
certain clients from my ClientList table.
Table: ClientList
Fields: ID - Estatus

I am finding it impossible to unlock an access database.
the specs:
Windows 2000 server
CF 5.0