I haven't used access in quite a while, but I believe you can control the
formatting of boolean fields in the schema edit form, down in the bottom
part where all the options are.
If you're using an integer in a boolean context, the safest bet is always
comparing to zero, because zero is always t
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
What is the name of the table?
Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]
This email, together with any attachments, is for the exclusive and
confidential use of the addressee(s). Any other distrib
> 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)
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
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 haven't used
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, but
can you think of
Like I said earlier:
If I use single quotes around #attributes.datebox# it gives me an error
saying "datatype mismatch".
I just disregarded using access and made a SQL Server db for it. It
works in SQL Server.
Greg Luce
954-763-4504
It's doing the math. It thinks 10/18/2001 is 10 divided by
This is what works for me. I don't know if it's the best way but it seems
to work fine with access and ODBC drivers.
Good Luck
David
DT = #CREATEODBCDATE(FORM.P_DATE)#
- Original Message -
From: "Greg Luce" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October
Try:
SELECT*
FROM messages
WHERE message_date = #CreateODBCDate(attributes.datebox)#
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
> -Original Message-
> From: Greg Luce [SMTP:[EMAIL PROTECT
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 have
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
Greg
Try the following - should work.
SELECT*
FROM messages
WHERE message_date = #CreateODBCDate(attributes.datebox)#
one word of warning this may or may not take the time into consideration, if
you test this and it
still does not work correctly you'll actually have to use the be
It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by
2001. Use single quotes.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
"What father would hesitate to say 'if there m
-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 at all does it appear as
> NULL or
> 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
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
Not enough data to give you a logical answer or suggestion. Can you create a test
account for us to check out on the web somewhere?
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Pe
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
TED]]
>Sent: Thursday, October 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
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.
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. I know that you can
have a whole load of records in a table though (millions) not that you
47 matches
Mail list logo
