[cfaussie] Ruby on Rails ( or some illegal substance )

2006-08-10 Thread Mick Rome 

Has anyone seen this? Is Dave is on something?

http://media.rubyonrails.org/video/rails_take2_with_sound.mov

I wonder back in the day if any CF presentations had this much
excitement?

Someone did a takeoff

http://screencast4.sqlonrails.org/video/screencast2.mov


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: SOT: Document Management System

2006-08-10 Thread Barry Beattie 

don't forget you can use the humble CVS for versioning documents.

you just can't do a merge on the binary file format.

just a thought.


On 8/11/06, David Harris <[EMAIL PROTECTED]> wrote:
>
> http://www.fusiondox.com/
>
> I meet the guy who wrote it @ CFUnited.
>
> It's pitched at enterprise, and I think the price tag reflects that
> from memory...
>
> Dale Fraser wrote:
> > Hmm,
> >
> >
> >
> > I want document management, not content management.
> >
> >
> >
> > Ie: Managing versions of Word Documents etc.
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
> >
> >
> >
> >   _
> >
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> > Of Peter Tilbrook
> > Sent: Friday, 11 August 2006 10:53 AM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: SOT: Document Management System
> >
> >
> >
> > FarCry CMS - it Open Source - check out http://www.farcrycms.org/
> >
> >
> >
> >
> > On 11/08/06, Dale Fraser < [EMAIL PROTECTED]  >
> > wrote:
> >
> > Our company needs a Document Control / Management System.
> >
> >
> >
> > I don't want to build one, but just buy one. Anyone recommend something?
> > Preferably Coldfusion / MS SQL.
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > Peter Tilbrook
> > ColdGen Internet Solutions
> > Manager, ACT and Region ColdFusion Users Group
> > PO Box 2247
> > Queanbeyan, NSW, 2620
> > AUSTRALIA
> >
> > http://www.coldgen.com/
> > http://www.actcfug.com/
> >
> > Tel: +61-2-6284-2727
> > Mob: +61-0432-897-437
> >
> > Email: [EMAIL PROTECTED]
> >
> >
> > --=_NextPart_000_006C_01C6BD34.F5B70840
> > Content-Type: text/html; charset=utf-8
> > Content-Transfer-Encoding: quoted-printable
> > X-Google-AttachSize: 8093
> >
> >  > osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> > xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
> > w.w3.org/TR/REC-html40">
> >
> > 
> > 
> > 
> >  >  namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"countr=
> > y-region"/>
> >  >  name=3D"place"/>
> >  >  name=3D"Street"/>
> >  >  name=3D"address"/>
> >  >  name=3D"PersonName"/>
> > 
> > 
> > 
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> >  > t-size:10.0pt;
> > font-family:"Courier New"'>Hmm,
> >
> >  > t-size:10.0pt;
> > font-family:"Courier New"'> 
> >
> >  > t-size:10.0pt;
> > font-family:"Courier New"'>I want document management, not content manageme=
> > nt.
> >
> >  > t-size:10.0pt;
> > font-family:"Courier New"'> 
> >
> >  > t-size:10.0pt;
> > font-family:"Courier New"'>Ie: Managing versions of Word Documents etc. > >
> >
> > 
> >
> >  > -family:
> > "Courier New"'>Regards
> > Dale Fraser=
> > 
> >
> >  > -family:
> > "Courier New"'>http://dale.fraser.id.au";>http://dale.fraser.id.a=
> > u
> >
> >  > -family:
> > "Courier New"'>
> >   > -size:
> > 10.0pt;font-family:"Courier New"'>
> >
> > 
> >
> > 
> >
> >  > e=3D3
> > face=3D"Times New Roman">
> >
> > 
> >
> > 
> >
> >  > style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:=
> >  > size=3D2 face=3DTahoma> > mily:Tahoma'>
> > cfaussie@googlegroups.com [mai=
> > lto: > w:st=3D"on">cfaussie@googlegroups.com]  > style=3D'font-weight:bold'>On Behalf Of Peter Tilbrook
> > Sent: Friday, 11 August 2006=
> >  10:53
> > AM
> > To:  > on">cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: SOT:
> > Document Management System > n>
> >
> > 
> >
> >  > 'font-size:
> > 12.0pt'> 
> >
> >  > face=3D"Times New Roman">FarCry CMS - it O=
> > pen
> > Source - check out http://www.farcrycms.org/";>http://www.farcryc=
> > ms.org/
> > 
> > 
> > 
> >
> > 
> >
> >  > New Roman"> >

