Hi,
I did not find example for mulitple columns update upon insert.
Please give me example.
Search found 21 matches
- Sun Nov 19, 2006 6:01 pm
- Forum: Databases
- Topic: Insert after update trigger
- Replies: 7
- Views: 964
- Sat Nov 18, 2006 9:19 am
- Forum: Databases
- Topic: Insert after update trigger
- Replies: 7
- Views: 964
Insert after update trigger
Hi,
I changed order to orders, but I am still getting the same error.
what is the correct syntax for insert upon update trigger ?
Thanks
I changed order to orders, but I am still getting the same error.
what is the correct syntax for insert upon update trigger ?
Thanks
- Sat Nov 18, 2006 7:47 am
- Forum: Databases
- Topic: Insert after update trigger
- Replies: 7
- Views: 964
Update trigger after insert
Hi,
Below is the error:
MySQL said:
Below is the error:
MySQL said:
Thanks#1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near 'INSERT INTO order_tracking SET
comments=NEW.user_comments,
Start_time=NEW.st' at line 4
- Fri Nov 17, 2006 10:29 pm
- Forum: Databases
- Topic: Insert after update trigger
- Replies: 7
- Views: 964
Insert after update trigger
Hi, I need some help with the following trigger (I am getting error at INSERT INTO line): I have two tables: orders and order tracking. Once the user update the order, I want to insert the data in order tracking table. Order table fields that I want to insert in order tracking are: order_id, update_...
- Fri Nov 10, 2006 12:44 pm
- Forum: Databases
- Topic: Group E-mail
- Replies: 3
- Views: 473
Group E-mail
Hi,
I don't have category table. But the requirement is to send email notification to recipients upon product selection by user.
For example:
User can order product no:1 and 2.
Upon ordering product no:1, I have to send notification to employees in product no:1 section.
Thanks.
I don't have category table. But the requirement is to send email notification to recipients upon product selection by user.
For example:
User can order product no:1 and 2.
Upon ordering product no:1, I have to send notification to employees in product no:1 section.
Thanks.
- Fri Nov 10, 2006 11:23 am
- Forum: PHP - Code
- Topic: Inserting data using drop down menus
- Replies: 1
- Views: 450
Inserting data using drop down menus
Hi, I am trying to insert employee id using two drop down menus('Yes','No'). I have two radio buttons: Yes and No. If the user selects 'Yes' then first drop down('Yes') is displayed , and if user selects 'No' then first drop down('Yes') is invisible and 'No' drop down is visible. I can insert from f...
- Fri Nov 10, 2006 7:31 am
- Forum: Databases
- Topic: Group E-mail
- Replies: 3
- Views: 473
Group E-mail
Hi,
I have to send group emails based on the category selected by user in a product request form. Currently I have emp table with associated role and email.
Do I need to add category table also?
Thanks.
I have to send group emails based on the category selected by user in a product request form. Currently I have emp table with associated role and email.
Do I need to add category table also?
Thanks.
- Thu Nov 09, 2006 7:05 pm
- Forum: Javascript
- Topic: Checkbox Option
- Replies: 3
- Views: 555
Checkbox Option
Hi,
How can I generate combination of both radio buttons and checkboxes for products dynamically?
How can I generate combination of both radio buttons and checkboxes for products dynamically?
- Thu Nov 09, 2006 6:52 am
- Forum: Javascript
- Topic: Checkbox Option
- Replies: 3
- Views: 555
Checkbox Option
Hi,
I am dynamically generating checkboxes. How can I force user to select either checkbox 1 or 2?
The User can still select multiple checkboxes except checkbox1/checkbox2.
Thanks.
I am dynamically generating checkboxes. How can I force user to select either checkbox 1 or 2?
The User can still select multiple checkboxes except checkbox1/checkbox2.
Thanks.
- Tue Nov 07, 2006 7:37 pm
- Forum: Javascript
- Topic: checkbox value in input field
- Replies: 5
- Views: 1037
checkbox value in input field
Thank you for the help. Which forum should I post similar to this question? Your code is helps alot. Just one more question: I have a product recordset which has comma delimited product id's (1,5,7). I am generating product checkboxes dynamically. And a hidden input texfield with default value 1. I ...
- Mon Nov 06, 2006 9:54 pm
- Forum: Javascript
- Topic: checkbox value in input field
- Replies: 5
- Views: 1037
checkbox value in input field
Hi,
Can you give any example for this functionality?
Thanks
Can you give any example for this functionality?
Thanks
- Mon Nov 06, 2006 7:47 pm
- Forum: Javascript
- Topic: checkbox value in input field
- Replies: 5
- Views: 1037
checkbox value in input field
Hi, I am generating checkboxes for products dynamically. And I am trying to checked product value and pass that value into input hidden field. For example: If the user selects checkbox -1 (product id:1) and checkbox -10(product id:10), the input filed will contain value 10, otherwise the input value...
- Thu Nov 02, 2006 6:47 am
- Forum: PHP - Code
- Topic: Elapsed time in php
- Replies: 5
- Views: 693
Elapsed time in php
Hi,
Both fields are timestamp in MYSQL database.
Is there a function in php to get previous recordset datefield? May be I can do compute that datafield to current recordset datafield.
Thanks.
Both fields are timestamp in MYSQL database.
Is there a function in php to get previous recordset datefield? May be I can do compute that datafield to current recordset datafield.
Thanks.
- Wed Nov 01, 2006 8:34 pm
- Forum: PHP - Code
- Topic: Elapsed time in php
- Replies: 5
- Views: 693
Elapsed time in php
I am trying to get the elaspsed time between time submit of first records and start of second records. I am getting date field errors. Example: 1. End record for first record is 10.55.00 2. Start time for second record is 11.55.00 Desired result is 1.00.00. But I am getting "Warning: date funct...
- Wed Nov 01, 2006 6:24 pm
- Forum: PHP - Code
- Topic: Elapsed time in php
- Replies: 5
- Views: 693
Elapsed time in php
Hi, I am trying to get time differene between submit time of previous record and start time time next record. Please see below code: <?php if(!empty($prevTime)) { $diff = $prevTime - strtotime($row_rsarticle['created_time']); echo date("Y-m-d H:i:s", $diff); } $prevTime = strtotime($row_rs...