October 2, 200322 yr 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
October 2, 200322 yr 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!
October 2, 200322 yr here is dynamic SQL string approach to searching joined tables http://www.tdsf.co.uk/tdsfdemo/ All the best!
October 2, 200322 yr 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
October 2, 200322 yr Author 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.
October 2, 200322 yr 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
October 3, 200322 yr Author 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
October 3, 200322 yr 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
Create an account or sign in to comment