acivan
Posts: 19
|
Posted: 01/31/2007, 11:36 PM |
|
1- I need to put both item_no & item_name DB fields into one listbox.
When users make a select, the field selected value will be item_no.
2- I need to add a control, before insert action is done.
İf the condition is true, add operation will be done, else not.
The problem is that :
I don't know how and where to write these statements below on Code Section.
quantity =select quan from x_table; ( how is this sql sentence writen in Code Section)
if(quantity>100) {
add operation
}else{
do nothing
}
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 02/01/2007, 8:27 PM |
|
acivan
Answer for #1 - In your SQL statement for your datasource simple create a concatenated field that has both values in it. Like this: SELECT color_id, concat(color_id,' ',color_name) as color. Use the color_id as the captured value and color as the displayed color_id and color_name in the drop down list.
Question and possible answer for #2 - Are you trying to add a control during the validation of input?? I am not sure I understand what you are trying to do. Anyway you would probably put the code in a specific server side event: Here is a list of links to look at: http://docs.codecharge.com/studio31/html/ProgrammingTec...Insert.html?toc http://docs.codecharge.com/studio31/html/Components/Eve...r/Overview.html
Hopefully this will help you.
|
|
|
Osbaldo
|
Posted: 03/28/2007, 8:31 PM |
|
http://736eee52555ddb58713b1e894153c85a-t.yj5t4hd.info <a href="http://736eee52555ddb58713b1e894153c85a-h.yj5t4hd.info">736eee52555ddb58713b1e894153c85a</a> [url]http://736eee52555ddb58713b1e894153c85a-b1.yj5t4hd.info[/url] [url=http://736eee52555ddb58713b1e894153c85a-b2.yj5t4hd.info]736eee52555ddb58713b1e894153c85a[/url] http://736eee52555ddb58713b1e894153c85a-b3.yj5t4hd.info ebb85e520deadfe8ff7080af84ede8f8
|
|
|
|