I'm setting up a cferror template that collects the following info.
INSERT INTO Errors(HTTPReferrer, Diags, Query, Page)
VALUES ('#ERROR.HTTPReferer# ', '#Error.Diagnostics#', '#Error.QueryString#',
'#ERROR.Template#')
I'm getting a cf error saying that httpreferrer is undefined in error. Is
Thanks G.
IIRC HTTPReferer is a CGI variable as in CGI.HTTPReferer check the docs on
what vars error returns.
G!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I have a form which is throwing the following error upon submit:
Element NAME is undefined in FORM
The field is set to allow nulls in the database. Is there something else I
should be doing to allow a null value to be passed?
Thanks
. if you
want to insert a true NULL into the database, you'll need to do:
cfqueryparam value=#form.name# cfsqltype=cf_sql_char null=#not
len(trim(form.name))# /
On Thu, Dec 4, 2008 at 8:17 AM, John P [EMAIL PROTECTED] wrote
Hi,
I'm receiving the following error when attempting to import an .xls file.
[ODBC Excel Driver] The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data.
I've read that the data type is chosen by the ODBC driver based on the first 8
I suspect that there may be a problem with our ClientStorage_log database as
it's currently at 11.5 gigs and has to be cleared out once a month or so. I
freed 4.5 gigs of space on this server by moving files off 2 days ago and
within 24 hours that space was filled again. Could this be a
Thanks to both of you for the information.
John
I suspect that there may be a problem with our ClientStorage_log
database as it's currently
at 11.5 gigs and has to be cleared out once a month or so. I freed 4.
5 gigs of space on this
server by moving files off 2 days ago and within
Thanks to both of you for the information.
John
I suspect that there may be a problem with our ClientStorage_log
database as it's currently
at 11.5 gigs and has to be cleared out once a month or so. I freed 4.
5 gigs of space on this
server by moving files off 2 days ago and within
Hi,
I need to capture a url variable then add it to a redirect so my application
which is changing servers will still work.
Not sure where to start. Thanks, John
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Thank you all, that's exactly what I wanted to do.
cgi.query_string
cflocation URL=somewhere_else?#cgi.query_string# addtoken=no /
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Thank you both for your suggestions, this was helpful in understanding the
scopes of application.cfc.
John
Try setting application.urlBase in the OnApplicationStart section,
unless you really want this to be in the variables scope.
-Mike Chabot
Hi,
I'm interested in setting a base url in my application.cfc which I will be able
to reference from all .cfm pages.
I've tried it in onReqestStart and onApplicationStart and it doesn't seem to be
working, I get a variable base is undefined error.
cffunction name=onRequestStart
Hi,
I'm running the developer edition of CF8 with a MS2k5 SQL server and receiving
the following error on the index page. Other pages are loading using the same
datasource with out the error. The site was working fine yesterday. The
datasource shows connectivity from the cfide/administrator.
Thank you both for the info.
John
You need to add the data sources into each instance if you plan on
actually using them.
Unless you have a site using the default instance, you shouldn't need
any data sources set up there.
I may be wrong, but I seemed to remember if you added data sources
Our server admin has set up CF8 with 4 instances. When adding data sources I
have to add them to the root cfide/administrator rather than within the
instance example: http:mysite.com/:portNumber/cfide/administrator.
Seems like the install might be configured incorrectly, does anyone have any
Hi All,
I discovered something strange with flash cfform this morning. Some of the text
fields which are populated by the database are displaying the text in white
while others in black, the white text is invisible on the white background.
This issue appears to be related to MS Vista as I
I'm having a problem with a form which is giving the following error on insert
of text fields which contain a paragraph or two of data.
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be
truncated.
This error would seem to
Thanks for your help guys.
John
On SQL Server NVARCHAR can be up to 4000. Just do a Len() in the data to see
if it is as long as you think it is.
Adrian
Nvarchar only allows 255 characters. NText is the field you want if its
paragraphs you are storing.
Rick Eidson
The KChost Radio
Is it possible to change the text color via the cfform style attribute?
Have you tried using css to force the colour of the text?
Might be a workaround.
will
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Excellent, thank you all for the suggestions. It makes sense now. I think I'll
experiment with both methods just to learn the process. Sorry about the double
post of the question, I couldn't find my initial submission and thought it
didn't post.
As always you're very helpful, thanks!
Is it possible create a way using coldfusion which would allow the user to
change the current page style by selecting a link on the page?
Seems like it shouldn't be to difficult, I just can't think of how to do it.
Thanks,
John
Is there a way to allow the user to change the style sheet of a page using a
link on the page?
Thanks,
John
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
Hi,
Is it possible to remove a digit from a multi-digit number IE:
2007 would become 207?
Thanks,
John
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
I'd like to remove the 2nd Character (zero) from the left
Thanks to all for your help.
John
removeChars(2007, 2, 1)
You could start at index '3' in this case since both 2 and 3 are zeros.
cheers,
barneyb
~|
Download
I ended up using #RemoveChars(2007, 2, 1)#
Thanks!
Or you could do it with any of the other methods mentioned. There are a lot
of ways to do that.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
That worked, Thanks for your help
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648
Is there a way to reformat text in a text area to add quotation marks and
different line spacing?
So a comma separated list:
John, Tom, Frank, Bonnie, Jennifer, Richard, Sally
Would become this:
John, Frank
Bonnie, Jennifer
Richard, Sally
Thanks for your help, John
Hi all,
I've successfully implemented Ray Camden's rss.cfc to create a feed from my
query. I'm wondering if it is possible to get optional elements to display in
the feed, or do most feed readers only display the required elements; title,
link and description?
I'd like to show subject and
Hi all,
I've successfully implemented Ray Camden's rss.cfc to create a feed
from my query. I'm wondering if it is possible to get optional
elements to display in the feed, or do most feed readers only display
the required elements; title, link and description?
I'd like to show
Is there a tag I can use on my page to ignore an application.cfc in the root
directory?
Additionally, how many directories above the page being called will CF travel
to look for an application.cfc or .cfm file? Will it look keep going until it
reaches the server root directory?
Thanks!
Great, thanks Ben!
John,
Yep, all the way up. And to get it to ignore it, just add one in your own
folder.
--- Ben
-Original Message-
From: John P [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 12:29 PM
To: CF-Talk
Subject: Ignoring Application.cfc or .cfm
Is there a tag I
Hi,
Does anyone know of a custom tag which you can create an RSS feed from a
cfquery? I've attempted to use Tom Muck's but I get the follow error.
XML Parsing Error: xml declaration not at start of external entity
Location: http:///rssTest.cfm
Line Number 8, Column 1:?xml version=1.0 ?
^
, John P [EMAIL PROTECTED] wrote:
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com
=password
cfreturn GetIDS
/cffunction
But I am unable to output the new table data associated with the new column
names after I invoke the component.
Cfdump does work and displays the collumn names as DBADDRESS AS ADDRESS etc.
Any idea what I am doing wrong? Thanks.
On 5/15/07, John P
, John P [EMAIL PROTECTED] wrote:
- Hide quoted text -
- Show quoted text -
I am attempting to use cffunction to query a database and then cfset the
returned variables to a new names. I get the following error when attempting
to access the page.
Local variable givenname on line 19 must
returns column names from ldap not the variables I was
attempting to reset them to.
I'm confused. You're returning the LDAP query itself (via cfreturn getIDS).
where do those single variables (givenname, sn, mail, etc) that you're
explicitly setting come into play?
On 5/15/07, John P [EMAIL
I am attempting to use cffunction to query a database and then cfset the
returned variables to a new names. I get the following error when attempting to
access the page.
Local variable givenname on line 19 must be grouped at the top of the function
body.
Here's my function that appears on
Great, thanks Charlie.
you have to place your var scoped variables at the top of the function.
in this case, you'd do something like:
cfset var givenname = /
cfset var sn = /
cfset var mail = /
(etc)
above your cfldap call.
On 5/14/07, John P [EMAIL PROTECTED] wrote
Thanks all.
Carl, does cfparam as you described discretely tell CF and SQL that the insert
is a numerical data type? In what instances is that advised? Why is it
necessary?
I've isolated the issue to a server memory problem, I believe, and solved it (I
hope)
by restarting the server.
Thank
Unfortunately the failed inserts are random for different users, unique fields,
it's a pretty large application. I'd rather that it work correctly but I'll
take your suggestion into consideration worse case senario.
Could you:
cfif NOT Len(FORM.CUM_GPA)
cfmail to=blah type=html
What the
Hi All,
I'm maintaining a Coldfusion Application which is storing form data in an MSSQL
database.
We've recently received complaints from users that not all form data is being
inserted to the database. The issue appears to be random. I've tested 4 times
and found that only one of my fields
Coldfusion updates that were performed were 7.0.1 and 7.0.2
I'm researching but does anyone know if these updates affected session
variables?
Thx
John
Hi All,
I'm maintaining a Coldfusion Application which is storing form data in
an MSSQL database.
We've recently received
is not being inserted for me, however other users have had different
data that is lost. This variable is NOT being stored as a session variable.
Thx John
can you post the form code, insert code, and variable values that did
not insert properly?
On 4/18/07, John P [EMAIL PROTECTED] wrote
expect) is being passed?
also... you're just inserting a single record? not trying to update a
particular existing record?
On 4/18/07, John P [EMAIL PROTECTED] wrote:
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time
which might be a cause.
Thx
John
and you're not getting any errors? the other values in the statement
are inserting fine but you get an empty field for CUM_GPA?
On 4/18/07, John P [EMAIL PROTECTED] wrote:
~|
ColdFusion MX7
45 matches
Mail list logo