Hi Kris! Looks like you have things well in hand.
I'm not using Win32::ODBC for my little project, I'm using something called "DBI", I
THINK that they do basically the same thing though...if I'm wrong someone please set
me right.
I've successfully put new data into my database from a web page at the time of this
post now :) I have run into trouble doing it for the entire record set. I'll
explain...
My test of the process only put data into the first field of the record, and just left
the rest blank. But it worked!
So now I'm playing with this line...I think it's where my error is.
$sqlstatement = "INSERT INTO Full (freq, loc, desc, freqtype, cat, call, tx) VALUES
($newfreq, $newloc, $newdesc, $newfreqtype, $newcat, $newcall, $newtx)";
Can someone set me straight on this?
I've also tried a few variations such as:
$sqlstatement = "INSERT INTO Full (freq, loc, desc, freqtype, cat, call, tx) VALUES
($newfreq, '$newloc', '$newdesc', '$newfreqtype', '$newcat', '$newcall', $newtx)";
and
$sqlstatement = "INSERT INTO Full (freq, loc, desc, freqtype, cat, call, tx) VALUES
($newfreq, \'$newloc\', \'$newdesc\', \'$newfreqtype\', \'$newcat\', \'$newcall\',
$newtx)";
Because those fields are string types but that should not matter should it?
