Re: MSSQL ?

From: Date: Sun, 13 Aug 2000 15:02:21 +0000
Subject: Re: MSSQL ?
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-1759@lists.php.net to get a copy of this message
Hi Jeroen: > > If my page is called I get an error... > > <<snipped>> > > I'll attach the source, can someone help me out quickly ? > Attach it, send it, feel free. This >> symbol means code continues next line This line is your problem.... $query = "INSERT INTO tblWebRMA >>(CustCode,ProdCode,SerialNr,Acc,PropPack,Bil,ProbDescr, >> PurDate,Special,Host1,Host2,DateIn) values >>('$txt_custcode','$txt_product', '$txt_serialnr', >> '$chk_accesinc','$chk_proppack','$chk_invoice','$txt_probdesc', >> '$txt_purchdate','$txt_special', '$host1', '$host2', 'GETDATE()');" Fisrtly some debugging tips... 1) Put an 'echo "<something>";' in after every line of code. PHP will print the numbers till it quits. If you use different <somethings> you can easily see where PHP bugs out. 2) If PHP quits at line 15, look at line 14. That'll probably be where the error is!!! 3) Comment out any new lines of code. Run the script, if all is well, uncomment each line till you get the error. There lies the problem. Anyway, your problem is here ,'GETDATE()');" It should read 'GETDATE()')"; The " and ; were backwards. It runs with that changed. Regards, EF webmaster@ixion.org Not everything in black and white makes sense

« previous php.windows (#1759) next »