C
coder23
I posted the following in "Discussions in Inetserver ASP DB"..
....but maybe someone here can offer a solution
I have a Query in Access titled "SR_Control
I know you can pass values from ASP to the Query by providing the values (delimited) after the Query name
SQL = "SR_Control '1/1/2004', '5/1/2004', 'Blue'
rs1.Open SQL, cn1, etc... etc...
.... but is there a way to call the Query and Pass values to it from an SQL string? for example
SQL2 = "SELECT * INTO test2 FROM (SR_Control '1/1/2004', '5/1/2004', 'Blue');
- or -
SQL2 = "SELECT * INTO test2 FROM (" & SQL1 & ");
(the attempts above return errors.
....but maybe someone here can offer a solution
I have a Query in Access titled "SR_Control
I know you can pass values from ASP to the Query by providing the values (delimited) after the Query name
SQL = "SR_Control '1/1/2004', '5/1/2004', 'Blue'
rs1.Open SQL, cn1, etc... etc...
.... but is there a way to call the Query and Pass values to it from an SQL string? for example
SQL2 = "SELECT * INTO test2 FROM (SR_Control '1/1/2004', '5/1/2004', 'Blue');
- or -
SQL2 = "SELECT * INTO test2 FROM (" & SQL1 & ");
(the attempts above return errors.