Webmaster Forum / ColdFusion / Database Access / October 2004

I can't get this right, would appreciate help. Thank You.
<form action="page3.cfm" method="post">
<input name="hidden#num#" type="hidden" value="#num#">
</form>

Connection verification failed for data source: aam
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC

When I query an Oracle database (8.0), the result is not sorted as expected :
lowercase are after uppercase, accents are at the end, ...
I suppose is missing something on my server, may be NLS_LANG, but I don't know
how to set it on Linux ...  

Hi all,  Anyone know if there is SQL I can use to delete items from a databse
which match the elements of a given array?   e.g. I have an Array of personal
IDs and want to delete all records from a personel table where those IDs match.
 Or do I have to loop through the array and ...

Can anyone help?
I have tried to create a connection between my Mysql 4.0.2 data base and
Coldfusion MX. When  I follow the instructions in Coldfusion admin I get the
following error :

We're running CF MX on a Windows server that runs IIS5. The box has 1Gb of
memory.
We're about to roll out a new app that's currently using an Access database.
This app has a couple of templates containing relational queries that draw from

I am trying to connect to a DB2 database on a remote/testing server but
cannot get the 'connection' to connect and therefore enable me to see the
tables in the Dreamweaver interface.
If I use an include file and refernce that I can connect and retreive data

If you want to use XML as a config file for you application, then I'd suggest
you check out
http://clearsoftware.net/client/index.cfm?mode=entry&entry=67E5ADDF-E081-0478-47
1D4AB4B664CE9A by Joe Rinehart.

i developing an online application for a website where only authorized users
can have access to specific files stored on the server, stuff like photos,
videos, etc. i need to either store the actual binary data from the files in
the database and retrieve them whenever i want, or ...

I'm creating an MSSQL database that will store full article text and html page
text within the databse.  Since the size of the fields will vary from record to
record, I was wondering what data type I should use for the field.
If this were an Access database, I would simply use ...

having problems here.... just trying to verfiy that you can use "and" in a where statement on an update....
meaning...
UPDATE blah
set blah = #blah.blah#

Is there a way to add time in either Access DB or in CFML?
Thanks.

I am running Cold Fusion MX 6.1 With SQL Server 2000 SP3 On Windows 2003 Server
Standard Edition.  Everything was working fine, than I had problems with the
website.  Anyway, got that fixed now in the data source I get the following
message :

I'm trying to query dates for reports that are coming due. It works fine if I
do ' = ' but fails if I use GTE, any ideas?
<code>
<cfset todayDate = Now()>

I am new to ColdFusion and need some help.
I have a database which some of the fields contain Null value.
I created a CFM file to extract the data from the database and display them on
a table.