Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: sql queries updation improper

by derby (Abbot)
on Jul 15, 2007 at 15:30 UTC ( #626725=note: print w/replies, xml ) Need Help??


in reply to sql queries updation improper

Uhh ... yeah ... you're missing something. Read that second sql statement out loud while looking at your table. Do you see it? update table set field = value where id = key. Looks like the table is updated correctly to me. Still don't see it? Okay, here's a hint: where's cid come into play?

-derby

Replies are listed 'Best First'.
Re^2: sql queries updation improper
by Tobin Cataldo (Monk) on Jul 16, 2007 at 13:00 UTC
    The OP said that cid is autoincremented. With MySQL you don't have to handle an autoincremented column.

      Autoincrementing happens on the insert, not the update. There's not enough info in the OP but cid is either the primary key or part of a compound key and it needs to be part of the update sql. (sigh ... I need to remove *master of subtlety* from my CV).

      -derby
      This is where DBI]'s last_insert_id comes in handy ... oh, thats only in DBD::Pg but you can always select the highest id immediately after inserting a record.

      just another cpan module author

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://626725]
help
Chatterbox?
[tye]: that is what getlogin() certainly *used* to do. I don't believe that is what it certainly should do.
[davido]: /var/run/utmp is 664 i think.
[tye]: Note that my "man getlogin" says that it uses stdin when it should use /dev/tty (calling a glibc bug). But that does not appear to be the case when I test it. But maybe Perl's getlogin() is not using glibc's getlogin().
[oiskuu]: well, run a strace and see what the getlogin does for you.... As I said. SELinux probably has those security labels. But not regular linux.
[tye]: for example, read https://unix. stackexchange.com/ questions/146138/ loginuid-should-be -allowed-to-change -or-not-mutable-or -not
[tye]: I'm not using SELinux and it certainly appears to disagree with you. shrug
[tye]: Since you brought up /proc, oiskuu, I didn't see you respond to my suggestion of 'loginuid'. Does your /proc not have such?

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2017-06-23 19:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (554 votes). Check out past polls.