I'm not sure why you are trying to do what you want to do. By the looks of
it what you actually want to do is to creat an SP to insert a new users
details into the db. If so you don't do this using CF. You run the SQL you
have in SQL Query Analyser against the DB you want it to affect and then you
call the SP in your CF by either using CFSTOREDPROC (which you should) or by
using CFQUERY and running the SQL "EXEC sp_AddUser param1 param2 param3
etc......." (not recomended). In doing this you have tightened up security
and the SQL is cached so an execution plan exists and hence the SQL doesn't
need to be parsed.
If however you are trying to write a generic web based utility whereby users
can create there own sp's then you are on the write traks although you
should have an SP (which you write) which accepts parameter in order to
create other sp's within your db although this is not simple and certainly
challenging if you are only starting out with SP's!
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 14:26
To: CF-Talk
Subject: RE: Stored Procedures
Which is what I am looking for, if it doesn't exist to create it... I am
new to storedprocs. Although I know the syntax I haven't used them much
with CF yet...
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 16 July 2001 11:14 PM
> To: CF-Talk
> Subject: RE: Stored Procedures
>
> Never tried it, you may have to put semi colons at the end of every
sql
> statement if ODBC terms them as separate SQL stements. I would
suggest that
> you write and call an SP that creates SP's for you.
>
> -----Original Message-----
> From: Andrew Scott [mailto:[EMAIL PROTECTED]]
> Sent: 16 July 2001 14:09
> To: CF-Talk
> Subject: RE: Stored Procedures
>
>
> So you are saying I could do this then....
>
> <cfquery name="sp_Adduser" datasource="datasource">
> IF not EXISTS (SELECT * FROM sysobjects WHERE name =
> "sp_Adduser1" AND type = "P")
> CREATE PROCEDURE sp_AddUser
> @username varchar(50),
> @password varchar(12),
> @Firstname varchar(50),
> @Familyname varchar(50),
> @ID varchar(50),
> @ID_Member varchar(50) output
> AS
> set nocount on
> if not exists (select ID_Member from Members where Username =
> @username)
> begin
> insert into
> Members(ID_Member,Username,Password,Firstname,Familyname)
> values (@ID,@username,@password,@Firstname,@Familyname)
> select @ID_Member = @ID
> end
> else
> select @ID_Member = -1
> return
> END
> </cfquery>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
