tak for svaret men jeg havde pasted den forkerte stored procedure så here we
go again.
<error>
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'5010'.
/spstat/rap7/rap7update.asp, line 6
</error>
<ASP>
<!--#include file="../statfuncs.asp"-->
<%
'connect to db
odbc_dbconn()
if request.form("paid") = "on" then
call conn.execute("rap7update(" & request.querystring("id") & ", 1,
GETDATE())", , adcmdstoredproc)
else
call conn.execute("rap7update(" & request.querystring("id") & ", 0, null)",
, adcmdstoredproc)
end if
'kill db connect
dbconnkill()
'redirect
response.redirect("../rapport7.asp")
%>
</ASP>
<stored procedure>
CREATE PROCEDURE [rap7update]
(@ClaimID_1 [int],
@TransferDate_2 [datetime],
@Transferred_3 [bit])
AS UPDATE [spstat].[dbo].[ClaimTransactions]
SET [TransferDate] = @TransferDate_2,
[Transferred] = @Transferred_3
WHERE
( [ClaimID] = @ClaimID_1)
GO
</stored procedure>
På forhånd tak,
Andreas Hjordt
Peter Lykkegaard wrote in dk.edb.internet.webdesign.serverside.asp:
> "Andreas Hjordt" <andreas.hjordt@scalepoint.com> wrote in message
> news:9lgguv$gp8$1@sunsite.dk...
> > Jeg prøver at udføre en stored procedure med tre argumenter men
> > jeg får en syntaks fejl.
> >
>
> > call conn.execute("rap7update(" & request.querystring("id") &
> _______________^^^^^^^^^
>
> > CREATE PROCEDURE [rap7update_2]
> ______________________^^^^^^^^^^^
>
>
> Ellers hiv din sql statement ud fx vhs Resonse.Write og fyr den af i Query
> Analyzer
>
> mvh/Peter Lykkegaard
>
>
>
>
--
Vil du lære at kode HTML, XHTML, CSS, SSI eller ASP ???
- Pædagogiske tutorials på dansk
- Kom godt i gang med koderne
KLIK HER! =>
http://www.html.dk/tutorials