[cfaussie] Re: Getting a list of tables in access

2006-08-10 Thread Joel Cass 

Thanks..

That'll do the job :)

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Steve Onnis
Sent: Friday, 11 August 2006 12:17 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Getting a list of tables in access



How about this?

SELECT Name
FROM MSysObjects
WHERE Type = 1
AND LEFT(Name, 4) <> 'MSys';

Just hope you dont have any tables stating with "MSys"



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Chad Renando
Sent: Friday, August 11, 2006 11:38 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Getting a list of tables in access



Good luck.  Implementing a similar solution a couple of times on my
end, I had users export into either a .txt, .csv or xml format.
Interactions with Access in a live online environment isn't the
prettiest thing in the world.

Chad

On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
>
> Thanks..
>
> Actually the transferring of data part is taken care of.. We have a system
> where public users may want to upload their internal data in access
format,
> which is then transferred into a SQL Server database for web use. I want
to
> be able to give them the choice of selecting which objects to import,
hence
> I need to get a list of available tables.
>
> All the websites on this subject give conflicting information, plus
detailed
> documentation doesn't seem to be available from MS.
>
> It's just the "getting a list of tables" part that I need.. And I would
> prefer to use a query.
>
> Joel
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
> Behalf Of Chad Renando
> Sent: Friday, 11 August 2006 11:10 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Getting a list of tables in access
>
>
>
> I have had to do this a few times... never did figure out the proper
> way to do it.  It is usually a once-off, and by the time I figured it
> out, I could have done it manually.
>
> I typically just create a Make Table query for each table:
>
> SELECT MyTableTable.* INTO MyNewTable
> FROM MyTable;
>
> and run the lot.  Takes about 30 minutes for 100 tables start to
> finish, including creating the queries.
>
> Chad
>
>
>
>
> On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
> >
> > The documentation in MS access seems quite vague about this area. I want
> to
> > get a list of tables from an access database to import into our own
custom
> > data store. I have fiddled around and have come to the conclusion that
> this
> > is the query that must be run:
> >
> > SELECT MSysObjects.*
> >   FROM MSysObjects
> >  WHERE MSysObjects.Type =1
> >AND MSysObjects.Flags=0
> > IN '#accessFilePath#'
> >
> > Can anyone confirm if this is correct? I've tried this on a few various
> > files that I found lying around and have managed to get the same results
> > every time, but you just don't know what may change between versions
when
> it
> > comes to MS products (just getting in on the whole debate here..). And
> it's
> > undocumented..
> >
> > Any help is appreciated
> > Joel
> >
> >
> >
> > >
> >
>
>
>
>
>
>
> >
>










--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Getting a list of tables in access

2006-08-10 Thread Steve Onnis 

How about this?

SELECT Name
FROM MSysObjects
WHERE Type = 1
AND LEFT(Name, 4) <> 'MSys';

Just hope you dont have any tables stating with "MSys"



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Chad Renando
Sent: Friday, August 11, 2006 11:38 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Getting a list of tables in access



Good luck.  Implementing a similar solution a couple of times on my
end, I had users export into either a .txt, .csv or xml format.
Interactions with Access in a live online environment isn't the
prettiest thing in the world.

Chad

