not entirely true.
MSAccess does support typeDef's (which are "sort-of" baby Stored procs)
PROVIDED:
1) it doesn't really do out params
2) only one "query" at a time. Unlike SQLServer, the Jet db engine can
NOT do multi SQL statements separated by a ";"
<cfstoredproc> and <cfprocparam> work fine.
how?
just make a query in MSAccess (you can also do this by SQL and get more
features*) and give it a name. that name is for the cfstoredproc.
in your CF page
<cfstoredproc datasource="myDSN" procedure="qspLogin">
<cfprocparam cfsqltype="CF_SQL_CHAR" value="#Form.Username#">
<cfprocparam cfsqltype="CF_SQL_CHAR" value="#Form.Password#">
<cfprocresult name="RSUser">
</cfstoredproc>
Hello <cfoutput>#rsUser.FirstName# #rsUser.LastName#</cfoutput>
and the MSAccess query saved as "qspLogin"
SELECT fName AS FirstName, lName as LastName
FROM tUsers
WHERE uName = [EMAIL PROTECTED]
AND pWord = [EMAIL PROTECTED]
you can test this query within Access by just clicking on it and
supplying the values (in the right order)
NOTE it doesn't matter what FirstParam and SecondParam are called. just
remember that the input params (what you send) are in the same order and
datatype as the query (and are not names already used in the db)
there is a page (somewhere - it keeps moving) on msdn.microsoft.com
that details all the advanced features of the JET db engine (the guts of
Access) that are available via scripting (ie: not via the IDE). I think
it even does "baby" triggers but I've never bothered.
does that help?
cheers
barry.b
-----Original Message-----
From: Steve Onnis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 April 2004 12:55 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: stored procs and triggers in access
I was wondering if there is any way i am able to use stored procedures
and
triggers in access.
No
Triggers i think maybe not SP is a no (from my knowledge)
Steve
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jamie
Lawrence Jenner
Sent: Tuesday, April 20, 2004 12:29 AM
To: CFAussie Mailing List
Subject: [cfaussie] stored procs and triggers in access
Hi,
I was wondering if there is any way i am able to use stored procedures
and
triggers in access.
I know that i am able to access queries within the database using ADO
but
i am not able to carry out select queries, only delete, update and
append.
The database will be upgraded to SQL eventually but it has to remain in
access at the moment.
I have a particularly large amount (over 30) queries which run when a
user
su
bmits a customers order. there are numerous insert deletes, selects and
updates and at the moment each query is run seperatly withints own
cfquery
tag. this is causing a massive bottleneck as it is also a transaction
and
it would be more efficient to run within the database. how do i carry
out
stored procs and triggers in access and how do i access them?
thanks in advance
Jamie
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
