questions about bind_param and mysql trace data included

below I have a snippet from a trace file read out for a section of code below. The problem seems to be with '$sth->bind_param (2,$rh_row->{prop_str_addr});' The first Bind works fine however the next one in the line listed produces a null entry per the trace file. I have verified that the data

Re: Data dump using perl with mysql won't update

> If you want them set to NULL using DBI, you have to bind undef to the > proper parameter. Is that what you're doing, or are you binding > something else, such as 0 or the empty string? > No the initial values in the DB are set to null, with the exception of one field. I'm trying to assign th

Data dump using perl with mysql won't update

before I begin sorry for the cross post but i'm desperate The routine in question is below. It's pretty straight forward its a series of loops which basically matches the row then dumps data stored in hash ref into the DB. for some reason the script runs with no errors (ran with strict) I can ve

best way to query multiple searchs --was bind_param and mysql

> I must admit that I do not understand what you really have in mind > with"a search for multiple strings". If you are referring to > specific MySQL > features, could you please be so kind and provide a pointer to the > relevant docs? maybe if I explain what i'm trying to do. I have a hash tha

Re: questions about bind_param and mysql

I'm attempting a search for multiple strings using the bind_param option. My understanding is the server will flag each string then after each string has been selected and exicuted I can then do a fethall_array. However the the results only include the last string searched. any ideas. an exa

Re: questions about bind_param and mysql

> Should work, as long as your parameters are all strings. With numbers > you currently need to specify the type (for example DBI::INTEGER or > similar, written from memory) as a third parameter. do I need to specify the DBD module in addition to DBI ? After reading the module info on CPAN it s

questions about bind_param and mysql

I have a snippet of code below. I'm trying to use teh bind_param option to select multiple rows using a foreach loop. after doign some reading I realized this is supprted through DBD are there any special measures that I need to take to make bind_param work. ## select rows in table based on

unable to access mysql as anyone besideslinux user= root

whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql -

unable to start mysql new install

I am new so forgive me if i'm asking a stupid question. I did a reinstall (rpm) of my mysql 3.23 running on SuSE8.0 when I tried to run msql after running msql_install_db I get the error below. Just to give some bacground info. After getting connection errors regarding permissions (see previous

unable to update root password or connect.

This is a new install of mysql 3.23 on a SuSE8.0 Box. I installd everythign via suse rpms. I ran mysql_install_db when I to run the update root password I get the following error. I'm logged into the server via ssh as root while exicuting the commands. any ideas. inglewood:/etc # mysqladmin