On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
>
> Thanks..
>
> Actually the transferring of data part is taken care of.. We have a system
> where public users may want to upload their internal data in access
format,
> which is then transferred into a SQL Server database for web use. I want
to
> be able to give them the choice of selecting which objects to import,
hence
> I need to get a list of available tables.
>
> All the websites on this subject give conflicting information, plus
detailed
> documentation doesn't seem to be available from MS.
>
> It's just the "getting a list of tables" part that I need.. And I would
> prefer to use a query.
>
> Joel
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
> Behalf Of Chad Renando
> Sent: Friday, 11 August 2006 11:10 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Getting a list of tables in access
>
>
>
> I have had to do this a few times... never did figure out the proper
> way to do it.  It is usually a once-off, and by the time I figured it
> out, I could have done it manually.
>
> I typically just create a Make Table query for each table:
>
> SELECT MyTableTable.* INTO MyNewTable
> FROM MyTable;
>
> and run the lot.  Takes about 30 minutes for 100 tables start to
> finish, including creating the queries.
>
> Chad
>
>
>
>
> On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
> >
> > The documentation in MS access seems quite vague about this area. I want
> to
> > get a list of tables from an access database to import into our own
custom
> > data store. I have fiddled around and have come to the conclusion that
> this
> > is the query that must be run:
> >
> > SELECT MSysObjects.*
> >   FROM MSysObjects
> >  WHERE MSysObjects.Type =1
> >AND MSysObjects.Flags=0
> > IN '#accessFilePath#'
> >
> > Can anyone confirm if this is correct? I've tried this on a few various
> > files that I found lying around and have managed to get the same results
> > every time, but you just don't know what may change between versions
when
> it
> > comes to MS products (just getting in on the whole debate here..). And
> it's
> > undocumented..
> >
> > Any help is appreciated
> > Joel
> >
> >
> >
> > >
> >
>
>
>
>
>
>
> >
>





--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: SOT: Document Management System

2006-08-10 Thread David Harris 

http://www.fusiondox.com/

I meet the guy who wrote it @ CFUnited.

It's pitched at enterprise, and I think the price tag reflects that
from memory...

Dale Fraser wrote:
> Hmm,
>
>
>
> I want document management, not content management.
>
>
>
> Ie: Managing versions of Word Documents etc.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>   _
>
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Peter Tilbrook
> Sent: Friday, 11 August 2006 10:53 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: SOT: Document Management System
>
>
>
> FarCry CMS - it Open Source - check out http://www.farcrycms.org/
>
>
>
>
> On 11/08/06, Dale Fraser < [EMAIL PROTECTED]  >
> wrote:
>
> Our company needs a Document Control / Management System.
>
>
>
> I don't want to build one, but just buy one. Anyone recommend something?
> Preferably Coldfusion / MS SQL.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Peter Tilbrook
> ColdGen Internet Solutions
> Manager, ACT and Region ColdFusion Users Group
> PO Box 2247
> Queanbeyan, NSW, 2620
> AUSTRALIA
>
> http://www.coldgen.com/
> http://www.actcfug.com/
>
> Tel: +61-2-6284-2727
> Mob: +61-0432-897-437
>
> Email: [EMAIL PROTECTED]
>
>
> --=_NextPart_000_006C_01C6BD34.F5B70840
> Content-Type: text/html; charset=utf-8
> Content-Transfer-Encoding: quoted-printable
> X-Google-AttachSize: 8093
>
>  osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
> w.w3.org/TR/REC-html40">
>
> 
> 
> 
>   namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"countr=
> y-region"/>
>   name=3D"place"/>
>   name=3D"Street"/>
>   name=3D"address"/>
>   name=3D"PersonName"/>
> 
> 
> 
> 
>
> 
>
> 
>
> 
>
>  t-size:10.0pt;
> font-family:"Courier New"'>Hmm,
>
>  t-size:10.0pt;
> font-family:"Courier New"'> 
>
>  t-size:10.0pt;
> font-family:"Courier New"'>I want document management, not content manageme=
> nt.
>
>  t-size:10.0pt;
> font-family:"Courier New"'> 
>
>  t-size:10.0pt;
> font-family:"Courier New"'>Ie: Managing versions of Word Documents etc. >
>
> 
>
>  -family:
> "Courier New"'>Regards
> Dale Fraser=
> 
>
>  -family:
> "Courier New"'>http://dale.fraser.id.au";>http://dale.fraser.id.a=
> u
>
>  -family:
> "Courier New"'>
>   -size:
> 10.0pt;font-family:"Courier New"'>
>
> 
>
> 
>
>  e=3D3
> face=3D"Times New Roman">
>
> 
>
> 
>
>  style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:=
>  size=3D2 face=3DTahoma> mily:Tahoma'>
> cfaussie@googlegroups.com [mai=
> lto: w:st=3D"on">cfaussie@googlegroups.com]  style=3D'font-weight:bold'>On Behalf Of Peter Tilbrook
> Sent: Friday, 11 August 2006=
>  10:53
> AM
> To:  on">cfaussie@googlegroups.com
> Subject: [cfaussie] Re: SOT:
> Document Management System n>
>
> 
>
>  'font-size:
> 12.0pt'> 
>
>  face=3D"Times New Roman">FarCry CMS - it O=
> pen
> Source - check out http://www.farcrycms.org/";>http://www.farcryc=
> ms.org/
> 
> 
> 
>
> 
>
>  New Roman"> style=3D'font-size:12.0pt'>On 11/08/06,   style=3D'font-weight:bold'>Dale Fraser < href=3D"mailto:[EMAIL PROTECTED]"> [EMAIL PROTECTED]> wrote:<=
> /font>
>
> 
>
> 
>
> 
>
>  -family:
> "Courier New"'>Our company needs a Document Control / Management System. pan>
>
>  -family:
> "Courier New"'> 
>
>  -family:
> "Courier New"'>I don't want to build one, but just buy one. Anyone recommend
> something? Preferably Coldfusion / MS SQL.
>
> 
>
>  -family:
> "Courier New"'>Regards
> Dale Fraser=
> 
>
>  -family:
> "Courier New"'>http://dale.fraser.id.au"; target=3D"_blank">http:=
> //dale.fraser.id.au
>
>  -family:
> "Courier New"'>
>  
>
> 
>
>  > 
>
> 
>
>  face=3D"Times New Roman"> =
> 
>
>

