[EMAIL PROTECTED] wrote: >Yeah sorry...that's what I have...major typo there... > >Just wondering how you manage to create a page that updates the records now. >Any suggestions? > > OK - so you've probably want something like this :
_Client List Page_ Lists all clients by name. Link for each client to view their jobs - clientID passed to Client Job Page. _Client Job Page_ List of job details that the client has done in the past. Link to "Add Job Form" - clientID passed to Add Job Form. _Client Job Form_ Form for Job details including clientid in the form as a hidden field. Submit Form to Job Update Page _Job Update Page_ Insert Job Details into the database. (cfquery) Redirect back to Client Job Page. (cflocation) I may be teaching my grandma to suck eggs her, but just in case.... Any query string variables ie. variables on the URL will be found in the URL scope eg. URL.ClientID. Any variables, hidden or otherwise, in form will be found in the FORM scope eg. FORM.ClientID, FORM.JobTitle etc. When you insert data into a database - start as you're going to have to carry on - use CFQUERY and proper SQL statements, rather than CFINSERT and CFUPDATE. Also make sure you use <cfqueryparam> on the values you are inserting into the database. like so.. <cfquery name="insert_job" datasource="yourdsnname"> INSERT INTO Jobs (ClientID,JobTitle,.....) VALUES (<cfqueryparam cfsqltype="cf_sql_integer" value="#form.clientid#">,<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.jobtitle#">,.....) </cfquery> Hope that points you in the right direction. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
