URL script

[rivet]

I am trying to find the correct sting that will perform a search on the web. The ASP form method is POST so the result page does not show the final string.

Search Page:

http://www.cpso.on.ca/Doctor_Search/number_srch.asp?Scr=FIRST

Sample Number

70177

My Best guess:

http://www.cpso.on.ca/Doctor_Search/number_srch.asp?Type=CPSONUM&SCR=FIRST&CPSONO=70177&Easysrch=Start+Search

[Leb i Sol]

POST your SQL string.....

the form part seems right.....your page returns results....soooo where is the problem?

http://www.asp101.com/samples/getpost.asp

All the best!

[Leb i Sol]

here is dynamic SQL string approach to searching joined tables

http://www.tdsf.co.uk/tdsfdemo/

All the best!

[Garry Claridge]

In ASP,

the "POST" data is accessed with Request("Type")

the "URL" data is accessed with Request.QueryString("Type").

The link by Leb "asp101.com" shows how each would be applied in the number_srch.asp page.

Hope this helps.

Garry

[rivet]

sorry... I should have mentioned that the web site is not mine, it is a site that the client uses and I am trying to give them a shortcut in FMP that will look up the number for them.

[Garry Claridge]

You should be able to POST a Form, to that site, from an FM solution.

You can have more than one Form in a page. You can also use some Javascript to determine which is sent where and when!

Use one like this:

<form name="cpsoform" method="post" action="http://www.cpso.on.ca/Doctor_Search/number_srch.asp">

<input type="hidden" name="Type" value="CPSONUM">

<input type="hidden" name="SCR" value="FIRST">

<input type="hidden" name="CPSONO" value="[FMP-Field:cpsono]">

</form>

....

<a href="Javascript:document.cpsoform.submit();" target="_blank">Goto CPSO</a>

If you want to make this a link from a listing, make these changes:

<input type="hidden" name="CPSONO" value="">

.....

[FMP-Record]

<a href="Javascript:document.cpsoform.CPSONO.value="[FMP-Field:cpsono]";document.cpsoform.submit();" target="_blank">Goto CPSO</a>

[/FMP-Record]

All the best.

Garry

[rivet]

to put it even simpler (i hope) what is wrong with this string"

http://www.cpso.on.ca/Doctor_Search/number_srch.asp?Type=CPSONUM&SCR=FIRST&CPSONO=70177&Easysrch=Start+Search

[Garry Claridge]

You will not be able to use a string!

The way the "asp" script is written will not allow the use of a string. This is generally for security reasons.

The only way is via a Form. You can check the Form at:

http://www.clarsys.com.au/cpso.html

Good Luck.

Garry

[rivet]

Thanks for all you help!