HI,
I am a Web designer who has found this list to be one of the best for CF
help. I am a part of a small team working free to put together a conference
this spring, Alternative Therapies for Special Kids (www.4healthykids.org)
The conference's focus are alternative health approaches for kids
thanx ppl!!
problem solved!
but hmm.. anyone know how to hide the popup.. under the parent page.. so
that the user dun even know theres a pop up to generate it...??!!
HAPPY MAN,
han
- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday,
hihi hmm my customer required a booking request whereby the booking
will be automatically cancelled after 3 days if it is not confirmed
i have a Status Column for that booking table and a Booking Date
column
so how do i enable the system to automatically update the status
column ??
eg
Hi all
This was obviously a tricky question since I got no response - so I'll
repost it below BTW the tables aren't set in stone - they could be
redesigned to make this work
I need to display teaching resources assigned to a course
Each course should show:
All resource names, and the total
If you are using SQL Server,
then I think the best way would be to set up a trigger is sql server
that
will do the checking.
-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 10:21 AM
To: CF-Talk
Subject: Auto running of Codes to update
The language file is simply a list of variables. Each one represents a
different string that appears in the application. The work is swapping out
each native string in your application with a variable. Tedious and
time-consuming...
To switch languages, if Application.cfm sees the language
What is bork bork bork?
Look in the preferences on Google, now that's a language pack :)
They even have elmer fudd, Klingon, and bork bork bork! in there, lol
_
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
Hi,
I am having some performance issues on a server hosting a CF app.
Basically at certain times of the day the DLLhost.exe is over 1 GIG in
size! Has anyone experienced this before, and if so whats the work
round (let me guess, lock all session/application variables) : )
Nick.
Hi,
I am trying to connect to a SQL Server database and keep getting the
following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection
No matter what user I create etc I cannnot connect.
Any help
A verity collection I have has about 16,000 records, pulled from
three fields in a database (ID, publication, keywords). I've set
the
CFIndex Body=publication, keywords, and the title to
publication
Problem - for some searches using a single term, where I know
there
should be about 9,000
Hello,
I was wondering if there is a way to abort a particular CF Template, but not
all CF processing? Right now I'm wrapping my code with CFIF tags which
determine if the code will run or not
CFIF animal IS dog
run a bunch of code
run a bunch of code
run a bunch of code
run a bunch of
Sorry about that last one, I guess it's dangerous to hit tab and enter
rapidly
I was wondering if there is a way to abort a particular CF Template, but not
all CF processing? Right now I'm wrapping my code with CFIF tags which
determine if the code will run or not
CFIF animal IS dog
run
Try using CFEXIT
HTH
-Original Message-
From: Louis Klepner [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 13:38
To: CF-Talk
Subject: CFABORT template, not all CF processing?
Sorry about that last one, I guess it's dangerous to hit tab and enter
rapidly...
I was wondering if
Thank, I suppose I'm due for a RTFM on this one :)
Lou
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mike Town
end
Sent: Thursday, February 28, 2002 8:44 AM
To: CF-Talk
Subject: RE: CFABORT template, not all CF processing?
Try using CFEXIT
Hey Paul,
I struggled with CFREPORT for a while and when I got it to work I found t
he
results were really not professional. If you look thru the archives you'l
l
see that most peopel are not getting what they want.
So I took the advice of someone on this list and puchased Recrystalize. A
n
I have 2 boxes One is a Win 2k web server and the other is a Win 2k SQL
server I need to get the web server talking to the SQL server so I can
get CFServer 5 hooked up Can some one give me a quick how to or send
me a link to some place that can help? I have 3 different books been all
over the
The web server doesn't connect to SQL Server, your db middleware, in
this case Cold Fusion, connects to the SQL Server
I have 2 boxes One is a Win 2k web server and the other is a Win 2k SQL
server I need to get the web server talking to the SQL server so I can
get CFServer 5 hooked up Can
How much does Recrystalize cost?
T
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 8:37 AM
To: CF-Talk
Subject: Re: CFREPORT :: (CRPE32.DLL) could not be located
Hey Paul,
I struggled with CFREPORT for a while and when I got it to
Sounds like you are doing the wrong kind of join. When you want all
the
records from one table (in your case resources) and only those record
s from
the other table that match (in your case events) that calls for INNER
,
OUTER, LEFT and/or RIGHT joins.
Here is an example from Access that
A web user on my site got the below error, I can't reproduce it. Does
anybody know what this means or what could be causing it? Thanks.
--
Error Occurred While Processing Request
Error Diagnostic Information
Synchronization error. Please paste the text of
If your Web server is outside you firewall (in a DMZ) and your database
server is behind the firewall (Intranet) you may have to open a port in
your
firewall to allow your Web server to talk to your database server.
Hope this helps,
Nicholas W. Watson
Software Engineer
Concurrent Technologies
On 2/28/02, Phillip Broussard penned:
I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL
server. I need to get the web server talking to the SQL server so I can
get CFServer 5 hooked up. Can some one give me a quick how to or send
me a link to some place that can help? I
Crispin,
Aren't you only asking for resources booked on a particular date:
Events.Event_Date = #variables.EventDate#?
Wouldn't it be better to Order By or Group By #variables.EventDate# and
remove the #variables.EventDate# from the Where clause? This would give
you
all the resources for that
Ok I am sure this has been discussed before but I am going to send a message
anyway then I will
go search the archives. :) Anyway I have a client who INSISTS on using
Cybercash, so don't
even recommend going w/ someone else, already tried that. I am sure they will
switch once they
see how slow
www.verisign.com.
They own cybercash. Call them for the latest and greatest.
Mike
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 11:03 AM
To: CF-Talk
Subject: CyberCash
Ok I am sure this has been discussed before but I am going to
Can the Web server see the SQL server on the network?
The setup is fairly simple:
1) Install CF on the Web server.
2) If necessary, install the latest SQL Server ODBC driver, freely
available
on M$'s Web site.
3) Use the CF administrator to set up an ODBC connection to the SQL
Server.
We use CFX_Cybercash (available ... well just about everywhere, including
the Macromedia Developer's exchange).
Free and easy to configure. Have not found it to be slow. Only issues we
have are with Cybercash's admin, which is a whole different ball of wax.
But if you need to use Cybercash,
What's the typical way to copy one's development DB to production
(SQL2000)? Changes will commonly be made on Dev, and there will be an
existing version on production which will need to be overwritten
I know about the copy database wizard, but AFAIK, it doesn't work if
the DB already exists on
We are using Payflow they are verisine also.
-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 10:31 AM
To: CF-Talk
Subject: Re: CyberCash
We use CFX_Cybercash (available ... well just about everywhere,
including
the Macromedia
use the client configuration manager to create a friendly servername for
your sql server.
type cliconfg in the run box on the start menu.
Under the alias tab, create a new alias pointing to the SQL server's IP and
make sure network Lib's are on TCP/IP (if thats what you want)
In CF admin,
The simple answer is no, not just with CFCONTENT.
You would need to use a COM object or create the page via VBScript in
order
to make this happen.
In your VB code, you will end up creating an object based on the column
you
are trying to choose. I think the command is:
Backup your dev database to a file, upload it to live server, and force
a
restore over the current db, works for me.
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 16:37
To: CF-Talk
Subject: Moving MSSQL DB from Dev to Prod
What's the typical
Here you go:
http://www.recrystallize.com/merchant/orderform.htm
- Original Message -
From: Tammy Hong [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 10:26 AM
Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located
How much does Recrystalize
If they are setting up a new account with Verisign, they will ONLY be able
to get PayFlowPro as Cybercash is being phased out.
Shawnea
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 11:02 AM
Subject: CyberCash
I'm evaluating whether to use Fusebox methodology for our next Intranet My
question is how does fusebox work with CF Advanced Security? We use our NT
Security groups for many of our apps Don't want to lose that
Thanks
__
Get
As I clearly stated they are NOT switching they already have Cybercash.
Looking for a Cybercash tag... So for now they will stick with that if
Verisign
makes them switch later they will have to deal with that at the time.
-KLM
[EMAIL PROTECTED] writes:
If they are setting up a new account with
Fusebox isn't really a changing of anything, all that it does it allow you
to have a more thought out way of managing your code. It borrows things from
oop where it applies. I use it as much as I can, I would not go back. It
allows me to reuse code much easier.
Robert Everland III
Dixon
Maybe I read the question wrong. But by web server I meant IIS, Apache,
etc... How is a web server going to talk to a database?
If his web server BOX can't see his SQL Server BOX, than that's simply a
networking issue.
I have to disagree with this to a point. If the web server cannot 'see' t
For me, the concept of Fusebox is good, but in practicality it becomes a
pain to debug... having to track back through ALL included files to find an
error...
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 9:54 AM
To: CF-Talk
Lot's of ways to get around that... like including the template name in
comments on each page.
!-- Here's an example //--
Mike
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 12:02 PM
To: CF-Talk
Subject: RE: Fusebox Question
For
I went to the developers section and when I try to download
CFX_Cybercash (which appears to download from Cybercash's site) it's not
found.
Does anyone have a copy?
Also I just spoke w/ Verisign, while they are merging Cybercash with their
existing
service customers who have Cybercash will not
My boss wants me to spec out the process of taking credit card orders over
the web I have limited experience with this and any help you guys can give
me is appreciated
Thanks,
Steven D Dworman
-
Web Consultant
Systems Administrator
Three stage process:
1. secure connection to enter info (card details) - either unique or third
party vendor
2. checking system - either unique or third party vendor
3. paying system - either unique or third party vendor
The best solution for a simple fix is to go with a third party vendor who
The process is not very difficult.
Set up a payment gateway and a merchant account.
1) The payment gateway is the service you use to verify the available
credit. Verisign is a good service, and so is Stacy Young's company
(sfcommerce.com). Call them to set up an account, and they will ask you
Oh yeah!!! You are absolutely correct! John, tell Matthew
what he's won. ;)
-Jake
--- Matthew Walker [EMAIL PROTECTED] wrote:
Hey ho! The problem is having a table called Update! Try
wrapping [] around
update.
-Original Message-
From: Jake Munson [mailto:[EMAIL PROTECTED]]
Shawn,
For me, the concept of Fusebox is good, but in practicality it becomes a
pain to debug having to track back through ALL included files to find
an
error
Not sure what version of CF you are using, but CF4x and CF5 debug
information gives the file name of the template where the error
You need to install the SQL Server client network utility
on the Web/CF server Set up an alias using TCP/IP in that
to the SQL Server IP Address Then go into ColdFusion
Administrator, set up an ODBC datasource using SQL Server
Enter the database name, the login and password and you can
I was wondering if there is a way to abort a particular
CF Template, but not all CF processing? Right now I'm
wrapping my code with CFIF tags which determine if the
code will run or not
Try using CFEXIT
That'll only work if called from within a custom tag Otherwise, it'll
simply
Dave,
I've found that installing he client utility improves my performance via
ODBC. Is there a network library that's overwritten when you install it?
That's always been my guess.
Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002
CFEXIT will, when called on a regular template (non-custom tag) allow
onrequestend.cfm to still be processed.other than that, it behaves
the
same as cfabort, as Dave pointed out.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion 5 Developer
Fig Leaf
The short answer is, you can't The longer (and more
useful) answer is to simply pass the value that the
constant represents, instead of trying to pass the
constant itself Just look up what wdRowHeightExactly
contains (it's probably an integer) and pass that instead
just wondered,
Sorry for the arguably WOT post
Well here's the problem I'm over my bandwidth quota My ISP changed how it
did its billing in December, to squeeze the sponge a little harder if you
will, and all of a sudden I am a bustin' out of my quota!!!
Given all of this extra traffic - I need to do some
What about cfexit method=EXITTEMPLATE?
_
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 12:54 PM
To: CF-Talk
Hi
The text below is randomly appearing at the top of some of my web pages:
HTTP/11 200 OK Server: Microsoft-IIS/50 Date: Thu, 28 Feb 2002 17:45:56
GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb
2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537
What
I've found that installing he client utility improves my
performance via ODBC Is there a network library that's
overwritten when you install it? That's always been my
guess
I have no idea I've never noticed any difference, but that's probably
because I usually update the MDAC layer anyway
Try this out, cfexit will only exit from the included template, and run
everything else.
You can also use cfexit method=EXITTAG if you only want to exit from
a tag.
!--- contents of test1.cfm ---
cfinclude template=test2.cfm
pThis should always show
!--- contents of test2.cfm ---
cfif 1 EQ 1
thanks for the tips. they should help plenty.
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 12:25 PM
To: CF-Talk
Subject: someone want to help me?
My boss wants me to spec out the process of taking credit card orders over
the web.
Hey All,
OK I'll do my bets to explain what I'm trying to accomplish:
I want to build a tool that allows the user to visually build an equation. The
building blocks for
the equation are essentially fields in a database. I'd like to display these
building blocks in a
list and give the user
OTTOMH,
What about two select boxes, one containing a list of fields, and one
containing operators.
Use the onChange event to fire off some Javascript to concatenate each
building block to the current equation. Then have the javascript put
the
updated equation to a textarea or something like
We have just worked side by side with CDG Commerce
(http://www.cdgcommerce.com) and wrote a custom tag to process orders
realtime (or not). It is very very simple and easy to implement.
If you sign up through QuillDesign, there are no setup fee's so basically
its free for you to get setup and
I Have posted this one 3 times an no response I don't know why but maybe
someone could explain the behavior of CFHTTP on a machine with multiple IPS?
Thanks,
Neil
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256
Neil - it will come from the IP that the application is running on.
Shawnea
- Original Message -
From: Neil H. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 1:51 PM
Subject: CFHTTP origin IP
I Have posted this one 3 times an no response. I don't
Need help with an issue I need to be able to detect the users
encryption level set in there browser If the users browser
does not support 128 bit encryption, I'm gonna bump them to
a page telling them to upgrade their browser
I know there is a cgi environment variable (https_keysize),
but
I haven't seen that to be the case. Just to confirm I did a couple of tests.
The cfhttp always seems to use the primary ip address of the machine.
jon
- Original Message -
From: Shawnea Carter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 1:58 PM
The text below is randomly appearing at the top of some of my web
pages:
HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002
17:45:56
GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu,
28 Feb
2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537
Has anyone been able to get this to work with user management turned on?done
this with coldfusion? I know that their are a couple of tags out their and
I've bought them but they are out of data and doesnt seem to be working
correctly
Ernie Pena
http://wwwAtomicqubecom
Gyrus,
CFHTTP.Header would probably do the trick :-)
HTH,
Andrew
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 1:13 PM
To: CF-Talk
Subject: Re: What are these, headers?
The text below is randomly appearing at the top of some of my
We've seen this with CF 5 when we use CFHTMLHEAD. If we use CFHTMLHEAD
in a template before the actual HTML head tag, we'd sometimes see the
HTTP headers appear above the HTML output. This happened more often when
we did a redirect to the page (ie cflocation).
We moved all of our CFHTMLHEAD
#cfhttp.responseHeader[http_header_key]#
or
getHttpRequestData()
depending on which headers you want
:)
jon
- Original Message -
From: Gyrus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 2:13 PM
Subject: Re: What are these, headers?
The text below
I Have posted this one 3 times an no response I don't
know why but maybe someone could explain the behavior
of CFHTTP on a machine with multiple IPS?
It's going to behave like any other TCP/IP client application On Windows,
there's a first IP address, which will show up either first or last
Yup...that's along the lines of what I'm after (and I've thought of something along
those lines),
but I'm not sure if it will be user friendly enough. Any other thoughts folks? mabye
CF and Flash?
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p.
Need help with an issue I need to be able to detect the users
encryption level set in there browser If the users browser
does not support 128 bit encryption, I'm gonna bump them to
a page telling them to upgrade their browser
I know there is a cgi environment variable (https_keysize),
you could do a custom error page in IIS trapping error 403.5. that's
the HTTP 403.5 - Forbidden: SSL 128 required
christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: FARRAH NG
Just now, I used the import wizard, and there's an option to overwrite
data on production (right now, the servers don't have the rights to
each other's file systems).
How does this compare to the backup on development/restore on
production strategy?
Thanks,
Jamie
On Thu, 28 Feb 2002 16:32:22
Put the cfhttp inside an HTML comment !-- --
Rick
-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 12:13 PM
To: CF-Talk
Subject: What are these, headers?
Hi
The text below is randomly appearing at the top of some of my web
pages:
CF + FLASH would/could work in theory - the visual system would have to
have symbols (flash term) for each character/symbol you needed (perhaps with
a scrolling up/down sort of fly-wheel system of choosing them) - which could
then be dragged and dropped onto a math page - this would trigger an
Just wanted to let the list know about an article I recently did for
O'Reilly's web site oreillycom The article highlights best practices for
writing UDFs and is called Top Ten ColdFusion UDF Tips You can view the
article at
http://wwworeillynetcom/pub/a/javascript/2002/02/22/udftipshtml; I
Hello All,
Here is a good one I have been thinking about this for a while
and I can not figure it out!
I am doing a schedule thing and I need to see if let's say at the time
it goes, if we are the 1st of the month to get yesterday's date So I
cab take that and format it with dateformat
I've used CFTRY/CFCATCH before But I've never been clear on exactly how to
catch specific ODBC type of errors, to put up a custom error message
I want an error message for : ODBC Error Code = 22001 (String data right
truncation)
If that error comes up, as opposed to any other error, I want to
I'm sorry, I'm not sure what you are asking. Are you asking how to get
the
previous day's date?
Kathryn Butterly
Web Developer
Washington Mutual Finance
813 632-4490
[EMAIL PROTECTED]
-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28,
I'm not quite sure what you are asking. Are you trying to determine if
you are on the first day of the month?
cfif day(now()) is 1
It's the 1st. Arm the Star Destroyers
/cfif
===
Raymond Camden, Principal Spectra
when you trap an error of type database, you're provided with SQLState
and NativeErrorCode. examine these with your CATCH, then do what you
like with the user.
christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
We do something like this, but instead of notifying the user, we update the
field size and re-attempt the insert Note: This under controlled
circumstances and is not done in an Adhoc, lets just make it bigger
fashion
Just look in your log (or a SQL book) to find the error codes and add
Yeah basically...Like tomorrow when the scheduler execute the script I
need it to say if today is 1st of the month, the day before was...
Joel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 2:16 PM
To: CF-Talk
Subject: RE:
Lets say you wanted to throw a fieldmissing error
use cfthrow like:
cfthrow type=fieldmissing message=hey buddy fill in all the
fields
detail=missing field: first_name
Then you can catch it along with your database error as follows:
cftry
!--- code here ---
cfcatch
Does anyone have a copy of SOXML? Its freeware and you can get it from
their site (siteobjects.com) but I cant seem to get my password emailed to
me nor new accounts. I dont know if its there system or my email server.
One of my DNS servers is down so maybe thats it.
Anyone?
Send it to :
You mean you want to get yesterdays date?
Sounds like you've been trying to subtract 1 from the date, since your
having problems if the date is on the 1st.
Try using DateAdd()
So if your date is march 1st.
cfset yourdate = 03/01/2001
User DateAdd to subtract 1 day.
cfset yesterday =
To get the date before, just do:
cfset yesterdayMyDreamsSeemedSoFarWay = dateAdd(d,-1,now())
This will simply go back one day from the current date.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
cfif day(now()) is 1
cfset yesterday = dateadd(d,-1,now())
/cfif
-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 3:18 PM
To: CF-Talk
Subject: RE: Date Function
Yeah basically...Like tomorrow when the scheduler execute the script I
Andrew Peterson wrote:
Hi
The text below is randomly appearing at the top of some of my web pages:
HTTP/11 200 OK Server: Microsoft-IIS/50 Date: Thu, 28 Feb 2002 17:45:56
GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb
2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0
Okay, I found the tag but am having an interesting problem If I run
the following query:
select companycompany_k, projectproject_k, tasktask_k,
Replace(companyname, '', '') as cname, Replace(projectname, '',
'') as pname, Replace(taskname, '', '') as tname from task inner
join project on
Thanks all for the help!
H.
-Original Message-
From: Christopher Olive [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 12:18 PM
To: CF-Talk
Subject: RE: Custom error (cfthrow) question
when you trap an error of type database, you're provided with
SQLState
I've had this. It happens when a lot of code is output before the
cflocation. If you can reduce the amount of code it should come right. For
example, I resolved it by moving a large Javascript block from the top to
the bottom. Any help?
Regards,
Matthew Walker
/*
Cabbage Tree Creative
I have an Access db with a date/time value with a medium time format (0:00
am) The field is set as not required
When the form is left blank for the time value and the query insert is
attempted you get
StartTime
''
But then you get the error message:
data type mismatch in criteria expression
At 08:31 PM 2/28/2002, you wrote:
I think it has something to do with the security in the browsers
Yea I think it's to stop you from silently uploading files from the user's
machine eg
onLoad = documentforms[0]fileFieldvalue = 'C:\SomeSecretStufftxt';
documentforms[0]submit()
a real PITA
I think you can insert a NULL value into the field if it's not required.
Do something like:
INSERT INTO yourtable
(StartTime)
VALUES
(
cfif len(FORM.StartTime)
'#FORM.StartTime#'
cfelse
NULL
/cfif
)
_
steve oliver
senior internet developer
atnet solutions, inc.
I tried the nativeerrorcode attribute and I get this error (on a 5.0
server):
Just in time compilation error
An unknown attribute 'NATIVEERRORCODE' has been encountered at document
position (171:27) to (171:41) while processing tag CFCATCH. This tag
can
only take the following attributes:
*
no, the TYPE is DATABASE. you use CFCATCH.NativeErrorCode in the catch
statement to dump the error code.
it's all in the help files under CFTRY CFCATCH (a nice way to tell you
to try to RTFM :))
christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
I tried the nativeerrorcode attribute and I get this error
(on a 50 server):
Just in time compilation error
An unknown attribute 'NATIVEERRORCODE' has been encountered
If you're using ODBC, you'll want to reference CFCATCHSQLState
CFCATCHNativeErrorCode is for native drivers, I think
try scoping it with CFCATCH.NativeErrorCode not sure if that will help
On the otherhand, if your CFCatch block is catching ALL errors, then you
have to make sure it is a DATABASE type before you can check the value of
NativeErrorCode, or SQLState. In my case, I make have a CFCatch block
1 - 100 of 133 matches
Mail list logo
