CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 how to use lookup sql with parameters

Print topic Send  topic

Author Message
Schalk
Posted: 09/02/2001, 3:06 PM

How can i use the lookup sql functionality with parameters that is transferd
from an other page.

for example

select art_id,position from article where categorie = (parameter from
webpage)





Alexey Alexapolsky
Posted: 09/03/2001, 1:47 AM

For ASP :

select art_id,position from article where categorie = " &
GetParam("param_name") &"

For PHP :

select art_id,position from article where categorie = " .
get_param("param_name") . "




--
Alex
Ceritfied CodeCharge Developer
Develop database-connected web sites
without coding: http://www.codecharge.com
ASP, ASP.NET, PHP, JSP, Perl, ColdFusion

Schalk <schalk@triple-it.com> wrote in message
news:9muaho$qpg$1@news.codecharge.com...
> How can i use the lookup sql functionality with parameters that is
transferd
> from an other page.
>
> for example
>
> select art_id,position from article where categorie = (parameter from
> webpage)
>
>
>
>
>
>

Frank Rocco
Posted: 09/04/2001, 5:52 AM

I believe you can issue something like this.
sSQL = "select art_id,position from article where categorie =" &
ToSQL(GetParam ("name"),"Text")

HTH

Frank Rocco
St. Elizabeth Medical Center
CC 2.0


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.