By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Sending parameters?

P: n/a
To all the knowing folks out there:

Please help me! I'm new to this stuff...

I'm in the need to call a paramter-query stored in an MS-Access-DB
from an FrontPage-ASP-site.

Can anybody tell me of a way to send FP-field-values from an ASP via
ODBC (or else) to an Access-DB?
System: AccessXP, FP2002

ANY ideas or answers will be appreciated

DMW
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Sounds like a job for Superman.... umm... I mean ADO. Actually, I
think FP2002 will generate all the ASP stuff you need. (Ugly as sin,
but it works.)
Nov 12 '05 #2

P: n/a
That answer ain't much of a help...
Could u please be more specific?

DMW

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
Sounds like a job for Superman.... umm... I mean ADO. Actually, I
think FP2002 will generate all the ASP stuff you need. (Ugly as sin,
but it works.)

Nov 12 '05 #3

P: n/a
What you are asking is how to get the values from Form fields on an
HTML page, and use then for a query?

Okay, first, you need to determine if you are 'posting' the data, or
is it pushing it in the QueryString. (Posting is recommended, because
there is a restrictive size limit on the URL, which would limit the
QueryString, bad for memo's.). So, for example, if you have this as
an HTML Page:

<HTML>
<FORM Name="MyForm" Method="Post" action="mysearchresults.asp">
Search: <input type="text" name="SearchString" size=20>
<br>
<input type="submit" name="Submit" value="Submit">
</FORM>
</HTML>

In the 'mysearchresults.asp' page, you can retrieve the value of
'SearchString' with the request object. You'll need to use ADO to
access your database:

<%
Dim cnn
dim rs
dim strSQL
set cnn=server.CreateObject("ADODB.Connection")
with cnn
.Provider="Microsoft.Jet.OLEDB.4.0"
.Open "ThePath to your DB"
end with
set rs=server.CreateObject("ADODB.Recordset")
strSQL="Select * From tblData Where tblData.QueryField=""" &
Request.Form("SearchString") & ";"""
rs.Open strSQL,cnn,1,1
if rs.EOF=false then
rs.MoveFirst
end if
do until rs.eof=true
response.write rs.("MyDataField").value & "<br>"
rs.movenext
loop
rs.close
set rs=nothing
cnn.close
set cnn=nothing

(watch for word wrapping on my code....)
w.*****@web.de (DeadManWalking) wrote in message news:<52**************************@posting.google. com>...
To all the knowing folks out there:

Please help me! I'm new to this stuff...

I'm in the need to call a paramter-query stored in an MS-Access-DB
from an FrontPage-ASP-site.

Can anybody tell me of a way to send FP-field-values from an ASP via
ODBC (or else) to an Access-DB?
System: AccessXP, FP2002

ANY ideas or answers will be appreciated

DMW

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.