Search found 21 matches

by laknal
Sun Nov 19, 2006 6:01 pm
Forum: Databases
Topic: Insert after update trigger
Replies: 7
Views: 964

Insert after update trigger

Hi,

I did not find example for mulitple columns update upon insert.

Please give me example.
by laknal
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
by laknal
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:
#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
Thanks
by laknal
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_...
by laknal
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.
by laknal
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...
by laknal
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.
by laknal
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?
by laknal
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.
by laknal
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 ...
by laknal
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
by laknal
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...
by laknal
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.
by laknal
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...
by laknal
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...