Search results for query: *

Thank you, I forgot about my WHERE statements....but I've entered them, and now I'm getting this error: --------------- Error Occurred While Processing Request Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax...

Ok, now I'm using the SQL update...my updates are looking like this: <code> <cfquery name=&quot;UpdateTable1&quot; datasource=&quot;ratesserver&quot;> UPDATE HECUEffectiveDate SET EffectiveDate='#form.EffectiveDate#' </cfquery> <cfquery name=&quot;UpdateTable2&quot...

I KNEW someone was going to say do it in pure SQL....I didn't think it would cause a problem like that though! But I will definitely give it a try, thanks for the input!!

Hi guys- Doing a standard update, but on multiple tables....everytime the update code is ran, I get this error: ------------------ Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value...

Carl- Thanks, that was it exactly...and yes, I'll convert the insert to the CFQUERY. I was misunderstanding the scope of the upload contents. And regarding the select box, that was a mistake on my part, I meant to put the output tags around the option tag, thanks for pointing that out...

Hi guys- Basically, I've got a page that is displaying results from an Access DB that is comprised of inserts from a form. When the information is inserted, CFFILE is also being used to upload the file to a specified directory. However (and I've seen this problem in other forums, but NONE of...

Yes, the DB has read and right permissions. This only happened when switching providers, but the folder it is in has full permissions as well.

Hi guys...I'm stumped....I've got an ASP/Access based application (DSN-less connections)...that was working perfectly....just moved it to another hosting provider, testing it....when logging in, I get the following error: Microsoft JET Database Engine error '80040e09' Cannot update. Database...

Thanks for the help guys....that cleared up THAT error..now, upon selecting an entry from the dropdown, I get this: ADODB.Field error '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /admin/resource_update.asp...

Hi guys- Not sure what's going on here...I've got a dropdown box populated from a DB...I have all this code that is supposed to update the record. But it keeps giving me : -------------------------------------------- Microsoft VBScript runtime error '800a000d' Type mismatch...