Webmaster Forum / ColdFusion / Database Access / January 2006

I am getting a MS Access ODBC Syntax error (missing operator) in query
expression '2006-01-05 09:17:01.0' when I try to execute an update query. On
the update form I have a hidden value that passes the current date and time.
Any help would be appreciated. Thanks. Here's the query ...

I am working on an application that uses Coldfusion 7 and Oracle 9i.  We
currently handle all user managment via a webuser table in the oracle DB (with
fields for username/password/user_id).  We would like to make a trigger that
will fire when a table is updated (set updated ...

I have a Dynamically created formfield. Tgis field shows the attached devices
off a selected device (for instance you have a pc and in the formfields it
shows two attached monitors). The monitors however are in the same database
table. (with an other device_id ofcourse). The ...

I want to create a drop down, or selection list with a query from a db. Can
anyone give a hint or explain how to do this? I tried cfselect but can't get
the data to display.
The value of the attribute Query, which is currently "qwe", is invalid.

I'm looking for the solution to this error:  'Operation failed on the data
source named ''clivars_oracle''.Reason of failure
''coldfusion.sql.DatabaseConnectionException: Timed out trying to establish
connection''   This happens after a cold backup of the oracle database v.

Eventhough I have searched this , I can't find an answer for this
Does queries of queries support the case function?
like this....
<cfquery name="gettotal" dbtype="query">

I have a problem when trying to insert arabic characters in SQL Server data
base  from a Coldfusion MX 7 cfml page. All arabic sent characters  to database
become question marks "????????????".
Is there any problem in supporting arabic characters in Coldfusion MX 7 ? or

I'm trying to verify Access 2000 databases on a CF MX 6.1 Windows installation.
I can verify the databases normally, but when I turn on Unicode Support, the
same databases will not verify.  
It is my understanding that Unicode Support is necessary so that the databases

Hey guys, just trying to learn something new today and wanted to convert one of
my cf pages to a sproc. This page just sets up security for the application. In
Coldfusion, all I'm doing is looping over a list.
The list is generated from a group of checkboxes, and looks like this ...

Hello Everyone;
I'm using an MS Access DB on a CFMX (CF 6) site...and updating records in a db
from a form ..the CFM for code looks like :
<cfquery name="ProjectTable" datasource="caproject">

Hi guy's,
I am completely new to ColdFusion.
I have created a mini-site (www.wealthmasterylive.co.uk).  I have a form in it
that has the following fields;

I have a textarea on a form where users are able to enter text wrapped in
'single' and "double" quotes. However, when I insert or update the data in my
MySQL database I am having problems. I realise that this is because the
variable containing the data is wrapped in either ...

trying to add an access db, but it only offers me Microsoft SQL Server, SQL 3.x
and "other" as options for db types to add - i'm not used to this new server,
how do i add an MS Access db, when it's not an option? i'm sort of a newbie, i
used mostly back around version 4.0.. ...

I can't seem to figure out these inner join syntax -
I want to add :
INNER JOIN tbl_skus ON tbl_skus.sku_Id = tbl_orderskus.ordersku_sku
to the following:

Hey guys,
I had built some photoblogging software in the past and am currently just
revising it to bring it up to validated xhtml and running solely on stored
procedures.