Forum: Coldfusion Database Access

How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to...

I inherited a query (shown below) that is going against a DB2 table with over 600,000 rows. Note there is no WHERE clause. I'm puzzled as to what...

I am trying to load 140,000 rows from a MS Access table to a DB2/Linux table. My application platform is Cold Fusion MX 7 on Windows XP. The MS...

Any body seen this happen before ? The follwing code is executing the cffile command correctly and outputs correctly from the cfdump The...

I recently switched from using Access tables to using mySQL. Am experiencing frequent errors of "lost connection to mySQL server." Occurs more...

On the coldfusion form, if the user enter the data with single quote in a field (e.g. Joe's Party), and performs SQL insert or update statements,...

I hate to bother with this, as I have had this issue before and solved it - But I cannot remember what I did! I have t tables, a member list (with...

I need to delete automatic in DB after 2 months. db tbl in_sert column recordID employeeID datum (date) mfm mem tfm tem ofm oem recordID =...

I am using 6.1 updated, MS Access 2003, Windows Webserver 2003. Can anyone see a problem with my code. I am trying to find a better way to update...

I'm trying to figure out how to get my search results more specific and am having trouble figuring this out. With the example code below if a user...

hi all I have a problem when I try to concat 2 fields with a dot, in a query (Oracle database). here an example : <query name="myquery"...

I have write javascript to create form field when button is click. function addEvent(myTable){ var lastRow = myTable.rows.length; var...

I am posting this to hopefully help someone else with the same problem(s) and maybe get an answer? I recenlty updated from 4.5 to 6.1 and have...

XP Pro, CF 6.1(built in webserver), MySQL 4.1.13, DW MX04, I am trying to insert a records from a dynamic form. I created it all in Dreamweaver MX...

Hi Guys, I have a problem I am trying to update a table from another table and I have to update it only if the record is not found in the...

Hi guys, right a little help please.....I'm now a lot further on than last time I posted on here, your help the first time around was very good :) ...

Hi I am running a website off an access db with cf code. I have a couple of pages which can get ~500 users day and have noticed that since using...

We are currently running 5.0 and tried upgrading to 6.1 about 18 months ago. We have multi-lingual text stored in an Oracle database using US ASCII...

With cold fusion 7 install on redhat enterprise 4 how can you attach to a ODBC data source that is install on the same linux box? Unlike the windows...

i am trying to have a form post first to a cfm scripting page with a mailto function, and then repost to another form action. i tried to write the...