[cfaussie] Re: SOT: Document Management System

2006-08-10 Thread Steve Onnis 



http://www.filehold.com/

  -Original Message-From: cfaussie@googlegroups.com 
  [mailto:[EMAIL PROTECTED]On Behalf Of Dale 
  FraserSent: Friday, August 11, 2006 10:58 AMTo: 
  cfaussie@googlegroups.comSubject: [cfaussie] Re: SOT: Document 
  Management System
  
  Hmm,
   
  I want document 
  management, not content management.
   
  Ie: Managing versions of 
  Word Documents etc.
  
  RegardsDale Fraser
  http://dale.fraser.id.au
   
  
  
  
  
  From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Peter TilbrookSent: Friday, 11 August 2006 10:53 
  AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: SOT: Document 
  Management System
   
  FarCry CMS - it Open Source - check out 
  http://www.farcrycms.org/
  
  On 11/08/06, Dale 
  Fraser < 
  [EMAIL PROTECTED]> wrote:
  
  
  
  Our company needs a 
  Document Control / Management System.
   
  I don't want to build one, 
  but just buy one. Anyone recommend something? Preferably Coldfusion / MS 
  SQL.
  
  RegardsDale Fraser
  http://dale.fraser.id.au
   
   
   
   
  -- Peter 
  TilbrookColdGen Internet SolutionsManager, ACT and Region ColdFusion 
  Users GroupPO 
  Box 2247Queanbeyan, NSW, 
  2620AUSTRALIAhttp://www.coldgen.com/http://www.actcfug.com/Tel: 
  +61-2-6284-2727Mob: +61-0432-897-437Email: [EMAIL PROTECTED] 
  
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Getting a list of tables in access

2006-08-10 Thread Chad Renando 

Good luck.  Implementing a similar solution a couple of times on my
end, I had users export into either a .txt, .csv or xml format.
Interactions with Access in a live online environment isn't the
prettiest thing in the world.

Chad

On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
>
> Thanks..
>
> Actually the transferring of data part is taken care of.. We have a system
> where public users may want to upload their internal data in access format,
> which is then transferred into a SQL Server database for web use. I want to
> be able to give them the choice of selecting which objects to import, hence
> I need to get a list of available tables.
>
> All the websites on this subject give conflicting information, plus detailed
> documentation doesn't seem to be available from MS.
>
> It's just the "getting a list of tables" part that I need.. And I would
> prefer to use a query.
>
> Joel
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
> Behalf Of Chad Renando
> Sent: Friday, 11 August 2006 11:10 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Getting a list of tables in access
>
>
>
> I have had to do this a few times... never did figure out the proper
> way to do it.  It is usually a once-off, and by the time I figured it
> out, I could have done it manually.
>
> I typically just create a Make Table query for each table:
>
> SELECT MyTableTable.* INTO MyNewTable
> FROM MyTable;
>
> and run the lot.  Takes about 30 minutes for 100 tables start to
> finish, including creating the queries.
>
> Chad
>
>
>
>
> On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
> >
> > The documentation in MS access seems quite vague about this area. I want
> to
> > get a list of tables from an access database to import into our own custom
> > data store. I have fiddled around and have come to the conclusion that
> this
> > is the query that must be run:
> >
> > SELECT MSysObjects.*
> >   FROM MSysObjects
> >  WHERE MSysObjects.Type =1
> >AND MSysObjects.Flags=0
> > IN '#accessFilePath#'
> >
> > Can anyone confirm if this is correct? I've tried this on a few various
> > files that I found lying around and have managed to get the same results
> > every time, but you just don't know what may change between versions when
> it
> > comes to MS products (just getting in on the whole debate here..). And
> it's
> > undocumented..
> >
> > Any help is appreciated
> > Joel
> >
> >
> >
> > >
> >
>
>
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Getting a list of tables in access

2006-08-10 Thread Joel Cass 

Thanks..

Actually the transferring of data part is taken care of.. We have a system
where public users may want to upload their internal data in access format,
which is then transferred into a SQL Server database for web use. I want to
be able to give them the choice of selecting which objects to import, hence
I need to get a list of available tables.

All the websites on this subject give conflicting information, plus detailed
documentation doesn't seem to be available from MS.

It's just the "getting a list of tables" part that I need.. And I would
prefer to use a query.

Joel

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Chad Renando
Sent: Friday, 11 August 2006 11:10 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Getting a list of tables in access



I have had to do this a few times... never did figure out the proper
way to do it.  It is usually a once-off, and by the time I figured it
out, I could have done it manually.

I typically just create a Make Table query for each table:

SELECT MyTableTable.* INTO MyNewTable
FROM MyTable;

and run the lot.  Takes about 30 minutes for 100 tables start to
finish, including creating the queries.

Chad




On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
>
> The documentation in MS access seems quite vague about this area. I want
to
> get a list of tables from an access database to import into our own custom
> data store. I have fiddled around and have come to the conclusion that
this
> is the query that must be run:
>
> SELECT MSysObjects.*
>   FROM MSysObjects
>  WHERE MSysObjects.Type =1
>AND MSysObjects.Flags=0
> IN '#accessFilePath#'
>
> Can anyone confirm if this is correct? I've tried this on a few various
> files that I found lying around and have managed to get the same results
> every time, but you just don't know what may change between versions when
it
> comes to MS products (just getting in on the whole debate here..). And
it's
> undocumented..
>
> Any help is appreciated
> Joel
>
>
>
> >
>






--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Getting a list of tables in access

2006-08-10 Thread Chad Renando 

I have had to do this a few times... never did figure out the proper
way to do it.  It is usually a once-off, and by the time I figured it
out, I could have done it manually.

I typically just create a Make Table query for each table:

SELECT MyTableTable.* INTO MyNewTable
FROM MyTable;

and run the lot.  Takes about 30 minutes for 100 tables start to
finish, including creating the queries.

Chad




On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote:
>
> The documentation in MS access seems quite vague about this area. I want to
> get a list of tables from an access database to import into our own custom
> data store. I have fiddled around and have come to the conclusion that this
> is the query that must be run:
>
> SELECT MSysObjects.*
>   FROM MSysObjects
>  WHERE MSysObjects.Type =1
>AND MSysObjects.Flags=0
> IN '#accessFilePath#'
>
> Can anyone confirm if this is correct? I've tried this on a few various
> files that I found lying around and have managed to get the same results
> every time, but you just don't know what may change between versions when it
> comes to MS products (just getting in on the whole debate here..). And it's
> undocumented..
>
> Any help is appreciated
> Joel
>
>
>
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: SOT: Document Management System

2006-08-10 Thread Dale Fraser 








Hmm,

 

I want document management, not content management.

 

Ie: Managing versions of Word Documents etc.



Regards
Dale Fraser

http://dale.fraser.id.au


 











From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Peter Tilbrook
Sent: Friday, 11 August 2006 10:53
AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: SOT:
Document Management System



 

FarCry CMS - it Open
Source - check out http://www.farcrycms.org/






On 11/08/06, Dale Fraser < [EMAIL PROTECTED]> wrote:







Our company needs a Document Control / Management System.

 

I don't want to build one, but just buy one. Anyone recommend
something? Preferably Coldfusion / MS SQL.



Regards
Dale Fraser

http://dale.fraser.id.au


 



 



 



 








-- 
Peter Tilbrook
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group
PO Box 2247
Queanbeyan, NSW, 2620
AUSTRALIA

http://www.coldgen.com/
http://www.actcfug.com/

Tel: +61-2-6284-2727
Mob: +61-0432-897-437

Email: [EMAIL PROTECTED] 




--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: SOT: Document Management System

2006-08-10 Thread Peter Tilbrook 
FarCry CMS - it Open Source - check out http://www.farcrycms.org/On 11/08/06, Dale Fraser <
[EMAIL PROTECTED]> wrote:














Our company needs a Document Control / Management
System.

 

I don't want to build one, but just buy one.
Anyone recommend something? Preferably Coldfusion / MS SQL.



Regards
Dale Fraser

http://dale.fraser.id.au



 



 










-- Peter TilbrookColdGen Internet SolutionsManager, ACT and Region ColdFusion Users GroupPO Box 2247Queanbeyan, NSW, 2620AUSTRALIA
http://www.coldgen.com/http://www.actcfug.com/Tel: +61-2-6284-2727Mob: +61-0432-897-437Email: [EMAIL PROTECTED]

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Getting a list of tables in access

2006-08-10 Thread Joel Cass 

The documentation in MS access seems quite vague about this area. I want to
get a list of tables from an access database to import into our own custom
data store. I have fiddled around and have come to the conclusion that this
is the query that must be run:

SELECT MSysObjects.*
  FROM MSysObjects
 WHERE MSysObjects.Type =1
   AND MSysObjects.Flags=0
IN '#accessFilePath#'

Can anyone confirm if this is correct? I've tried this on a few various
files that I found lying around and have managed to get the same results
every time, but you just don't know what may change between versions when it
comes to MS products (just getting in on the whole debate here..). And it's
undocumented..

Any help is appreciated
Joel



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] SOT: Document Management System

