Ok, now I'm really worried. That error message is telling you quite clearly that you're attempting to access the firstname field, from the field list table. And you can't, because there's no such field in that table
I'm worried because there are no appropriate references to such a field, table or even a variable called $firstname in your code
Oh, hang on:
my $sth = $dbh->prepare("INSERT into people (fornavn,
efternavn, cpr, adresse, zip, city, tjenestested)
values ($fornavn, $efternavn, $cpr, $adresse, $zip,
$city, $tjenestested)");
will result in the SQL statement being something along the lines of:
INSERT into people(fornavn...) values (tommy, ...);. Which is, of course, incorrect: those value strings need to be quoted. You see all those earlier posts with many, many question marks in them? Well, this is exactly why they were there. Try changing your statement in a similar fashion
| [reply]
[d/l]
[select] |
Yeah, that's not good. If tommyw's suggestion doesn't
fix the problem (which i think it will), then
i recommend logging directly into
the mysql database server and issue the following commands:
- show databases - this will show you a list of
the available databases, make sure 'um' is among, them -
if not, then find out which database you need to use
- use um - assuming you found it in #1
- desc people; - (notice the semi-colon) this will
give you a tabular text table containing the field names,
their types, and more stuff about the fields.
If you do not see 'firstname' among them - well, that's
beyond the scope of this site. But i can point you to
the mysql docs, in
particular, the
alter table syntax.
Pertaining to your 3 errors that you listed (which should
have been wrapped in <code> tags i might add),
the first and third errors are most likely just side
effects from the second error. Fix the second and the
other two should go away as well. :)
good luck!
jeffa | [reply]
[d/l] |