[interchange-cvs] interchange - edl modified 5 files

[interchange-cvs at icdevgroup.org]

User:      edl
Date:      2003-12-04 19:04:43 GMT
Modified:  dist/lib/UI/pages/include/Options/old item_option_matrix
Modified:           item_option_modular item_option_simple
Modified:  dist/lib/UI/pages/include/Options Matrix Simple
Log:
Added table= parameter to [query ...] tags in these files.

Revision  Changes    Path
1.2       +1 -0      interchange/dist/lib/UI/pages/include/Options/old/item_option_matrix


rev 1.2, prev_rev 1.1
Index: item_option_matrix
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/include/Options/old/item_option_matrix,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- item_option_matrix	12 Feb 2003 14:41:57 -0000	1.1
+++ item_option_matrix	4 Dec 2003 19:04:43 -0000	1.2
@@ -426,6 +426,7 @@
 	list=1
 	prefix=clone
 	db=1
+	table="[cgi mv_data_table]"
 	sql="SELECT DISTINCT code
 		 FROM  [cgi mv_data_table]
 		 WHERE o_matrix  >= '1'



1.2       +1 -0      interchange/dist/lib/UI/pages/include/Options/old/item_option_modular


rev 1.2, prev_rev 1.1
Index: item_option_modular
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/include/Options/old/item_option_modular,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- item_option_modular	12 Feb 2003 14:41:57 -0000	1.1
+++ item_option_modular	4 Dec 2003 19:04:43 -0000	1.2
@@ -211,6 +211,7 @@
 
 
 [query
+	table=options
 	hashref=master
 	sql="SELECT * FROM options
 			WHERE o_master = '[cgi name=item_id filter=sql]'



1.5       +2 -1      interchange/dist/lib/UI/pages/include/Options/old/item_option_simple


rev 1.5, prev_rev 1.4
Index: item_option_simple
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/include/Options/old/item_option_simple,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- item_option_simple	8 Sep 2003 12:25:18 -0000	1.4
+++ item_option_simple	4 Dec 2003 19:04:43 -0000	1.5
@@ -105,7 +105,7 @@
 
 <TABLE BORDER=0><TR><TD VALIGN=TOP>
 
-[query list=1 sql="select * from options where sku='[filter op=sql interpolate=1][cgi item_id][/filter]' and o_group is not null"]
+[query list=1 table=options sql="select * from options where sku='[filter op=sql interpolate=1][cgi item_id][/filter]' and o_group is not null"]
 [list]
 [if-sql-data options o_group]
 [calc] $Scratch->{mod_code} = q{[sql-code]}; $Scratch->{mod_code} =~ s/-/_/g; return;[/calc]
@@ -180,6 +180,7 @@
 <BR><BR><B>[L]Clone an existing option set[/L]:</B><BR>
 
 [query
+	table="[cgi mv_data_table]"
 	list=1
 	prefix=clone
 	sql="select DISTINCT sku from [cgi mv_data_table] where o_group <> ''"



1.2       +1 -0      interchange/dist/lib/UI/pages/include/Options/Matrix


rev 1.2, prev_rev 1.1
Index: Matrix
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/include/Options/Matrix,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- Matrix	12 Feb 2003 14:41:57 -0000	1.1
+++ Matrix	4 Dec 2003 19:04:43 -0000	1.2
@@ -457,6 +457,7 @@
 <SELECT NAME=ui_clone_id>
 <OPTION VALUE=""> --
 [query
+	table="[cgi mv_data_table]"
 	list=1
 	prefix=clone
 	db=1



1.8       +2 -1      interchange/dist/lib/UI/pages/include/Options/Simple


rev 1.8, prev_rev 1.7
Index: Simple
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/include/Options/Simple,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- Simple	8 Sep 2003 12:25:18 -0000	1.7
+++ Simple	4 Dec 2003 19:04:43 -0000	1.8
@@ -127,7 +127,7 @@
 
 <TABLE BORDER=0><TR><TD VALIGN=TOP>
 
-[query list=1 sql="select * from [scratch option_table] where sku='[filter op=sql interpolate=1][cgi sku][/filter]' and o_group is not null and o_group <> ''"]
+[query list=1 table="[scratch option_table]" sql="select * from [scratch option_table] where sku='[filter op=sql interpolate=1][cgi sku][/filter]' and o_group is not null and o_group <> ''"]
 [list]
 
 <div style="border: 1px solid black; margin-bottom: 3px">
@@ -247,6 +247,7 @@
 <div class=titlebox style="margin-bottom: 4px">[L]Clone an existing option set[/L]</div>
 
 [query
+	table="[scratch option_table]"
 	list=1
 	prefix=clone
 	sql="select DISTINCT sku from [scratch option_table] where o_group is not null and o_group <> ''"