Here is an example:

Dim objConn, strSQL, rsGetCustomerName
Set objConn = Server.CreateObject("ADODB.Connection")
Set rsGetCustomerName = Server.CreateObject("ADODB.Recordset")

custID = "1000002"

strSQL = "spSeminarGetCustomer " & custID
rsGetCustomerName.Open strSQL, objConn, 3

On 7/27/05, kevtey <kevtey@...> wrote:
> hi i would like to know how can i call a stored procedure inside
> firebird DB.
>
> in isql i tried select * from <procedure_name>
>
> i put this inside ASP
> prscommon.locktype =2
> pstrsql = "select * from reset_generator1;"
> prscommon.open pstrsql , padocon
>
> but i got error of table not found..
> how can i called the stored procedure???
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ________________________________
> YAHOO! GROUPS LINKS
>
> Visit your group "firebird-support" on the web.
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> ________________________________
>