Confirmation page

[Matt]

I have a form that collects several checkbox inputs. the submit is set
to POST to a custom script (confirm.asp)

on confirm.asp I have:
<p><!--webbot bot="ConfirmationField" S-Field="checkbox" --></p>

When I run the page, this code properly displays the checkboxes that
were selected, like this:
97, 98, 99, 100, 155, 156, 157

I need to use these numbers in a query to pull up images from my
database. What is the proper way to use these values in a query?

Thanks

Matt

 

[Matt]

Ok, I have broken down that previous string of comma delimited values
(2,4,6,8,etc..) into an array, "strArray". Is it possible to use this
array as criteria for a query THROUGH the Database Results Wizard?

I am thinking something like

SELECT [field1] from [table_A] where [ID] = strArray(i)

but can't achieve the desired result.
Thanks

Matt

 

[Stefan B Rusynko]

You can't use FP confirmation fields on a .asp page (only on .htm pages)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have a form that collects several checkbox inputs. the submit is set
| to POST to a custom script (confirm.asp)
|
| on confirm.asp I have:
| <p><!--webbot bot="ConfirmationField" S-Field="checkbox" --></p>
|
| When I run the page, this code properly displays the checkboxes that
| were selected, like this:
| 97, 98, 99, 100, 155, 156, 157
|
| I need to use these numbers in a query to pull up images from my
| database. What is the proper way to use these values in a query?
|
| Thanks
|
| Matt
|

 

[Stefan B Rusynko]

Not unless you loop thru each array item

For i=0 to Ubound(strArray())
SELECT [field1] from [table_A] where [ID] = strArray(i)
' open your RS, get your data, show your pic, close the RS
Next

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| Ok, I have broken down that previous string of comma delimited values
| (2,4,6,8,etc..) into an array, "strArray". Is it possible to use this
| array as criteria for a query THROUGH the Database Results Wizard?
|
| I am thinking something like
|
| SELECT [field1] from [table_A] where [ID] = strArray(i)
|
| but can't achieve the desired result.
| Thanks
|
| Matt
|

 

[Matt]

How do I run the loop in DBRW? An alternative is to use the unsplit
string whose value is

1,3,5,7,56,102

in a custom query

Select [field] from

where [id] like ("& strVar &")

but I can't get that to work either

 

[Matt]

How do I run the loop in DBRW? An alternative is to use the unsplit
string whose value is

1,3,5,7,56,102

in a custom query

Select [field] from

where [id] like ("& strVar &")

but I can't get that to work either

 

[Stefan B Rusynko]

You don't
You need to learn to hand code your ASP for anything as complex as that

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| How do I run the loop in DBRW? An alternative is to use the unsplit
| string whose value is
|
| 1,3,5,7,56,102
|
| in a custom query
|
| Select [field] from

where [id] like ("& strVar &")
|
| but I can't get that to work either
|