Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
perl and sql trigger
thanx for the reply mike, everything runs great doing raw inserts from analyzer or even T-Sql. we just did the testing with the new code: $sql = "insert into testdata (data) values ('hello11')"; $action = $dbh->prepare($sql) ; $action->execute ; $action->finish ; and it kicked right along... -
perl and sql trigger
update: i wrote this little insert script with a trigger on the table. it worked just fine. i think when the person i am working with gets back on teusday, i am going to change the statement to a commit and execute style for testing. use DBI ; $user = 'nw' ; $passwd = 'nw' ; $dbh =... -
perl and sql trigger
thanx m.brooks, i uncommented the use strick and once i corrected my error, it did run clean, but still hangs on the trigger on the first insert. hhhhhmmmmmmm......... sub RLGSDScale { my (@datalist) = @_; mysyslog('notice',"Insert Start @datalist"); #Un-comment to see the data #... -
perl and sql trigger
commented out use strict; will see if this gets it going. -
perl and sql trigger
thanx m.brooks was a great suggestion but it threw this error: Bareword "finish" not allowed while "strict subs" in use never seen this before. sean -
perl and sql trigger
greetings, i have been working on an insert statement that inserts data into an sql 2000 table, coming from a linux 7.3 running some perl scripts that are net telnet to serial devices. the inserts run great until somebody put a trigger on one of the tables. once that happened the first insert... -
Serial string carriage return
programmed scale to send LF and now everything is working properly. thanx sean -
Serial string carriage return
fixed, changed to $conn->waitfor('/[\015\013]/'); and it is now inserting data. next on the list is to have it grab the string after '/[\015\013]/' and not before. sean -
Serial string carriage return
in a follow up here is what i have found. in outputing the string to a log (when looping through with just looking for ',' this popped up! ^MSIZEDIST. ^M would be the end of the string and SIZEDIST is the start of the new string. once i get it figured out how to search for ^M i think things will... -
Serial string carriage return
thanx trojan, with our other scales the \r has been working great, but for some odd reason this one scale is giving us heartache. i have even gotten to the point where i am looking for any RE associated with ascii $conn->waitfor(String => '/[:ascii:]/'); thought about trying... -
Serial string carriage return
greeting all, i have a perl script that net telnets to a serial device, which waits for data to insert into a DB. I have been battling this serial device, which is programmed to send a carriage return at the end of each string. which it is (i telnet to it and watch the strings and it does do a... -
DateTime appears to be converted to String, how come?
I am generating a Crystal 6.0 report. I cannot use any of the Date functions, such as Month(), Year() because it is expecting a Date/Datetime field. I have the fields defined as DateTime in SQL7. In Crystal, I have "Report Options" setting of "Convert Date-Time field to...- roadrash
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
