okay - 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 fred'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', 'numPriorit
y', 'txtState', 'txtUser', 'txtSteps', 'txtExpected', 'txtObserved', '
frmStatus', 'NOW')!

this is the string conversion problem i knew was there, but hadn't
gotten far enough to discover. firebird doesn't know what to do with
a string where it is expecting a numeric...currently RingTFM...

as per usual, all help is greatly appreciated.

cheers,

jon-david

-----Original Message-----
From: Fred Vos [mailto:fred.vos@...]
Sent: Tuesday, March 26, 2002 1:05 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] newbie php/fb insert ? (2)


.... and you must use single quotes around the string values

Fred


------------------------ Yahoo! Groups Sponsor ---------------------~-
->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/67folB/TM
---------------------------------------------------------------------
~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/