On Sat, 28 Jul 2001 04:24:31 +1000, "Mike Kear" <[EMAIL PROTECTED]>
wrote:
>I'm really interested in this because I've had no end of problems when I
>upsize an access table and SQL7 sets the fields to nvarchar or ntext. I
>have to go in and manually change them to varchar and text. Yet other
>
On 7/28/01, C. Hatton Humphrey penned:
>I guess my other wish would be to have a better validator in place.
>Granted, I work with Studio 4.0.1 so I may be behind the times a tad on that
>aspect, but the validator included with my version throws fits if I
>around a or close a form tag in the "wro
On 7/27/01, Mark Warrick penned:
>OK I made a mistake.
>
>In the CFAdministrator, I disabled the CFREGISTRY tag. And then I
>discovered that once you do that, you can no longer use the CFAdministrator.
>Great.
>
>So, how do I get that thing turned back on now?
>
>---mark
I've always kept cfregis
Hi
Can any one inform me of a way to link from a SQL Db to an
access db table?The access table in future will be transfered to SQL
7,but not yet. I know about the import etc but i would like the SQL
database to be linked to a live Access Table.
Any Ideas??
Jerry Staple
Web Applicat
Man. I come across stuff like this and it simply makes me dizzy
trying to figure out what is wrong.
While looking at my errors log, I find a bunch of these:
The QUERY attribute of the tag does not specify the name of an
available queryThe error occurred while processing an element with
a gene
Check your or statement that determines the query
carefully...chances are there is some combination of circumstances - maybe
rare - that will not run either query.
D
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 28, 2001 9:02 AM
To: CF-Talk
Subject: How do
Bud,
I have seen this in some of my code also, where the query in question
exists. It occurs only occasionally. I think that some browser versions
occasionally "drop" or forget to pass some of the variables from one page to
the next (or CFAS loses them).
Mike Cady
- Original Message -
Terry - can you add a category for Studio (or tell me where it is)? I know
it's a different product, but there are some issues there, I would love to
see addressed.
Regards.
-Bill
www.brainbox.tv
- Original Message -
From: "Terry Ford" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]
Try this...
#nextq#
You should get (if you try this in July) the month returned as "10"...
No problem.
However.. Try this...
#nextq#
And you get the month returned as "6". Huh?? I thought quarters were
January, April, July and October? How does one get a "6" as the first
month in
First the date is in mm/dd/ format
and 3 represents 1st quarter so adding another 1 quarter results in 6..
by the way a quarter is 3 months.
- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 11:07 AM
Subject:
Yes.. But... (isn't there always one?? ;)
You're correct.. Except that a "Quarter", when used in calendar terms,
means Jan-Mar, Apr-Jun, Jul-Sep, and Oct-Dec. So by using the first
test, with "now()" as the date it answers correctly. However, when
using a random date, it does not... It simply a
Turn on your debugging and look to see if the query shows up in your list of
run queries. That will give you a better starting point from which to
figure out what's really going on.
I'm guessing that the ID isn't really getting passed, or it's some weird ID
that doesn't satisfy the statement.
Don't forget, some fiscal years start and end in February. Therefore, fiscal
1Q 2001 would be Feb-Apr.
- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 2:46 PM
Subject: RE: DateAdd Strangeness? (Or is it me?) --it'
Bill, Macromedia are working on the new version (5.0) right now.
Check out "http://beta.allaire.com";.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bill
Davidson
Sent: Sunday, 29 July 2001 1:47 AM
To: CF-Talk
Subject: Re: Vote on ColdFusion Enhancemen
- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 12:46 PM
Subject: RE: DateAdd Strangeness? (Or is it me?) --it's you!!
> Yes.. But... (isn't there always one?? ;)
>
> You're correct.. Except that a "Quarter", whe
Yeah, I am well aware of it, thanks. There's just a few things I think could
benefit from the voting system. I really appreciate the MM people putting
this up for CF. It shows that at least they appear to care, which makes me
happy! Beta testing and feature requests should not go together. The
I'm getting SQL/ODBC Error when incorporating the following CF code and
Stored Procedure... Anyone had this?
There are not triggers as well...
Error:
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthori
Bud,
I had a similar problem with more that one site in the past. I finally
figured it out (quite by accident)
when I was testing some error handling on a form submission. I entered
some garbage input and submitted the
form on the resulting test page I was outputting the list
Form.fieldnames on
Bill... Agreed!
I just finished downloading the latest build of Studio 5 (beta 2) on a 33.6K
connection. I'm that keen!
About to start using it to see if the promised improvements are there.
Some comments in the forums appear to want something totally "new" for
Studio. I disagree. It has a fine
Is it possible to have a null Datetime field although I have allowed
nulls, it still complains. Or would it be better to have a very distant
past date...
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusion
- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 11:38 PM
Subject: SQL Datatype Datetime
>
> Is it possible to have a null Datetime field although I have allowed
> nulls, it still complains. Or would it be bette
Hi
Can any one inform me of a way to link from a SQL Db to an
access db table?The access table in future will be transfered to SQL
7,but not yet. I know about the import etc but i would like the SQL
database to be linked to a live Access Table.
Any Ideas??
Jerry Staple
Web Applicat
Sorted!
-Original Message-
From: Jerry Staple
Sent: 29 July 2001 07:57
To: CF-Talk
Subject: SQL 7.0 linking Tables to Access
Hi
Can any one inform me of a way to link from a SQL Db to an
access db table?The access table in future will be transfered to SQL
7,but not yet. I know
23 matches
Mail list logo