2006-08-10 Thread Dale Fraser 








Our company needs a Document Control / Management
System.

 

I don’t want to build one, but just buy one.
Anyone recommend something? Preferably Coldfusion / MS SQL.



Regards
Dale Fraser

http://dale.fraser.id.au


 



 




--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: CF vs ...

2006-08-10 Thread Barry Beattie 

I'd like to propose that it's not just about "solutions" but "vision"
which harks back to a webdu presso by Grant Straker in selling (then
Macromedia) product.

2 years ago it was CF integrating with flash (flex 1.5)... now look at
the goodies with Flex 2.0

and also now we're beginning to see the start of integrating CF with
"active" PDF (Livecycle).

It makes an interesting counter to the Microsoft "from ASP.NET to
SharePoint to Exchange to MSOffice"

mind you, I have *never* worked at a place with end-to-end Microsoft
solutions (don't really want to) - there's always a critical legacy
app, Solaris box or Oracle database to complicate matters...

at the moment, it's this "vision" argument that I'm using to counter
the Ruby-on-Rails attention, which it seems is a real threat to the CF
"space" of RAD. Can RonR have as seemless remoting support (eg: CFC's
to AS classes) or integrate with LiveCycle PDF's? ... you get the idea
...


bugger! I dropped a stitch
barry.b



On 8/11/06,  <[EMAIL PROTECTED]> wrote:
>
> Hey just to add more fuel to the fire. We just had a company meeting
> last night and they had a guest speaker there from Microsoft, talking
> about "SOLUTIONS" ironically. They are coming out with Studio 2005 with
> some added features which apparently haven't been released yet which
> from what I understand are using MS Project, MS Word and some new
> server which will track all your project changes and where it is at
> that point in the SDLC.
>
> And because my company are a Gold Partner with MS I saw my little CF
> heart broken when I heard my manager say to me I like that, lets look
> at it! *sigh*
>
> Oh and we are ditching Lotus Notes apparentlywhoo hoo!!
>
> Jeremy
>
>
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: CF vs ...

2006-08-10 Thread 

Hey just to add more fuel to the fire. We just had a company meeting
last night and they had a guest speaker there from Microsoft, talking
about "SOLUTIONS" ironically. They are coming out with Studio 2005 with
some added features which apparently haven't been released yet which
from what I understand are using MS Project, MS Word and some new
server which will track all your project changes and where it is at
that point in the SDLC.

And because my company are a Gold Partner with MS I saw my little CF
heart broken when I heard my manager say to me I like that, lets look
at it! *sigh*

Oh and we are ditching Lotus Notes apparentlywhoo hoo!!

Jeremy


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: OT Anyone want to work in the UK?

2006-08-10 Thread M@ Bourke 
It shouldn't On 8/10/06, Peter Tilbrook <[EMAIL PROTECTED]> wrote:
Um your email address bounces for some reason :)On 10/08/06, M@ Bourke <
[EMAIL PROTECTED]
> wrote:On 8/9/06, Jamie Lawrence Jenner
 <[EMAIL PROTECTED]> wrote:







