Hey Jeff
Can you have a scheduled job set up on the sql server to run your dts
package?
If you need on-demand exports, rather than scheduled, you could make a
special table that has a flag that you set via your CF application. You
could set up the job to run every five minutes, and the first t
As a result of SOX legislation my access to production data has been
taken away. I don't mind that much, except that they took away the
ability to run a DTS package to copy prod data to test. They will run it
for me (when they are around). If they are not around I am out of luck.
SQL admin says to
is always the only false value, whereas true
can have multiple values.
SELECT *
FROM mytable
WHERE booleanfield <> 0
Cheers,
barneyb
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 10:08 AM
> To: CF-Talk
> Subject:
Off topic: When a table is opened in Access in the spreadsheet-like view,
sometimes a boolean Yes/No field appears as -1/0 and sometimes as
checkboxes. What controls this, and is it indicative in any way of how
the data field itself is defined?
On topic: Is it always safe to do a query on an Ac
I just went thru something like this try this:
INSERT INTO tablename(column2)
VALUES ('#good#')
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 12:21 PM
To: CF-Talk
Subject: RE: Access Question
Usually when I get a message
Usually when I get a message like that in sql it usually means I forgot
something simple like a comma. Are you inserting several things?
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 1:06 PM
To: CF-Talk
Subject: RE: Access Question
I
e Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 12:27 PM
To: CF-Talk
Subject: RE: Access Question
> I'm having a tough time with an access query. I'm sure
> it's something simple, but I had shoulder surgery
> yesterday so I have a ball pumping goodies in
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2002 17:18
To: CF-Talk
Subject: Access Question
I'm having a tough time with an access query. I'm sure it's something
simple, but I had shoulder surgery yesterday so I have a ball pumping
goodies into the shoulder at
> I'm having a tough time with an access query. I'm sure
> it's something simple, but I had shoulder surgery
> yesterday so I have a ball pumping goodies into the
> shoulder at it's own discretion. :-)
>
> INSERT INTO subdir
> VALUES ('#good#')
>
> And the table is:
> subdir_id (autonumber)
I'm having a tough time with an access query. I'm sure it's something
simple, but I had shoulder surgery yesterday so I have a ball pumping
goodies into the shoulder at it's own discretion. :-)
INSERT INTO subdir
VALUES ('#good#')
And the table is:
subdir_id (autonumber)
subdir (text)
The erro
Yep, CFUPDATE is one of those tags you really shouldnt use :-)
-Original Message-
From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2002 19:38
To: CF-Talk
Subject: Re: Access Question
with cfupdate, you have to name the form fields the same as the table
fields.
if
y Yiap" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 2:36 PM
Subject: RE: Access Question
> I'm using CFMX. My query is pretty simple TABLENAME="Site"> and .
> The fields missed are pretty consistent, but there we
: jon hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 11:04 AM
To: CF-Talk
Subject: Re: Access Question
Some questions.
Which CF version?
Can we see the queries? Code good, theory unproductive ;)
Are the fields that get missed consistent?
Are you able to reproduce the error, and if so wha
Some questions.
Which CF version?
Can we see the queries? Code good, theory unproductive ;)
Are the fields that get missed consistent?
Are you able to reproduce the error, and if so what does the query
look like in the debug?
--
jon
mailto:[EMAIL PROTECTED]
Friday, August 9, 2002, 1:48:00 PM
I'm doing a project the has INSERT INTO, UPDATE and DELETE forms. My
question is when I do my INSERT INTO or UPDATE, not all of my table form
fields get inserted or updated. I can't figured out the glitch, sometimes
it's fine and other times it would miss a couple of fields. How can I make
sure
That LOOKS like it should work.
What is the column's datatype, and did you try
#CreateODBCDate(attributes.datebox)# ?
John McKown
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 8:43 PM
To: CF-Talk
Subject: Access Question
I ha
Try ...
WHERE message_date = '#attributes.datebox#'
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:45 PM
To: CF-Talk
Subject: Access Question
I haven't used access much, so I'm sure this is going to sound dumb,
y, that my child may have peace'?"
- Thomas Paine, An American Crisis
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:43 PM
To: CF-Talk
Subject: Access Question
I haven't used access much, so I'm sure this i
AIL PROTECTED]>
Sent: Thursday, October 18, 2001 5:43 PM
Subject: Access Question
> I haven't used access much, so I'm sure this is going to sound dumb, but
> can you think of a reason that I get 0 records for this query when I can
> see there's a record in the db wit
[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 5:45 PM
> To: CF-Talk
> Subject: Access Question
>
> I haven't used access much, so I'm sure this is going to sound dumb, but
> can you think of a reason that I get 0 records for this query when I can
> see there
you could try ensuring that Access reads this as a date by using
ODBCDateFormat. Also check that message_date is a date field in your db.
Cheers
Will
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: 19 October 2001 01:45
To: CF-Talk
Subject: Access Question
I
USE #CreateODBCDate(attributes.datebox)#
- Original Message -
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 22, 2001 4:40 PM
Subject: RE: Access Question
> It's doing the math. It thinks 10/18/20
e the between
keyword to check for messages between (attributes.datebox) and
(attributes.datebox - 24 hours)to take account of this. Hope that makes
sense.
Kola
> -Original Message-
> From: Greg Luce [mailto:[EMAIL PROTECTED]]
> Sent: 19 October 2001 01:45
> To: CF-Talk
> Subj
'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:43 PM
To: CF-Talk
Subject: Access Question
I haven
I haven't used access much, so I'm sure this is going to sound dumb, but
can you think of a reason that I get 0 records for this query when I can
see there's a record in the db with a date of 10/18/2001?
SELECT*
FROM messages
WHERE message_date = #attributes.datebox#
The debugging sho
I haven't used access much, so I'm sure this is going to sound dumb, but
can you think of a reason that I get 0 records for this query when I can
see there's a record in the db with a date of 10/18/2001?
SELECT*
FROM messages
WHERE message_date = #attributes.datebox#
The debugging sho
> You are close, the percent sign (%) is your wildcard not (*) just replace
> the character and it should work fine.
>
Doh!!! I should have seen that. : ]
Thanks
Art
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
ssage-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:31 AM
To: CF-Talk
Subject: Easy access question
I want to search a dictionary table in an access database. I want to find
all records where the name starts with the letter T.
select * from dic
where name
Art, try using a % instead of * in your Select statement.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 12:42 PM
To: CF-Talk
Subject: Re: [Easy access question]
T%
"Art Broussard" <[EMAIL PROTECTED]> wrote:
I want to search a dic
Try % instead of *
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index
where name like 'T%'
At 01:31 am 24/05/01 , you wrote:
>I want to search a dictionary table in an access database. I want to find
>all records where the name starts with the letter T.
>
>
>select * from dic
>where name like 'T*'
>order by name
>
>
>This should give me any reco
]]
Sent: Wednesday, May 23, 2001 8:31 AM
To: CF-Talk
Subject: Easy access question
I want to search a dictionary table in an access database. I want to find
all records where the name starts with the letter T.
select * from dic
where name like 'T*'
order by name
This shou
gt;
cc: (bcc: Jan E Perlmutter/BISYS_BPS)
Subject: Easy access question
I want to search a dictionary table in an access database. I want to find
all records where the name starts with the letter T.
select * from dic
where name like 'T*'
order by name
This should giv
> -Original Message-
> From: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 11:31 AM
> To: CF-Talk
> Subject: Easy access question
>
>
> I want to search a dictionary table in an access database. I want
> to find all records where the
: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:31 AM
To: CF-Talk
Subject: Easy access question
I want to search a dictionary table in an access database. I want to find
all records where the name starts with the letter T.
select * from dic
where name like
That should work. What are you getting?
You can also do this:
select * from dic
where Left(name,1) = 'T'
order by name
-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:31 AM
To: CF-Talk
Subject: Easy access questio
al Message -
From: "Art Broussard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 11:31 AM
Subject: Easy access question
> I want to search a dictionary table in an access database. I want to find
all records where the name starts
T%
"Art Broussard" <[EMAIL PROTECTED]> wrote:
I want to search a dictionary table in an access database. I want to find all
records where the name starts with the letter T.
select * from dic
where name like 'T*'
order by name
This should give me any record that has the first lette
I want to search a dictionary table in an access database. I want to find all records
where the name starts with the letter T.
select * from dic
where name like 'T*'
order by name
This should give me any record that has the first letter in name start with T right?
Wrong. : (
Wh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi Jann,
I had the same question a couple weeks back. I was told, but I never
confirmed, that it was version 4.01 that introduced this
functionality.
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.3
'form.refpresdate is not ""'
and will throw an error.
Question: Which version of CF first did short-circuit processing?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 8:05 AM
To: CF-Talk
Subject: RE: Access qu
This is what I use:
#CreateODBCDate(form.RefPresDate)#Null,
On Thu, 11 January 2001, "Sean Daniels" wrote:
>
> > If a field in access has never had anything in it at all does it appear as
> > NULL or as "".
>
> It appears as null.
>
> > So would you check it with or would you use > FieldN
has always worked for me.
Shawnea
- Original Message -
From: "Kevin Schmidt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 11:08 AM
Subject: Access question
> If a field in access has never had anything in it
> If a field in access has never had anything in it at all does it appear as
> NULL or as "".
It appears as null.
> So would you check it with or would you use FieldName IS NULL>
Well, ColdFusion does not support the word "NULL", so you would use the
. Or, many people prefer:
The latter is
If a field in access has never had anything in it at all does it appear as
NULL or as "".
So would you check it with or would you use
Kevin Schmidt, Web Technology Manager
Allaire Certified ColdFusion Developer
pwb inc.
integrated marketing communications
350 S. Main St., Suite 350
Ann Arbor,
rs.com
ICQ: 346566
--
> -Original Message-
> From: Robert Orlini [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 8:05 AM
> To: CF-Talk
> Subject: RE: Access question
>
>
> Thanks for the qu
12, 2000 7:33 AM
> To: CF-Talk
> Subject: Access question
>
>
> Hello,
>
> I have an Access database of email login addresses in an Access
> 2000 table.
> Outside users that have registered enter their login address and then are
> sent via a .cfm form to a U
At least in some previous versions, I understood MySQL could not do the
following:
WHERE ID IN (12,45,78,999,etc)
Apart from this (if the limitation still exists, for which there's a
workaround) how practical would it be to have the "offline updateable
version of the database" in SQL7 and the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
MySQL is now GPL (or similar) on Windows as well as Unix/Linux.
c
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt - http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD
-
-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:47
To: CF-Talk
Subject: RE: Access question
Hey Andy,
I refer you to his original question: "Can it handle simultaneous access
from many users or is SQL better for this".
H
I think this is more of a project by project discussion. There cant be a set
of truths that can be applied to everything, customer is the one to make
that descision anyways:
"Right now you don't get many hits on your server, we can use access as the
main database to save you money, access is a de
on 10/13/00 12:51 AM, Ryan at [EMAIL PROTECTED] wrote:
> Still, MySQL will run on winblows and is free. Actually now that I think
> about it I think its free unless you run it on windows, in that case its
> a few hundred or thousand $$ or something... but they may have removed
> that restriction.
nto a db
anyway?
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 16:05
To: CF-Talk
Subj
l Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:47
To: CF-Talk
Subject: RE: Access question
Hey Andy,
I refer you to his original question: "Can it handle simultaneous access
from many users or is SQL better for this".
His "problem" w
--
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:52
To: CF-Talk
Subject: RE: Access question
>There's no point forking out for a SQL internet license if you can use
>Access for free and it does the job you
> I refer you to his original question: "Can it handle simultaneous access
> from many users or is SQL better for this".
>
> His "problem" was many users, not a small db.
His problem was actually that users were not getting validated correctly,
which IMHO probably isn't an error you would likely
12 October 2000 15:47
To: CF-Talk
Subject: RE: Access question
Hey Andy,
I refer you to his original question: "Can it handle simultaneous access
from many users or is SQL better for this".
His "problem" was many users, not a small db.
Nonetheless, I agree with Bill's
connections to it.
> -Original Message-
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 10:48 AM
> To: CF-Talk
> Subject: RE: Access question
>
>
> We all must remember Access is mainly
> a desktop database. It was never design
>There's no point forking out for a SQL internet license if you can use
>Access for free and it does the job you need it too. Don't get me wron - I
>admit SQL is a thousand times better than Access but if you've only got a
>tiny database, what's the point?
Tiny or large, Access can not handle si
TECTED]]
Sent: 12 October 2000 15:48
To: CF-Talk
Subject: RE: Access question
We all must remember Access is mainly
a desktop database. It was never designed
as a database backend for web data or to
withstand simultaneous hits.
I used Access as well for the database
backend but had so many end us
]]
Sent: Thursday, October 12, 2000 10:39 AM
To: CF-Talk
Subject: RE: Access question
Aaron - I refer you to Bill's excellent quote:
"Don't provide a Star Trek solution to a Babylon 5 problem"
There's no point forking out for a SQL internet license if you can use
Access
Subject: RE: Access question
Sure, it can "handle" simultaneous Access from many users. A bunny might be
able to handle a wolf for about 2 seconds, then it dies. Same with Access.
I've had sites crash every 2 minutes using Access, move it to SQL and it
works fine.
Use SQL. Don'
riginal Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:33
To: CF-Talk
Subject: RE: Access question
Sure, it can "handle" simultaneous Access from many users. A bunny might be
able to handle a wolf for about 2 seconds, then it dies. Same with Access.
At 10:04 10/12/00 -0500, you wrote:
>Thanks for the quick reply.
>
>At this point I am more concerned about simultaneous access. Can it handle
>simultaneous access from many users or is SQL better for this.
I don't think Access can handle much for simultaneous access at all.
I would move to MySQ
.
AJ
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 10:27 AM
To: CF-Talk
Subject: RE: Access question
It can handle simultaneous Access. Access is just a toned down version of
SQL (which it sounds like you already know). You should base you
alk
Subject: RE: Access question
Thanks for the quick reply.
At this point I am more concerned about simultaneous access. Can it handle
simultaneous access from many users or is SQL better for this.
Thanks Andy.
Robert O.
>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTEC
ctober 12, 2000 8:49 AM
>To: CF-Talk
>Subject: RE: Access question
>
>
>How much data is in the table? I would be extremely surprised if this was
>due to there being too much data in the table. I think the maximum size of
>an Access mdb is approx 2gb but I aint sure about this.
Hello,
I have an Access database of email login addresses in an Access 2000 table.
Outside users that have registered enter their login address and then are
sent via a .cfm form to a URL.
Yesterday my .cfm form started rejecting some users saying it could not find
their address in the table. Is
--Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:33
To: CF-Talk
Subject: Access question
Hello,
I have an Access database of email login addresses in an Access 2000 table.
Outside users that have registered enter their login address and then are
sent via a
Hello,
I have an Access database of email login addresses in an Access 2000 table.
Outside users that have registered enter their login address and then are
sent via a .cfm form to a URL.
Yesterday my .cfm form started rejecting some users saying it could not find
their address in the table. Is
You can probably use ADSI and VBScript to do it. There is a way to
manipulate Outlook using ADSI
John
I want to know if anyone has ever attempted the impossible and how it was
done. I have about 300 names in an Access database that I would like to send
a mass email to, but the Access database
Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 8:00 PM
To: [EMAIL PROTECTED]
Subject: Crazy MS Outlook/Access Question
Hi,
I want to know if anyone has ever attempted the impossible and how it was
done. I have about 300 names in an Access databa
Hi,
I want to know if anyone has ever attempted the impossible and how it was
done. I have about 300 names in an Access database that I would like to send
a mass email to, but the Access database did not contain their email
addresses. What I was thinking is since they all work for the same com
73 matches
Mail list logo