Re^2: datatype from SQL

well, i tried your suggestion, changing $newUID to $newUID->[0], but it gave me the following error:

Can't use string ("1") as an ARRAY ref while "strict refs" in use at n
+ewsedit.pl line 61.
[download]

so i think that $newUID must be the scalar ref, not an array ref, right?

Comment on Re^2: datatype from SQL Download Code

Replies are listed 'Best First'.
Re^3: datatype from SQL by VSarkiss (Monsignor) on Jun 23, 2006 at 17:42 UTC
Something doesn't add up. If you're calling `fetchrow_arrayref`, then your `print` example should show `ARRAY(0x123456)` or some such. That error message you're getting indicates the actual value (not a scalar ref or an array ref) is contained in `$newUID`, which is not consistent with the return value from that method. Stop, take a deep breath, make sure your code says what you think, and then go through brian's Guide to Solving Any Perl Problem. Do not rebuke them with harsh words ... but rather lead them gently - with URLs - so that they may learn wisdom.	[reply] [d/l] [select]
Re^3: datatype from SQL by derby (Abbot) on Jun 23, 2006 at 17:45 UTC
What version of DBI are you using and which DBD driver? You're use of $in{param} leads me to believe you're also using cgi-lib (instead of CGI) and may have a very old installation. -derby Update: And is this an XY Problem ... are you just trying to ~~get~~ create the next UID ... if so, most DB's have an auto-incrementing field feature.	[reply]