Courtney, I don't want to do a search.
I want to do a sort.
The sort in a numeric way over a varchar field is possible with this Tag.
But I will try what you supposed on taking QueryAddColumn()
Thanks.
Uwe
- Original Message -
From: "Courtney Payne" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
Peter, thank you.
This is probably it. I was thinking this is the reason for the error as
well.
I probably have to add another column additionally to the housenumber field
which is
taking the additions like "A" or "B" or "-" so that the values in the field
itself stay as numeric/text values.
Uwe
Kwang, Thank you for the quick reply!
I would like to follow your advice but I don't know howI had the
same error without the CreateODBCDate conversion tag and can find no
docs on OLE date formats. Should I not be using CreateDate?
..
You are using ODBC date formats for OLE DB, which
Apologies to Mr. Suh who did indeed answer the question by stating
'You must use the native DB syntax for dates...' So I am using Excel
which I think is using the Jet driver and looked at my MySql book and
simply wrote the date as the Date data type specified and ignored the
CF tag. (
Ok, I created this little form page that helps people generate a
professional ebay auction page. As you can see the only way they can get the
html code right now is to use the internet explorer source button. I have
asked this same question a couple of day ago and still haven't figured it
out.
Hi Rich,
Why not have a textarea that has the HTML code in it
display on the result page. Then people can just copy
and paste it right out of the textarea.
I am not sure how you're backend code is working right
now, but in order for this to work, you may need to
write the resulting page to a
To expand on that, you can also have a "Select All" button next to the text
area that selects the code for the user so that all they have to do is copy
it. Something like:
function selectAll(){
document.forms[0].ebaybidarea.focus();
document.forms[0].ebaybidarea.select();
}
then in the button
This is exactly what i would like to do but I don't know how. Since the
results page is created by cold fusion, I don't have a hard copy of the html
until it is generated. So, I don't know how I can take the entire html code
that is generated and change it into the text area box that you
Sorry. . .do it something like this:
CFHEADER NAME="Content-Disposition" VALUE="inline"
CFCONTENT TYPE="text/html"
textarea cols="60" rows="5" name="ebaybidarea"
-- put your CFM page code right here ---
/textarea
tom
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk"
OK that works great. I just had to double output the entire page so the 1st
output would show up as the actual page and the second will show up in the
text box. Now how do i add the select all button?
thanks for the help,
Rich
-Original Message-
From: Tom Muck [mailto:[EMAIL
script language="JavaScript"
!--
function selectAll(){
document.forms[0].ebaybidarea.focus();
document.forms[0].ebaybidarea.select();
}
//--
/script
then in the button :
INPUT name=Button1 onclick=selectAll() type=button value="Select all"
tom
- Original Message -
From: "ibtoad"
by the way, if you have Outlook express, those slashes always come thru with
a "file:" in front, but that shouldn't be there.
tom
- Original Message -
From: "Tom Muck" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:58 PM
Subject: Re: HTML problem
I'm in the process of moving my databases from Access 2000 to SQL Server 7.
I've got SQL running on a different machine than my web/CF server, and I
upsized my Access databases to SQL successfully. I also added a System DSN
via the ODBC control panel and connected successfully to the datasource.
Perfect!! Check it out:
http://www.cfm-resources.com/h/happytoad/
Thank you so much for the help. It's greatly appreciated.
Rich
-Original Message-
From: Tom Muck [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 1:15 PM
To: CF-Talk
Subject: Re: HTML problem still here...
Good job. I like it. . .
tom
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 1:42 PM
Subject: RE: HTML problem still here...
Perfect!! Check it out:
Yes, if you specify a valid SQL Server logon and password (i.e., one that is
setup within SQL Server) in the CF Administrator (under the CF Settings
area), it shouldn't matter which account the CF Server is running under.
Bob
-Original Message-
From: John Fix 3rd [mailto:[EMAIL
Just to add, I've thought about using the app as a custom tag. What are
some thoughts building on doing that? Directory structure? What files are
used in the custom tag and which aren't?
Brad
-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28,
I'm using cfcontent to trigger the upload of a file. Does anyone remember
the trick to faking cfcontent into using a file name other the name of the
template it is located in?
TIA,
Duane
Archives:
It's:
CFHEADER NAME="Content-Disposition" VALUE="inline; Filename=#myfilename#"
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 12:29 PM
To: CF-Talk
Subject: cfcontent
I'm using cfcontent to trigger the upload of a file. Does
OK, got it. I added a specific web server account to SQL Server config and
then entered that info into the CF Admin page and it verifies properly.
Thanks!
John
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 3:02 PM
To: CF-Talk
This is mainly to Michael D, but I thought some other feedback from others
might help with the issue...
I don't know about the rest of you, but I get (slighly) annoyed with the
messages with no subject - especially when there are several in a day, and
the replies are all "Re:" in the subject
I think it would be a good addition to the list.
I also like the feature of putting the name of the user group in the subject
line. Another group I belong to does this. For example, put [CF-Talk] at
the beginning of the subject of all messages. This helps sorting CF e-mails
from others.
I tried that but it didn't work. I thought there was/is something that can
be done to the url to fix this.
In file one I have
a href="getfile.cfm?filename=something.ext"GetFile/a
in getfile.cfm:
cfcontent type=""
file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
"Use filters Luke..."
At 05:33 PM 10/28/00 -0400, Chad Elley wrote:
I think it would be a good addition to the list.
I also like the feature of putting the name of the user group in the subject
line. Another group I belong to does this. For example, put [CF-Talk] at
the beginning of the
I also like the feature of putting the name of the user group in
--snip--
This is mainly to Michael D, but I thought some other feedback
--snip--
"Use filters Luke..."
No, use CF-Community.
Please.
-Cameron
Cameron Childress
ElliptIQ Inc.
p. 770.460.7277.232
f.
Duane, the complete code in getfile.cfm should be:
cfheader name="Content-Disposition"
value="inline; Filename=#url.filename#"
cfcontent type=""
file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
deletefile="No"
This trick only works in the browser when trying to
Dear List,
I have been working on a project on my home computer. I uploaded it to the
web today and am now experiencing strange behavior. Session variables that
are working fine at home just do not work on the web. I imagine it is a CF
Server setting, but could not get in touch with the hosting
How exactly is this tag supposed to work. I am trying to set up a site with
friendly urls but am having problems getting it to work right. I am not
using fusebox but would like an example as to how this works.
Bob Everland
Make sure you've got the latest formurl2attributes tag from fusebox.org
All you have to do use forward slashes in your url's:
index.cfm/action/viewproduct/productid/123
instead of:
index.cfm?action=viewproductproductid=123
You probably will want to use the fusetoken tag also. That allows you
Why not try something like this instead?
cfid/#session.cfid#/cftoken/#session.cftoken#.htm ?
-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 8:55 PM
To: CF-Talk
Subject: RE: FormURL2Attributes
Make sure you've got the latest
This was attempted and shot down really fast. You'll notice that the TO
field for the list is always CF-Talk. That was placed in for filtering
purposes and it really doesn't matter how the post got here, it'll always
show that.
I think it would be a good addition to the list.
I also like the
At the moment it can't be done with the software we're running. On the other
hand, work has already been started on altering the way the list is worked
and that can be added as a feature. Other features include automatic
cleanups of 'extra' post footers. I know its been a slow thing, but there's
Sorry, that was supposed to be to the original poster, not to the list.
As long as it was, I may as well mention that if your going away and have an
automated response running, either turn it off or unsubscribe from the
lists. If not, I'll try and do it for you so that posters do not get the
If you are a Dreamweaver guy like me, Ultradev is wonderful. It is not any
good for developing templates, but it's great for getting a visual on what
your code looks like, and it wont mangle your code.
jon
- Original Message -
From: "Matt Fuller" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
For some odd reason when I write this little cfif statement in dreamweaver,
it turns our fine, but if i were to open the file in Ultra Dev, it really
messes it up badtry it
cfif IsDefined('action') AND action IS "sendemail"
Kevin
~~~
Kevin Mansel
Web
I think it is :
CREATE TABLE yourtable
(
TableID INTEGER NOT NULL PRIMARY KEY
)
-Kev
~~~
Kevin Mansel
Web Developer / Cold Fusion Programming
http://www.kevinmansel.com
[EMAIL PROTECTED]
Phone : 206-286-6310
Cell : 425-346-7221
- Original
just set the field to field type identity
jon
- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
[EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 11:50 PM
Subject: New To Sql From Access
How do I set up sql field names to be equivalent
37 matches
Mail list logo