i think we may be in that boat (which is sinking a little)
_______________________________________________________
* 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: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 11:39
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] WooHoo It works ...
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]
--
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]