Is 
this open to UK residents? (i'm welsh, nearly australian, Loads of sheep and 
miles away from england)
Should be no problem with being Welsh, Welsh may find the visa process (if welsh even need a visa) quicker.



-- Peter TilbrookColdGen Internet SolutionsManager, ACT and Region ColdFusion Users GroupPO Box 2247Queanbeyan, NSW, 2620AUSTRALIA

http://www.coldgen.com/http://www.actcfug.com/Tel: +61-2-6284-2727Mob: +61-0432-897-437
Email: [EMAIL PROTECTED]





--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: OT Anyone want to work in the UK?

2006-08-10 Thread Peter Tilbrook 
Um your email address bounces for some reason :)On 10/08/06, M@ Bourke <[EMAIL PROTECTED]
> wrote:On 8/9/06, Jamie Lawrence Jenner
 <[EMAIL PROTECTED]> wrote:






Is 
this open to UK residents? (i'm welsh, nearly australian, Loads of sheep and 
miles away from england)
Should be no problem with being Welsh, Welsh may find the visa process (if welsh even need a visa) quicker.



-- Peter TilbrookColdGen Internet SolutionsManager, ACT and Region ColdFusion Users GroupPO Box 2247Queanbeyan, NSW, 2620AUSTRALIA
http://www.coldgen.com/http://www.actcfug.com/Tel: +61-2-6284-2727Mob: +61-0432-897-437Email: [EMAIL PROTECTED]

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Coldfusion & Actionscript

2006-08-10 Thread M@ Bourke 
I say scrap cfscript entirely and send it to the ends of the earth, then throw it off the edge of the earth.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---