ACK i was missing my # signs!!! new wife must have stolen them!
<cfquery name="Insert_user_provider_services" datasource="#DSN#">
IF NOT EXISTS (SELECT
ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk
FROM user_provider_services
WHERE ups_provider_fk = <cfqueryparam
cfsqltype="cf_sql_integer" value="#form.provider#" />
AND ups_client_fk = <cfqueryparam
cfsqltype="cf_sql_integer" value="#form.client#" />
AND ups_service_fk = <cfqueryparam
cfsqltype="cf_sql_integer" value="#form.service#" />)
INSERT INTO user_provider_services
(ups_provider_fk,ups_client_fk,ups_service_fk)
VALUES (<cfqueryparam cfsqltype="cf_sql_integer"
value="#form.provider#" />
,<cfqueryparam cfsqltype="cf_sql_integer"
value="#form.provider#" />
,<cfqueryparam cfsqltype="cf_sql_integer"
value="#form.service#" />)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
