Hi,
I know it's late but I have a newbie question for anyone awake.
I am trying to make a text link that would sort records from a query. I
would like to pass the parameter through the URL that says which column
to sort by but can't figure out how. This brings up another question, am
I
SELF-SERVING PLUG
I did a generator that I built into a $$$ app I wrote called
ContentMonger Pro. Isn't dedicated to forms generation, but is a
feature of the system. Supports
text, checkbox, select, textarea, radio and hidden form fields.
Processes submitted form data as well as allowing
In my experience Access via ODBC to CF does not support the DEFAULT
clause in CREATE or ALTER table statements. Don't know about an OLEDB
connection (I do know OLEDB to Access creates a whole new set of probs
eg ODBC date time formats are not supported).
Joseph Thompson wrote:
I can't
CFX_IMAGE does simple graphs
Rick Osborne [Mojo] wrote:
Ron Anderson asked:
Has anyone reached the point of frustration with CFGraph,
where they've just built their own?
I did, but I did it in Perl with the GD module.
http://www.rickosborne.org/-- Look at the Insomniograph
Hi there,
I have a weird task to solve. I hope someone of you guys out there can
gimme a hint.
For a redesign of a customers site I have to replace links in
source-code of the original pages to fit into the redesign. The
problem is that those original sites (and their source) are messed up
like
Try
new = ReReplaceNoCase(old, 'a href=([a-z0-9])', 'a href=../\1',
'all');
HTH
Dick
At 12:32 PM +0100 1/12/02, SID - ColdFusion wrote:
Hi there,
I have a weird task to solve. I hope someone of you guys out there can
gimme a hint.
For a redesign of a customers site I have to replace
No workie :(
Neil
- Original Message -
From: Don Vawter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 9:52 PM
Subject: Re: Times...
it is a stored function not a stored procedure
should work ins sql 7
- Original Message -
From: Neil H.
On 1/12/02, Jim Vosika penned:
Hi,
I know it's late but I have a newbie question for anyone awake.
I am trying to make a text link that would sort records from a query. I
would like to pass the parameter through the URL that says which column
to sort by but can't figure out how. This
Hello all,
Apologies in advance for the OT message. I'm in a small bind.
SQL Server 2k on a shared host.
My hosted DB's allowed disk space is full and I need to add an index
('primary filegroup is full'). I've backed up and truncated the transaction
log and have a complete copy of the DB in
Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.
Michael T. Tangorre
Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave :-)
AIM: CrazyFlash4
Check out http://www.dbactive.com. The front page has a number of zip code
related custom tags.
[disclaimer: it's my site and my tags. The site blows, but the tags work
very well - cf_grin]
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Saturday,
Hey - Michael - I read your message wrong. If all you need is the distance
between two zips you can have that tag for free. It won't do the radius
calcs (all zips within x miles of a given zip).
Sorry for the confusion!
cf_need_coffee strength=strong style=black
-Original Message-
Can you actually create print quality PDF's using ActivePDF? I'd love to
make some dynamic reports to use as brochures, etc, containing real-time
data from some of our apps.
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 2:41 PM
To:
I have stored procs and functions in SQL Server 2000 for that. Contact me
off list if you can use them
They won't work in SQL 7
- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 9:14 AM
Subject: CF and Zip
Basically what I am doing to clarify things is the following:
I wanna be able to search for stores in my database and get the stores
within x number of miles from the visitors enetered zip code..
Does this make more sense..sorry for the confusion... I pulled an all
nighter :-)
-Original
Yes.. Look at the following. Have used it for a long time.
http://www.dbactive.com/tags/zipraddoc.htm
You'll need to get the ziprad database from here: http://www.jcsm.com/
Lee
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Saturday,
That's what the CF_ZipRad tag is made to do. It uses the zip code database
provided by Bud Jay at http://www.jcsm.com, but can be modifed to work with
any zip code DB containing lat and long coordinates. Bud's DB is the lowest
cost, most complete one I've ever found, and I'm always looking :-)
This is something we use for searching for service centers within a
certain radius. Hope it helps.
CFPARAM NAME=form.distance DEFAULT=50
CFQUERY NAME=geoCode DATASOURCE=#request.site.dsn#
SELECT latitude,longitude
FROM geocode
WHERE zipCode = '#form.zipCode#'
/cfquery
CFIF geoCode.recordCount
Bud,
Thank you so much for taking that much time to explain it to me!
You have been VERY helpful!
Thanks!
Jim Vosika
(newbie)
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 12, 2002 8:53 AM
To: CF-Talk
Subject: Re: Passing variables through a URL
Hi Dick,
I'll give it a try on monday.
Is the 'Backslash-1' an Placeholderholder?
Thanx a lot
Patric
mail: [EMAIL PROTECTED]
DA Try
DAnew = ReReplaceNoCase(old, 'a href=([a-z0-9])', 'a href=../\1',
DA 'all');
DA HTH
DA Dick
It is a backreference to remembered text (enclosed in parens) in the
first term (you can have up to 9 such items \1, \2... corresponding
to 9 sets of parens
So:
'a href=([a-z0-9])', 'a href=../\1' =
||
So do you think it would also work in the Extended-Search/Replace-Menu
in Studio or do I have to write a little cfm for that?
Patric Stumpe
mail: [EMAIL PROTECTED]
DA It is a backreference to remembered text (enclosed in parens) in the
DA first term (you can have up to 9 such items \1, \2...
Has anyone done anything with EDI using CF?
More specifically handling inbound/outbound EDI data mapping from a VAN
such as GEIS, Sterling, ATT, etc.
Jeff Craig
__
Why Share?
Dedicated Win 2000 Server ยท PIII 800 / 256 MB
I don't know... I don't use studio...
If studio supports back references then you are good!
Its my understanding that most program editors support grep (and back
references), so I would be surprised if studio doesn't.
I use BBEdit on the Mac and it supports them.
Dick
At 7:47 PM +0100
Well... :)
I'll try the Studio feature. Nothing can't go wrong. But nevertheless
fine to get some help from a Mac-User :))
But I'll mention here if it worked, when I'm back to work again!
Patric Stumpe
mail: [EMAIL PROTECTED]
DA I don't know... I don't use studio...
DA If studio supports
Hello again list.
Here is what I am wanting to do I need to be able to count the number of
files in a particular directory. I am using CFDirectory to find and list
the files, the problem I am having is counting them. I need to do this
so that I can wrap these files into a dynamic table and
The cfdirectory function returns a query...so, you can use the recordcount. Here's an
example:
cfdirectory action=list name=mylist directory=c:\ filter=*.*
cfoutput#mylist.recordcount#/cfoutput
HTH,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
Thanks. That was it.
- Original Message -
From: Howie Hamlin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 2:31 PM
Subject: Re: CFDirectory and and Forms
The cfdirectory function returns a query...so, you can use the
recordcount. Here's an example:
Anybody out there have any luck with CFPOP? I'm playing
around with trying to build a webmail app just for the
experience ... I keep getting a CF error:
Connection Failure
The error occurred while processing an element with a
general identifier of (CFPOP),
Here's the tag it craps out on:
OK,
I have another question about CFDirectory. When I output the names of
the files, I am seeing three things that are not right. The first file
is a period, and the next one is two periods. I am also seeing a file
called Thumbs.db. Is this normal?
Thanks
OK, I know what thumbs.db is. It is only in files where there are or were
images. It is associated with Windows Xp. XP has the ability to show images
as thumb nails and film strips. I still do not know why the two periods are
there though.
- Original Message -
From: Bruce Sorge [EMAIL
Ahh. Makes sense. So I will just have to account for that then. Thanks.
- Original Message -
From: Macarie Neculai [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 5:00 PM
Subject: RE: ANother CFDirectory question
Yes, this is normal. The first period
I got around the pointers using the following code you have to think
about the anticipated file naming conventions in regards to the test length.
cfif LEN(Trim(name)) LT 5nbsp;cfelse...show name.../cfif
Tony
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent:
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 1:12 AM
To: CF-Talk
Subject: RE: ANother CFDirectory question
I got around the pointers using the following code you have to think
about the anticipated file naming conventions in
Why not use the type instead, as it will say file or directory?
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 13 January 2002 10:12 AM
To: CF-Talk
Subject: RE: ANother CFDirectory question
I got around the pointers using the following code you have
I'm trying to have a CF template automatically upload a file to a client's
site, and I keep getting an error. I don't know what's wrong .. can
someone see please?
The error I'm getting is: The attribute FileOnServer must contain a
filename with a .htm or .html extension 500 Illegal PORT
Are you using a fully qualified path to designate the 'localfile'?
Jim
- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 4:57 PM
Subject: CFFTP help please .. whats wrong here?
I'm trying to have a CF template
Are you saying that the attribute localfile in the putfile tag should b
e
something like
localfile=C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.htm
l
rather than localfile=filetoupload.html?
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From:
Yes, if I recall correctly. If the file is in the same directory as the
template, you can use:
localfile=#ExpandPath('filetoupload.html')#
Jim
- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 5:18 PM
Subject: RE:
EDI, my condolences. When will xml be used with that. I used to parse EDI
orders/acks with perl and it was a nightmare. Anyway, what specifically
are you looking to do?
On Sat, 12 Jan 2002 [EMAIL PROTECTED] wrote:
Has anyone done anything with EDI using CF?
More specifically handling
Thanks, Jim. I did that but the problem didn't go away. I checked usin
g a
text output that the code you sent me does indeed yield the correct
directory and file, so that's correct, sure enough. But I guess that was
n't
the error. I still get an error in h1tags at the top of the page sayin
g
working on a silly file management piece... we want to take things like
deletes and creates and pop them up in a separate window... no big problem
there...
complete the form.. submit still in new pop-up... then when completed we
want it to auto-close the window, place the user back at the
Mike,
What version of CF Server is installed on server?
Thanks,
Dan Blickensderfer
- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 8:18 PM
Subject: RE: CFFTP help please .. whats wrong here?
Thanks, Jim. I did
in your submit form put the following:
html
body onLoad=opener.location.href='openerfile.cfm';
window.close()/body
/html
openerfile is the one you want to reload
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
I have CF5. The reason I have to do this is the client isn't on a CF hos
t,
so I have to generate static pages and upload them to their old fashioned
html host.
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Dan Blickensderfer [mailto:[EMAIL
Mike,
If I can recall correctly.
If you are using a form with an enctype=multipart/form-data and using that
variable as your remotefile. It usually
has a temp variable from windows. like this. C:\WINNT\ACF56.tmp
I usually force the extention on the remotefile. Here is an example of code
that
EDI, my condolences. When will xml be used with that. I used to parse EDI
orders/acks with perl and it was a nightmare. Anyway, what specifically
are you looking to do?
Alex,
Since this is a fairly involved subject, I'll take it off the list after
this. Just checking to see if anyone else here
Hi Everyone,
This is a bit off topic, but if anyone is still up I could use some
guideance.
I have a query that returns a value in minutes. What I need to do is setup a
counter that counts down
The minutes then sends a user to another page after so long...
Any ideas?
Michael T. Tangorre
doesn't seem to work with cf-oledb either...in fact, i couldn't even get
it to work in an asp-ado environment...
- Original Message -
From: Richard Meredith-Hardy
To: CF-Talk
Sent: Friday, January 11, 2002 11:41 AM
Subject: Re: hair-tearing Jet SQL problem!
In my
Can you use stored functions in SQL 7. From what I can see it doesn't like
that format (or something!)
Thanks,
Neil
- Original Message -
From: Don Vawter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 9:52 PM
Subject: Re: Times...
it is a stored
Macromedia have transferred the ColdFusion gallery over to their domain.
Check it out at:
Peter Tilbrook
ColdFusion Applications Developer
2/13 Murrung Crescent
Ngunnawal ACT 2913
AUSTRALIA
All that is gold does not glitter,
Not all those who wander are lost;
The old that is strong does not
good luck...
went and tried it a few hours ago... datasource errors and a host of other
things...
way to go :)
well give them a few days I suppose...
-p
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 01:45
To: CF-Talk
Subject:
Tried it on my SQL 2k box and it took the function. Now I just need to move
the data :)
Neil
- Original Message -
From: Neil H. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, January 13, 2002 1:35 AM
Subject: Re: Times...
Can you use stored functions in SQL 7. From
53 matches
Mail list logo