Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tgilbreath

    Cold Fusion Error/Access Error - "Invalid precision value"

    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...
  2. tgilbreath

    Cold Fusion Error/Access Error - "Invalid precision value"

    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...
  3. tgilbreath

    Cold Fusion Error/Access Error - &quot;Invalid precision value&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!!
  4. tgilbreath

    Cold Fusion Error/Access Error - &quot;Invalid precision value&quot;

    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...
  5. tgilbreath

    CFFILE Results Display Problem

    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...
  6. tgilbreath

    CFFILE Results Display Problem

    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...
  7. tgilbreath

    Access/Permissions Problem

    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.
  8. tgilbreath

    Access/Permissions Problem

    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...
  9. tgilbreath

    &quot;Type Mismatch&quot; Error on AccessDB/ASP Update SQL Statement

    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...
  10. tgilbreath

    &quot;Type Mismatch&quot; Error on AccessDB/ASP Update SQL Statement

    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...

Part and Inventory Search

Back
Top