heh. yea. I know of some gov departments that are using access and finding the error of their ways.
> -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 19 March 2004 11:37 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] WooHoo It works ... > > > so basically when you starting pushing access it has limits > and starts buckling - is that the general concensus? > > _______________________________________________________ > * Regards, > Richard Lovelock, > Senior Application Analyst. > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > ( 0870 906 7482 > > _______________________________________________________ > > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED] > Sent: 19 March 2004 11:34 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] WooHoo It works ... > > > you've hit the nail on the head "works great for a small dev > project site"... > ----- Original Message ----- > From: "Lovelock, Richard J" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 19, 2004 11:27 AM > Subject: RE: [ cf-dev ] WooHoo It works ... > > > > why does everyone seem to hate access so much? (apart from memory > > leaks mentioned in earlier thread this week) > > > > it helped me learn loads and works great for a small dev > project site > > I am working on for learning purposes? > > > > _______________________________________________________ > > * Regards, > > Richard Lovelock, > > Senior Application Analyst. > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > -----Original Message----- > > From: Tom Smith [mailto:[EMAIL PROTECTED] > > Sent: 19 March 2004 11:22 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] WooHoo It works ... > > > > > > you could do exactly the same thing in SQL server Neil... > but yeah I > > totally agree with you about access <spit /> > > > > ----- Original Message ----- > > From: "Robertson-Ravo, Neil (RX)" > <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, March 19, 2004 11:12 AM > > Subject: RE: [ cf-dev ] WooHoo It works ... > > > > > > > MAX(ID) is Access aint it <spit/> > > > > > > > > > > > > -----Original Message----- > > > From: Ian Westbrook (BT account) > > > [mailto:[EMAIL PROTECTED] > > > Sent: 19 March 2004 11:06 > > > To: [EMAIL PROTECTED] > > > Subject: Re: [ cf-dev ] WooHoo It works ... > > > > > > couldn't you also do... > > > > > > <cftransaction> > > > > > > <cfquery name="add_to_ReportNames" > datasource="WebUserDSN"> INSERT > > > INTO Report_Names (report_name, path_name, Doc_Type_ID) VALUES > > > ('#trim(form.entered_report_name)#', > > > '#trim(form.entered_path_name)#', > > > '#trim(form.selected_doc_type)#') > > > </cfquery> > > > > > > <cfquery datasource="#dsn#" name="getlast"> SELECT MAX(id) AS > > > 'last_record_ID' </cfquery> > > > > > > ... > > > > > > </cftransaction> > > > > > > ?? > > > > > > Ian W > > > > > > > > > ----- Original Message ----- > > > From: <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Friday, March 19, 2004 11:00 AM > > > Subject: [ cf-dev ] WooHoo It works ... > > > > > > > > > > > > > > I came up with this ... > > > > > > > > <cftransaction> > > > > <!--- First addrecord to reportNames and get the > @@identity > > > > which will give last record_ID created ---> > > > > <cfquery name="add_to_ReportNames" > datasource="WebUserDSN"> > > > > INSERT INTO Report_Names > > > > (report_name, path_name, Doc_Type_ID) > > > > VALUES > > > > ('#trim(form.entered_report_name)#', > > > > '#trim(form.entered_path_name)#', > > > > '#trim(form.selected_doc_type)#') > > > > SELECT @@IDENTITY AS 'last_record_ID' > > > > </cfquery> > > > > <cfquery name="add_to_Details" datasource="WebUserDSN"> > > > > INSERT INTO Details > > > > (Report_ID, Phase_ID, Group_ID, Menu_Group) > > > > VALUES > > > > ('#add_to_ReportNames.last_record_ID#', > > > > '#trim(form.selected_phase_type)#', > > > > '#trim(form.selected_group_type)#', > > > > '#trim(form.selected_menu)#') > > > > </cfquery> > > > > </cftransaction> > > > > > > > > > > > > Thanks all for the help ... > > > > > > > > > > > > Regards - Paul > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************** > ************** > > > ********************* > > > > The information contained within this e-mail (and any > attachment) > > > > sent by > > > Birmingham City Council is confidential and may be legally > > > privileged. > It > > is > > > intended only for the named recipient or entity to whom it is > > > addressed. > > If > > > you are not the intended recipient please accept our apologies and > notify > > > the sender immediately, or telephone +(44) 121 303 6666. > > > Unauthorised access, use, disclosure, storage or copying is not > > > permitted and may be unlawful. Any e-mail including its > content may > > > be monitored and used by Birmingham City Council for reasons of > > > security and for monitoring > > internal > > > compliance with the office policy on staff use. E-mail blocking > > > software > > may > > > also be used. Any views or opinions presented are solely those of > > > the originator and do not necessarily represent those of > Birmingham > > > City Council. We cannot guarantee that this message or any > > > attachment is > virus > > > free or has not been intercepted and amended. > > > > > > > > > > > > > > ************************************************************** > ************** > > > ********************* > > > > > > > > > > > > -- > > > > These lists are syncronised with the CFDeveloper forum at > > > http://forum.cfdeveloper.co.uk/ > > > > Archive: > > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > CFDeveloper Sponsors and contributors:- *Hosting and support > > > > provided by CFMXhosting.co.uk* :: *ActivePDF provided > > > by activepdf.com* > > > > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided > > > > by > > > proworkflow.com* > > > > *Tutorials provided by helmguru.com* :: > *Lists hosted > > > > by > > > gradwell.com* > > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > -- > > > These lists are syncronised with the CFDeveloper forum at > > > http://forum.cfdeveloper.co.uk/ > > > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > CFDeveloper Sponsors and contributors:- > > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided > > > by activepdf.com* > > > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by > > > proworkflow.com* > > > *Tutorials provided by helmguru.com* :: *Lists > hosted by > > > gradwell.com* > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, > > > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed > > > Business, Registered in England, Number 678540. It contains > > > information which is confidential and may also be > privileged. It is > > > for the exclusive use of > > the > > > intended recipient(s). If you are not the intended recipient(s) > > > please > > note > > > that any form of distribution, copying or use of this > communication > > > or > the > > > information in it is strictly prohibited and may be unlawful. If > > > you > have > > > received this communication in error please return it to > the sender > > > or > > call > > > our switchboard on +44 (0) 20 89107910. The opinions expressed > > > within > > this > > > communication are not necessarily those expressed by Reed > > > Exhibitions. Visit our website at http://www.reedexpo.com > > > > > > -- > > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > CFDeveloper Sponsors and contributors:- > > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided > > by activepdf.com* > > > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by > > proworkflow.com* > > > *Tutorials provided by helmguru.com* :: *Lists > hosted by > > gradwell.com* > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > > provided by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > ======================================================= > > This message contains information that may be privileged or > > confidential > and is the property of the Cap Gemini Ernst & Young Group. It > is intended only for the person to whom it is addressed. If > you are not the intended recipient, you are not authorised to > read, print, retain, copy, disseminate, distribute, or use > this message or any part thereof. If you receive this message > in error, please notify the sender immediately and delete all > copies of this message. > > ======================================================= > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > > provided > by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
