Re: Re: Newbie? - help inserting into firebird1.0

if APP_VERSION is defined as decimal you can not insert a string. So leaving away the quotes around $numVersion should bring you closer. Lutz jdschlough@virtucomcsi.com (Jon-David Schlough) writes: > you're right Lutz, that is not my only problem- turns out this statement is > wrought with errors :| > > i should not have been referring to those values as variables...stupid lamer > mistake, just the name works...also, changed the double quotes to single > quotes, per Lutz's suggestion, and that worked as well...so i'm getting > closer. > > now it tosses: > > Warning: InterBase: conversion error from string "numVersion" in > C:\Inetpub\dev_root\slugbug\issue_send4.php on line 19 > Error. Can't insert the record with the query: insert into BUGS (APP, > APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, > EXPECTED, OBSERVED, STATUS, OPENED) values ( > 'txtApp','numVersion','txtBuild','txtOs', > 'frmSeverity', 'numPriority', > 'txtState', 'txtUser', 'txtSteps', 'txtExpected', > 'txtObserved', > 'frmStatus', 'NOW')! > > so this is the string conversion problem i knew was there, but hadn't gotten > far enough to discover. currently RingTFM... > > as per usual, all help is greatly appreciated. > > cheers, > > jon-david >