erm...
Having looked at dwmx, there is such a thing under commands but it's
grayed out...
Paul
- Original Message -
From: Adrian Lynch [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 4:35 PM
Subject: RE: Feature request: macro recorder
would you bite my
go and download the cf5 help files upgrade from the macromedia website.
Very helpful.
Paul
-Original Message-
From: Norman Elton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 15 June 2001 11:19
Subject: RE: Reference on Cold Fusion 5
I believe there's a great run-down in the
If the registry starts to get clogged, just store the data in a database
instead. This is set from CF Administrator.
Never use the registry with client variables. Always set up client
variables to work with a database. Just makes sense.
Paul
Custom tags will work if they are in the same directory as the file.
So two files a.cfm and b.cfm in same dir and you can call cf_a in b.cfm
(and vice versa if needs be).
Also, you can create your own custom tags folder in the web root somewhere,
and you can call it via cfmodule template=a.cfm
I am not sure if what you want is something to stop CF being brought down
(ie crashing) or it just returning errors. If it's just errors, try this:
cftry
cfcatch type=database
... do whatever you want in here ...
/cfcatch
/cftry
Otherwise, check your Oracle and CF installs...
Paul
wouldn't sorting them using the bitwise functions make more sense on this
one?
They are binary after all.
Paul
PS Otherwise, just recreate the ip address with leading zeros, then sort
them as text and it may well sort out the problem e.g.:
216.56.6.245- 216.056.006.245
216.66.132.134 -
Try running this code from CF (obviously):
---code---
cfset iplist =
216.56.6.245,216.66.132.134,24.16.140.8,24.165.85.118,24.178.211.39
cfset newiplist =
cfset num = 1
cfloop list=#iplist# index=addr
cfset newip =
cfloop list=#addr# index=part delimiters=.
I have to agree that you need to post some code.
Are you sure that the cookies are not getting deleted by a logout thing (if
that's what it's about) or that they aren't getting re-written every request
by something called int he application.cfm or equivalent...
You have to check the entire page
If you're using ASP, why not use the MSXML object directly?
Have a look at CF_SOXML and reverse engineer (it's really not that hard!).
I hope you are successful.
Paul
-Original Message-
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 03 June 2001 14:10
Anyone,
I have come up with a slight issue in the past, and it is this:
If you are using client variables for a secure section of a website and they
have a timeout (say 10 minutes). The users closes the browser thinking that
they have logged out (when they haven't) and the cookies (let's assume
how about a regular expression?
cfif REFind(192[.]168[.]5[.][12]?[0-9]?[0-9], cgi.remote_addr)
/cfif
or something like that!
Paul
-Original Message-
From: Marcus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 01 June 2001 16:14
Subject: Brain isn't working yet...
I'm trying to
is reached.
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 16:02
To: CF-Talk
Subject: session and client variables
Anyone,
I have come up with a slight issue in the past, and it is this:
If you are using client variables for a secure section
!
Enjoy
Paul
;-)
-Original Message-
From: Paul Johnston [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 01 June 2001 16:54
Subject: Re: Brain isn't working yet...
how about a regular expression?
cfif REFind(192[.]168[.]5[.][12]?[0-9]?[0-9], cgi.remote_addr)
/cfif
or something like
I did notice that there was a cf_hiermenus tag just uploaded to the
developers exchange.
Paul
-Original Message-
From: C Frederic Valone [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 30 May 2001 12:50
Subject: Re: dhtml menu
Try Hiermenus http://www.webreference.com/dhtml/ If
The best database to use on Solaris (after Oracle) is Sybase, but failing
that there are several different databases that work on **nix systems that
are worth a look. Probably the best two to evaluate are Postgres and MySQL
(both sort of free without support).
However, this is more a
A couple of things...
* Are you sure that the access denied is not the HTTP call on the
webserver?
Check the the CFHTTP call is working from the page before trying to write
to the file...
* Are you sure that CFFIle can do a write to that directory?
Again check from a dummy page...
If this
using a ^ says not one of these and using [] says group these together
how about saying if you find something that is not a number or a letter:
cfif REFindNoCase('^[A-Z0-9]', variable)
ERROR
cfelse
do processing
/cfif
what you said is:
find 0 or more alpha chars and 0 or more digits next to
in javascript (style). Has anyone else done stuff like
this?
Paul
Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
CV: http://pjnetsolutions.cfdeveloper.co.uk/cv/
- Original Message -
From: "Dave Watts" [EMAIL PROTECTED]
To
not an authority on XML and all views expressed are my own. Please
listen to other people too!
Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROT
Note: CFX_secFile (basically same thing) has no limit beyond your current
virtual memory.
Thanks!
But it doesn't help if you're on a shared server and the ISP allow you to
use CFX_File though!
Paul
~~
Structure your ColdFusion code with
entered is not an option because they could upload several
hundred at a time!).
Anyone?
Paul
Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
~~
Structure your ColdFusion code with Fusebox. Get
once (and it's a lot easier on ColdFusion too!).
I hope this makes sense!
Paul
Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
- Original Message -
From: "Jones, Becky" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: T
nk of anything
else then please tell me. If you know of any problems, then let me know!
Paul
Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
~~
Structure your ColdFusion code with Fuseb
tartstop cf services?
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:46 AM
To: CF-Talk
Subject: CFX_File problem
Anyone?
Am using CFX_File downloaded from the allaire developers exchange and
can't
seem to get it to work! It just returns a
e
username="test"
password="test"
action="copy"
source="C:\inetpub\wwwroot\index.cfm"
destination="C:\inetpub\wwwroot\index_copy.cfm"
Win2k Pro, CF Pro 4.5.1 SP2
Anyone? Am I missing something in Win2k or is it the tag?
Paul
--
There are various messages in the archives relating to this. Have a search
and it will tell you.
It's a common problem that for the life of me I can't remember what the
solution is.
Paul
-Original Message-
From: James Birchler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January
Thats very interesting, because doing a view source indicates
that they are
using CF:-)
I mean how many other scripting languages generate that much
whitespace!
Erm...
Loads of languages generate that much whitespace!
Which
Let's not forget that all WDDX is, is an XML packet. If you want to do
something funky with it, just treat it as XML and use the numerous XML
COM/Java/CORBA/man/and/his/dog type objects that are available.
After all, that's all Allaire do, and they haven't dropped support for it.
It's used
Thats very interesting, because doing a view source indicates
that they are
using CF:-)
I mean how many other scripting languages generate that much whitespace!
Erm...
Loads of languages generate that much whitespace!
Paul
~~
Erm...
CF on Linux - use James Clarks Expat Parser for XML.
There isn't currently a simple CF interface for this though (one day...)
There is a simple Perl interface, and since you're on Linux, pass the
processing to something that can handle it. My best guess would be Perl.
The reason is
Adding to my previous post (if you can understand the code) here is my idea
of what you should do. Just cut and paste it into a cfm file and run it.
Paul
-code-
cfset myStruct = StructNew()
cfset myStruct.blah = "This is fun isn't it!"
cfwddx action="CFML2WDDX"
To be honest, all I want from an IDE to write code on is the tag/function
completion. If someone wants to build this into jedit (or is it already
there?) then I would use it. What would be even more useful would be the
ability to add in my own tags/functions etc for future use.
That way you
I have a project set up that contains a whole website to go onto a shared
server.
However, I cannot create a script to upload that project to the correct
directory, because I do not have FTP access, only RDS access to the server.
What I am confused about, is how it knows where to put the
It can be done! You can bypass the case-insensitivity, although it's a bit
long winded (but it works).
What you need to do is use the ASCII character number to make a string case
sensitive (ie convert it into ASCII characters and test against those!).
there are two functions, ASCII and CHAR.
The strength of this merger is in database driven application
development.
Macromedia bought Drumbeat, which was very ASP oriented, and
has now been
absorbed into UltraDev. If we can end up with a product for
CF/JRun, which does
everything from Studio to UltraDev - that
Guys,
I need a cross browser DHTML menu asap that can do drop down, and slide
menus.
Menu
|-Item1
|-Item2
|-Item3--|-Item5
|-Item4 |-Item6
Does anyone know of a good simple API or generator, that has been tested
(the important part of the question) on NN4+ and IE4+, that they would
recommend?
Both correct, but...
There is such a thing as CSS. If you think about it, the most useful thing
about HTML is that some of the attributes are defaulted on the client
machine. Bear this in mind, and you could easily create a form.
BTW a form generator is something that takes some data and
There is such a thing as ActiveScript in Studio so that you can build little
code things to do whatever you want. It's not hugely functional but you can
pull in COM objects to do whatever you want.
I wrote some ActiveScript to put documentation into pages that didn't have
any. Click a button,
Lets put it this way.
I have been doing web development work since coming out of the University of
Bath (for all you Americans, it's an old Roman City in England that has
Roman Bath's in it hence the name) not too many years ago.
Since then I have done HTML then Perl, then CF. As far as I'm
We do have one reason for not using session vars.
Clustering.
It takes out the need to worry about the variables being held in memory.
Paul
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 07, 2001 7:57 AM
To: CF-Talk
Subject: RE: deleting session
that and modify
it. Programmers who are keen to build programmes from the ground up all the
time waste huge amounts of time (IMHO) however, it can be very useful in the
long run.
Adam
-Original Message-
From: Paul Johnston [SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 08
It has to be said, that if you want to get into XML, go and have a look at
the Siteobjects tags
http://www.siteobjects.com
It's an excellent starting point.
Paul
-Original Message-
From: Gilles Ratté [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 3:54 PM
To: CF-Talk
Well, I am enjoying reading your responses. It's very good to get some kind
of feedback (I'll have a look at databaseblocks but I haven't a clue what it
is!).
The thing I am working on now is to use the database to hold certain
information, and to let HTML default as much as possible. So
Erm, has anyone noticed who isn't certified? It's much more fun than
looking at people that are!
Paul
PS I don't think we should necessarily post their names here though...
should we?
PPS I know I'm not certified! I haven't had the time yet!
-Original Message-
From: Scott Wolf
as possible to be
defined by Style Sheets to make the forms customizable.
At 12:30 PM 1/4/01 +, Paul Johnston wrote:
Well, I am enjoying reading your responses. It's very good to get some
kind
of feedback (I'll have a look at databaseblocks but I haven't a clue what
it
is!).
The thing I am working
I have just started working on a spectra client site, that has been written
using session variables in several major places. Unfortunately this is to
be a clustered site, so we need to move to client variables. The actual
changing of the code is fine (ie session. to client.) but there are still
This may sound a little bit odd, but I am surprised that I can't find such a
tool.
At the moment I am in development of a custom tag that will take a CF
structure, and create a form from it. Nothing new, except that I intend to
give the user control of the output to as great an extent as
Guys,
We have a SQL Server 7 implementation with three CF servers using it as a
database server.
The problem is that it's falling over regularly (and the technical guys
can't figure it out).
That's not the problem though. We are now setting up a second SQL Server 7
for use as a failover. It
I am sure there is a way that has been talked about, but the way I would do
it (off the top of my head) is to use javascript to output a message box
just before (30 seconds say) the session expires (nothing back to the
server) saying "Your session is about to expire. Continue?" that when
clicked
Yes it would be useful to know a bit of Java, but I would not go as far to
say beneficial. What Jeremy Allaire said in his speech to the UKCFUG last
week is that we (CF programmers) will not need to know Java to use Neo (the
Java based CF server as opposed to CF5 which will still be CF based).
cf_rant
I still come back to my point (see the summary).
CF is not the correct tool to build a spider. It's oriented for web
applications and effectively parsing and inserting HTML/WAP/A.N.other text
(although CF5 will probably change all that). For spiders, using it for
anything other than a
go and have a look at the tag gallery. There's a new custom tag to help
connect mysql database to CF.
Search on mysql.
Paul
-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: 06 December 2000 11:42
To: CF-Talk
Subject: RE: OT: MYSQL
Anybody have
Doug,
WDDX does not answer the question.
What you want to use is CFCONTENT. example:
cfcontent type="text/xml"?xml version="1.0"?
html
head
titleThis is a title/title
/head
body
h1Hello/h1
/body
/html
Paul
-Original Message-
From: Doug Powell
Had this conversation several times on the cf-server list.
FYI
You can put CF on an Intel/AMD based machine, but not a MIPS based machine
(ie not a cube).
Therefore Cobalt RaQ's are possible CF hosts (and there are some good RaQ
hosting services out there)!
Paul
-Original Message-
How about storing the cfhttp.filecontent variable in a database (which you
can cache the query on) or in a server variable or something? Then you can
just overwrite it whenever you want and it's always there!
Paul
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
I have to agree completely. Using CF as a spider is really not very
sensible. If I was suggesting a way to do this, I would use cfexecute
with some program that can dump results to a text file which CF can then
use.
There is no point in using up CF's resources on something it's not really
Does anybody know how I can I have two CF Studio Windows open at the same
time? I'd love to take advantage of my duel monitor setup. Thanks!
so is it guns or swords? ;-)
Paul
PS I don't know how to have two up! Would be nice to be able to split
screens over two files though!
Has anyone noticed that when downloading netscape from IE (I know it seems a
bit wierd), it says:
-
You are currently using
Internet Explorer 5.5
There is an upgrade available
Netscape 6
Download Now
-
Hmm...
Paul
-Original
Of course, you could always write a frameset that calls in the relevant page
(just like a load of companies do - mp3.com is an example).
This would mean you could send both a frames and a non-frames version and a
link at the top for those with just text based email readers!
Just my two
Nice! I like it!
Anyway, if you want a zip file with some basic (and I mean simple) examples
of XML and XSL with speed testing then you can download them (if you're
lucky) from:
http://www.cfm-resources.com/c/cfdoc/downloads/xslstuff.zip
These again use MSXMLDOM object. Please use them how
Okay, probably the easiest thing would be to use a frame of some sort.
Either that, or use a javascript pop-up window to say "stuff's happening,
hang on!" when the user goes to the page (not when they get there!)
Maybe that's easiest, because you can give them something to do while they
are
I certainly agree that you'll find it's what most people are using.
As to "everything else is inferior" the only things I find useful about CF
Studio are the Help Files and the Tag/Function Completion.
It crashes quite a bit and is not perfect. If there was a different, more
stable editor out
: "Paul Johnston" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 09, 2000 11:09 PM
Subject: RE: CF editing software - vote
I certainly agree that you'll find it's what most people are using.
As to "everything else is inferior"
Jake,
I would suggest using javascript to encrypt the pw string if you HAVE to
pass it through the URL string (I am assuming here that it has been inputted
in a text field and it can't be passed any other way). If you are only
going to store the variable and don't need to know what the string
Okay. I use IE. It has something called "inline autocomplete" for web
addresses.
Lets say someone else uses my machine. They could type in "http://www." and
get all the urls beginning with "www." and then put in "a" then "b" then "c"
etc... and at some point they would be able to see a url
IE (to try and be clever) looks for a file called favicon.ico in the same
directory as the page being browsed IF the user bookmarks that page. If
they don't it won't search for the file.
Just as an example in IE go to http://www.google.com and bookmark it. Then
refresh the page. This will
How about storing some of the information using a one way hash (ie MD5)?
This can't be unencoded (or at least, it's pointless to try). This encrypts
a string the same way each time, so if you have a password, you can put the
same one in, and you always get the same result.
The problem is that
This is not a secure solution (which is what I assume you are after). What
is to stop someone malicious getting/intercepting the email? Sending a
username and password over email is a hackers dream!
You cannot pass any variables to anyone except the cold fusion server.
There has to be some
There are many ways to do it. There are custom tags to do it. Just to show
how easy it is, here is a random password generator you can do what you want
with:
watch for the text wrapping! The textstring is one line. You can make this a
custom tag if you want.
-CF Code-
I have done a presentation to the UK CFUG on "Documentation in Cold Fusion"
which describes some issues around documenting code (specifically), but
people have said that it's useful for project management issues and the
like.
If you want to take a look, check these links out (copy of message
Neither does mine! And please note I commented it, so it looks long but is
actually only a few lines!
Paul
-Original Message-
From: Jeff Bevill [mailto:[EMAIL PROTECTED]]
Sent: 27 October 2000 09:32
To: CF-Talk
Subject: RE: Capitalize First Letter of Each Word
Rich,
My "over
bear in mind that no cfcode within script/script tags will get
processed.
To get round this, put the code into a page, and then cfinclude the code
in between to script/script tags:
script
cfinclude template="mytemplate.cfm"
/script
script
cf_mytemplate
/script
Enjoy
Paul
!
Thanks
Paul
-Original Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2000 13:25
To: CF-Talk
Subject: Re: Custom Tag w/JS functions
on 10/26/00 10:15 PM, Paul Johnston at [EMAIL PROTECTED] wrote:
bear in mind that no cfcode within script/script tags will get
You can't call custom tags from within CFSCRIPT which I think is utterly
stupid.
Call to Allaire:
Make a function called Tag() with this syntax:
Tag(tagname, attribute list);
ie
For
CFOBJECT TYPE="COM"
ACTION="action"
CLASS="program_ID"
NAME="text"
CONTEXT="context"
Oh, let me see...
Tough one...
Oh! Have you tried putting apostophes round the variable (it being a
varchar and all!)?
Paul
PS Expect about 20 more replies like this one!
-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2000 14:29
To: CF-Talk
Either that or...
--
!--- Sentence Capitaliser ---
!--- Paul Johnston ---
!--- to capitalise all words in a sentence ---
cfset Variable="YoUr UnBeLiEvAbLe"
cfoutputbr#Variable#/cfoutputbr
!--- put the sentence into an array (co
This isn't quite true.
Ensure that the MIME type is correct for sure, but also ensure that the file
returned is an XML file NOT just an XML packet ie:
?xml version="1.0"?
myxmldoc
textHello/text
/myxmldoc
instead of
myxmldoc
textHello/text
/myxmldoc
If there is no identifier,
I am interested to see whether anyone on the list has tried to put CF 4.5
for Linux on any RAQ server or not. Please see below for what Cobalt says
may be possible.
Paul
--
This comes from the Cobalt website. Quite interesting I
Just to let you all know, I DID NOT WRITE THIS BIT OF CODE.
It is another Paul Johnston somewhere else in England.
Paul (CF Master) Johnston ;)
-Original Message-
From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2000 23:59
To: CF-Talk
Subject: RE: Storing passwords
Can anyone think of a way of calling custom tags from within functions or
cfscript?
I think it's possible using a variation of Michael Dinowitz custom
functions. Just set up a page full of custom tags, and set up a function
that you pass in various values to and it returns a value. This value
of a
workaround).
Effectively, all you need is to put in a load of code if something changes
(maybe you could use error checking to include it with cftry).
Paul
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2000 12:15
To: CF-Talk
Subject: Extension to custom
: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:17 PM
To: CF-Talk
Subject: RE: Extra records in CSV file generation
Well, have you checked there are no empty records in the db at all?
Paul
PS I assume you have, but it's only polite to ask
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
-
Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 12:00 PM
To: CF-Talk
Subject: RE: Extra records in CSV file generation
Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place
I've put it:
Your code:
CFHEADER NAM
see cf_browser in the allaire tag gallery.
Paul
-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: 17 October 2000 16:48
To: CF-Talk
Subject: Browser Detection
Now i feel dumb for recently deleating all of that past browser detection
talk
this is all i want
Done both to be on the safe side!
I wish they'd document this. I suppose it makes sense if you think about
it, but it's not clear that you can't set a cookie like any other CF
variable and expect it to work.
Oh well, we all know now!
Thanks
Paul
-Original Message-
From: Rob
try
Cfset A = B C D E F
Putting the quotes round treats them as a string not a variable.
Paul
-Original Message-
From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2000 10:02
To: CF-Talk
Subject: manipulating variables
This is a multi-part message
Why not wrap it in a tag (see tag gallery) like
cf_stripwhitespace or cf_lesswhitespace (see below)
They take out all whitespace from a cf document after it's been processed.
It may sort it out, it may not.
Paul
PS cf_lesswhitepace from http://www.bjork.net/taggallery/index.htm is my
personal
of e-mango.com ltd.
---
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 5:05 PM
To: CF-Talk
Subject: RE: Extra records in CSV file generation
Why not wrap it in a tag
First of all, you need a source control SERVER. This sits wherever your
files are.
Then you need a source control CLIENT. This chats to the server and says: "I
want this file, let me have it!" or "Please create a new version of this for
me".
So, you install the server on the file server and the
An email is sent out with a url on it. THe url sets a cookie and then
redirects the user with a cflocation tag.
For some reason, the cflocation tag is run before the cfcookie tag is
complete thus not allowing the cookie to be set.
Any ideas?
Paul
PS Code:
CFQUERY NAME="getnextpage"
I found the XML Bible very good.
Paul
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2000 03:35
To: CF-Talk
Subject: RE: XML, XSL Books?
Have a look at http://www.vbxml.com/.
Peter Tilbrook
Internet Applications Developer
Aspect Computing
of float data types is not recommended when storing prices,
money amounts etc. as the representation is approximate : not all numbers
can be precisely represented.
Decimal is the data type you need.
P.
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday
Erm, I have never come across a situation where you would need to run X on
linux whilst the web server is running. Maybe you need X to install some
things, but after that it's strictly command line. Why waste resources on a
GUI when you don't need it?
Paul
-Original Message-
From:
I am having problems putting a decimal into a SQL Server field.
The data type is decimal and I am passing the value in with
DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx
and no more).
Exactly what SQL do I need to add in?
INSERT INTO...
...
VALUES
(
--
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 06 October 2000 13:22
To: CF-Talk
Subject: SQL Server Decimal
I am having problems putting a decimal into a SQL Server field.
The data type is decimal and I am passing the value in with
DecimalFormat
or message you get.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 06 Octobe
nd
see what happens
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 06 October 2000 13:44
To:
You could put all of the properties you want into a structure and then copy
the structure into the session variable.
Have a look at CF_XMLPARSE on
http://www.siteobjects.com/index.cfm?fuseAction=showProducts for a really
good XML tag that puts a document into a structure.
Paul
-Original
We've had this question before.
see CF_BROWSER in the tag gallery. It's more robust (although not perfect)
than just using the CFIF stuff although it is a custom tag and gives more
info than you could need (although it seems to still only uses the
CGI.HTTP_USER_AGENT part).
Paul
PS Why not
1 - 100 of 133 matches
Mail list logo