not sure about Q8, but Q13, presumably, implies some sort of single
tag/range of tags in cf9 to use those ws?...
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Tom Chiverton wrote:
8. Do you want coldfusion to be supported on AMD platform?
Are Adobe really suggesting there J2EE
8. Do you want coldfusion to be supported on AMD platform?
Are Adobe really suggesting there J2EE server *requires* an Intel chip ? It's
all i686/x86_64 isn't it ? They would use a random propietery extension,
would they ?
13. Which other products/Services would you want ColdFusion to integrate
Added the template to Settings 'Missing template handler' -- It does call up my
template but also still includes the default Coldfusion.
Error Occurred While Processing Request
File not found:
Message.
Also made the following changes to IIS as described here:
Added the template to Settings 'Missing template handler' -- It does call up my
template but also still includes the default Coldfusion Missing template
visuals.
Error Occurred While Processing Request
File not found:
Message.
Also made the following changes to IIS as described here:
I let the domain expire since I have not been doing any further updates
(got really busy on a full time contract).
Thanks,
Nic
Joeri B wrote:
It appears offline... Why?!?! I loved it so much :)
Hi Nic,
Can you put the documentation on your blog, so I can read them there :)
Thanks!
PS: So
You're still going to run into an valid issue where two completely
different videos have the same name. When it comes to CMS, even if they're
dupes, they're valid. The client is responsible for weeding out the
duplicates. Just getting the name (in your instance), wouldn't do you any
good. It's
Sure thing Michael, will do.
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 5:28 PM
To: CF-Talk
Subject: Re: File upload - my new posts aren't coming through
Not at all. I'm just wondering why the posts are not coming in/creating new
Well the problem is that we have multiple dynamic apps all running from the
same codebase. Each app gets the same code to begin with. Then we add in all
of the cached queries, sessions, etc. At it's heart though, I'd LOVE to be
able to target a specific session and find out it's specific memory
Hello James,
I want to grab the file name and query it in the database to see if it
exists or not before the 15mb file is uploaded. This way, if the file
exists, I can easily return an error and prompt the user to rename the file,
or offer suggested names for the file.
I've created a site for
Sure...I'm sure that interview was done about 2 or 3 months ago.
-Original Message-
From: Todd Rafferty [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 8:29 AM
To: CF-Talk
Subject: SPAM: Re: ColdFusion: Some People Just Don't Know Any Better
Too late. Looks like they've
This morning I read something disturbing. Weekly I get InformationWeek,
which really caters more to CIOs and SysAds more than developers. That's
part of why what I read disturbed me so much.
They run a weekly column titled CIO Values, in which they profile some
CIO or CTO from a variety of
There are some new fields that need to get passed which isn't an issue, but the
response coming back I'm unable to parse or I'm getting authentication issues.
What are the problems your seeing? I've just spent the last 2-3 weeks
working through the entire Google Checkout API and there were a
https://www.fedex.com/wpor/web/jsp/drclinks.jsp?links=techresources/announcements.html
Do you have a link to the service announcement?
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer /
Too late. Looks like they've already converted ( http://www.uline.com/ ).
On Feb 5, 2008 9:23 AM, Cutter (CFRelated) [EMAIL PROTECTED]
wrote:
This morning I read something disturbing. Weekly I get InformationWeek,
which really caters more to CIOs and SysAds more than developers. That's
part
Actually, I had seen this article already and brought it to the attention of
Kristen Schofield and Adam Lehman at Adobe. Kristen said she'd see what she
could do. So Adobe has already been alerted.
Judith Dinowitz
Editor-in-Chief: Fusion Authority
http://www.fusionauthority.com
I would like
the standard cf missing template (file not found...) warning you see: is
it for the requested page or for some template cfinluded in your missing
template handler page?
just a thought...
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Don wrote:
I would like to add to this that we
Hi Rick,
It doesn't solve the problem though. Here's the problem:
1. User #1 uploads a file called Movie.wmv. The file is uploaded to
site/videos/Movie.wmv. The file is referenced in the database in the video
file field Movie.wmv .
2. User #55 also uploads a file called Movie.wmv which is a
I won't run into a valid issue if the file is never uploaded
to the server in the first place. Basically the user submits
the file, before the cffile action I check the file name
and see if it already exists in the database.
If it does, then I return the error. If it doesn't exist,
then
Rick Sanders wrote:
Hi Todd,
I won't run into a valid issue if the file is never uploaded to the server
in the first place. Basically the user submits the file, before the cffile
action I check the file name and see if it already exists in the database.
If it does, then I return the error.
Why not use the makeunique option in the CFFILE tag? That way, if CF
detects a file with the same name, it renames it automatically. Then you
grab the serverfile name and enter that into the database.
Bruce
Rick Sanders wrote:
Hi Rick,
It doesn't solve the problem though. Here's the
why like this? why not use the NAMECONFLICT attribute of CFFILE? it will
automatically remane the uploaded file by appending a sequential number
to it. you can then on your 'success' page show user a link to the
created file, and/or email it to the user if you want to...
why not allow a user to
Is there anyway to configure the CF to run a scheduled task every M-W-F at a
specified time?
I'm looking for a way of doing it w/o creating a BAT file. Possible?
Thanks, Che
~|
Adobe® ColdFusion® 8 software 8 is the most
Why not have the user upload the file, rename it automatically if there is
a conflict for a name that is referred to within the database, but also retain
the original filename in the database for display to users.
Rick
-Original Message-
From: Todd Rafferty [mailto:[EMAIL PROTECTED]
I would like to add to this that we do NOT want to see the default ( missing
template information ). It seems to append this to the custom 'missing
template' page I've specified.
I'm not sure why since CF knows that we want a customized missing template
handler.
On Tuesday 05 Feb 2008, Aaron Rouse wrote:
I actually do not even recall seeing Q8 when doing the
survey, guess it shows how much I cared about that question.
Did you do both ?
--
Tom Chiverton
Helping to confidentially introduce essential experiences
on: http://thefalken.livejournal.com
- pls ignore test
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
I'm not surprised. The big question continues to be What can Adobe do
to promote ColdFusion? CF gets press on releases, and Adobe has
actively and aggressively marketed toward the government IT sector for a
few years now. I just want to see the articles that say Yeah, we're
migrating from .Net
On 2/5/08, Todd Rafferty [EMAIL PROTECTED] wrote:
Too late. Looks like they've already converted ( http://www.uline.com/ ).
I don't think there has been any conversion there, or any CF...looking
in the wayback machine, that site has been the same ASP classic stuff
since around 2002...
The CF8 Server monitor will tell you all of this.
On Feb 5, 2008 9:13 AM, Andy Matthews [EMAIL PROTECTED] wrote:
Well the problem is that we have multiple dynamic apps all running from
the
same codebase. Each app gets the same code to begin with. Then we add in
all
of the cached queries,
I thought Q13 also was implying that some tags would be developed for ease
of integration. I actually do not even recall seeing Q8 when doing the
survey, guess it shows how much I cared about that question.
On Feb 5, 2008 3:56 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
not sure about Q8, but
I would like to see some articles that said they were going from .NET to CF
as well but it is always the other way around. I do a lot of work for a
worldwide company that has over 80k employees and their standard was
ColdFusion with Oracle since sometime around the year 2000. They are in the
I would like to see some articles that said they were going
from .NET to CF as well but it is always the other way
around.
I'm working with a client who's transitioning from .NET to CF right now.
That said, I think there are more people going the other way.
Dave Watts, CTO, Fig Leaf
week they profiled Bill Santille of Uline, a 'Shipping Supply
Specialist' if Google has it right. (http://tinyurl.com/2fsj74)
Yeah, they're a great company with excellent customer service and quality
products. I use them, as do clients of mine. You should all get your
packaging and shipping
I only did one survey, was Q8 on a different survey than Q13? If they were
on the same then I probably just skimmed over Q8, because even reading it
here, I just do not care one way or the other about it.
On Feb 5, 2008 9:21 AM, Tom Chiverton [EMAIL PROTECTED] wrote:
On Tuesday 05 Feb 2008,
Hi Todd,
I won't run into a valid issue if the file is never uploaded to the server
in the first place. Basically the user submits the file, before the cffile
action I check the file name and see if it already exists in the database.
If it does, then I return the error. If it doesn't exist, then
Am I missing something? Why not just use the nameconflict=MAKEUNIQUE
attribute of CFFILE. This will auto rename the file if a file with that name
already exists. No overwriting of existing files. Like Rick said.
Will
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent:
It doesn't solve the problem though. Here's the problem:
1. User #1 uploads a file called Movie.wmv. The file is
uploaded to site/videos/Movie.wmv. The file is referenced in
the database in the video file field Movie.wmv .
2. User #55 also uploads a file called Movie.wmv which is a
Rick Sanders wrote:
I need to check to see if the file exists before it's uploaded, or it'll
overwrite the existing video.
Rick
Not if you use of 'nameconflict=makeunique' parameter of the
cffile... tag that exists for exactly this reason. With this
parameter set, CF will see that
I don't know, it looks like they are using the old .asp extension rather
than .NETs .aspx extension
:) Did he 'upgrade' into something older and slower?
William
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey:
You could point the task at a template that figures out what day it is and then
run the task on M-W-F.
Is there anyway to configure the CF to run a scheduled task every M-W-F at a
specified time?
I'm looking for a way of doing it w/o creating a BAT file. Possible?
Thanks, Che
Windows should be fine, you install CF to a locked down website in
IIS. This is then the only website that has the Admin, other websites
added still use CF but there is no CFIDE/
However we have an issue on Linux and Apache, where we have done this
already, but if you were to access
Possible to meet this requirement: YES. Schedule a task that only runs
on M-W-F: NO.
The way to work this is to schedule a task that runs every day. The
first thing the scheduled template does is use date functions to see
what day it is. Then if the day is a Monday, Wendsday or Friday do
On Monday 04 Feb 2008, Andy Matthews wrote:
of client machines running this app is between 60 and 100. How would Blaze
handle this?
Does/should it run on the same machine as the CF server?
These questions are essentially meaningless because it depends on how powerful
your box is, how busy it
Thanks. That'll do it.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 11:15 AM
To: CF-Talk
Subject: Re: CF and Scheduled Tasks...
Possible to meet this requirement: YES. Schedule a task that only runs on
M-W-F: NO.
The way to work this
However we have an issue on Linux and Apache, where we have
done this already, but if you were to access
/CFIDE/administrator/index.cfm the page still loads (without
the images and CSS) does anyone know how to turn this 'feature' off?
You have to explicitly disallow this URL in your web
Excellent point, Dave, thanks. On 4. Block external access to the built-in
web server., does any of cf8 resources/functions/tags depend on it? If not I
would simply disable it.
The CF Administrator is just a web application. You can control or prevent
access to web applications through
Your ASP example says just that. It gets the file name from
the HTTP header. The reason the file name is in the HTTP
header is because the entire file content is in the HTTP
header.
Just a minor correction, but neither the file name nor the file itself are
in the HTTP response header.
For cf8 on Windows platform, I wish it has an option of disabling remote admin
access, that is, an option to make
http://www.myDomain.com/cfide/administrator/index.cfm unavailable.
I also wish, the cfadmin directory path is relative, hence, if one renames the
'administrator' directory to
On Tuesday 05 Feb 2008, Che Vilnonis wrote:
Is there anyway to configure the CF to run a scheduled task every M-W-F at
a specified time?
You can always schedule it in CF for daily, and have the code check the day of
week.
--
Tom Chiverton
Helping to collaboratively grow fourth-generation
For cf8 on Windows platform, I wish it has an option of
disabling remote admin access, that is, an option to make
http://www.myDomain.com/cfide/administrator/index.cfm unavailable.
I also wish, the cfadmin directory path is relative, hence,
if one renames the 'administrator' directory to
That's a good thought, but I did double check this by removing ( commenting )
all included files to see if that might be causing the problem, the same thing
seems to happen.There at the end of our CUSTOM missing template page is the
DEFAULT CF Missing Template page.
Yah the ( file not
you were to access /CFIDE/administrator/index.cfm the
page still loads (without the images and CSS)
Note: Usually this happens due to your ColdFusion mappings in ColdFusion
administrator, not your web server mappings. That is why any .cfm page
loads, but images, JavaScript and CSS files do
Excellent point, Dave, thanks. On 4. Block external access
to the built-in web server., does any of cf8
resources/functions/tags depend on it? If not I would simply
disable it.
If you're using the built-in web server to run the CF Administrator, you
probably wouldn't want to disable it.
Has anyone done that? the CFcontent tag is the closest thing pops up, it does
some job but still have tons of garbage. If possible I prefer not to use third
party bla bla.
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the
You'd think if I use this all the time, as I stated, I'd be able to
get the syntax correct... NameConflict=MakeUnique, not what I wrote before.\
Too much copy and paste... :oP
Sorry!
Rick
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008
What is a BAT file?
--- Ian Skinner [EMAIL PROTECTED] wrote:
Possible to meet this requirement: YES. Schedule a
task that only runs
on M-W-F: NO.
The way to work this is to schedule a task that runs
every day. The
first thing the scheduled template does is use date
functions to see
Windows scheduled task manager uses .bat (or batch) files to auto run tasks
on a schedule.
-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 12:55 PM
To: CF-Talk
Subject: Re: CF and Scheduled Tasks...
What is a BAT file?
--- Ian Skinner
I am hoping an SQL guru can assist me with what I am sure is a stupid little
oversight or misunderstanding on my part.
I hope I can explain this. I need to do a bit evaluation against data in the
database where the data is stored in a BigInit column. Within my code I
construct a bit filter and
Use the attribute MakeUnique=Yes (or is it True ?)
to create a new filename if one exists with that filename already.
That was my point. You can have the system generate a unique filename
for CF and the database to reference, but maintain the original filename
in the database, too, to show
Of course you can schedule a task to run M-W-F. The answer is to schedule
three tasks.
And LoL at the what is a bat file question. I guess I'm really old
school.
Russ
-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 12:55 PM
To:
What is a BAT file?
I think it has something to do with the opening scene of Fear and Loathing
in Las Vegas.
On Feb 5, 2008 12:54 PM, Nate Willard [EMAIL PROTECTED] wrote:
What is a BAT file?
--- Ian Skinner [EMAIL PROTECTED] wrote:
Possible to meet this requirement: YES. Schedule a
Wow, Judith, you are fast! I only received my magazine copy yesterday. I
copied Ben and Damon on my original post (I had the wrong email for Kristen)
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
Why not run a local copy of SQL Server Express, run the scripts yourself to
import the DB's, than use the migration tool to convert it all over?
!k
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 7:19 PM
To: CF-Talk
Subject: RE: OT:
Are you sure that bigInt is what you think it is? I thought it was just a
signed integer (2billion+ to -2billion+).
Meanwhile, the code below will throw a syntax error on the ampersand...
BigIntCol CAST(...) ... The ampersand is not the concatenation operator
in T-SQL. You have to use a plus
Mark,
I knew I would most likely not explain it properly. The existing database
has a column that contains values that are typed as a BigInt. I have a
filter that gets constructed from Bit values for example: the filter = 129
which was constructed from bit 1 binary + bit 8 Binary 1 + 128.
What
That's funny.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 11:11 AM
To: CF-Talk
Subject: RE: SPAM: Re: ColdFusion: Some People Just Don't Know Any Better
I don't
If you've Beta tested any version of our upcoming time tracking product
Timealyzer (which we used to call WOOT! until we started listening to some
of you who said it wasn't a good idea to name it after a popular website),
please let me know if you'd like the release candidate that's about to go in
That's exactly what I'm in the process of doing.
Thanks, Kevin!
Rick
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 1:37 PM
To: CF-Talk
Subject: RE: OT: Translating MSSQL Scripts into MySQL Scripts
Why not run a local copy of SQL
week they profiled Bill Santille of Uline, a 'Shipping Supply
Specialist' if Google has it right. (http://tinyurl.com/2fsj74)
Yeah, they're a great company with excellent customer service and quality
products. I use them, as do clients of mine. You should all get your
packaging and shipping
You need a bitwise operator. Bit and is in MS SQL
SELECT mycolumns
FROM mytable
WHERE bit_column 128 = 128
Should be along the lines of what you want I think.
This example works for me on MS SQL 2005:
declare @test as bigint
set @test = 128
select @test 128
~Brad
-Original
You need a bitwise operator. Bit and is in MS SQL
SELECT mycolumns
FROM mytable
WHERE bit_column 128 = 128
This was essentially what I was doing but it does not work properly for
matching multiple bits in the bit_column, Example: matching a row that
has Bit 1 and Bit 8 (129) or
I'm not surprised. The big question continues to be What can Adobe
do to promote ColdFusion? CF gets press on releases, and Adobe has
actively and aggressively marketed toward the government IT sector
for a few years now. I just want to see the articles that say Yeah,
we're migrating from
I'm not surprised. The big question continues to be What can Adobe do
to promote ColdFusion? CF gets press on releases, and Adobe has
actively and aggressively marketed toward the government IT sector for a
few years now. I just want to see the articles that say Yeah, we're
migrating from .Net
I'm not Guru, but this should do it.
First you create a mask by turning on the bits you need.
myMask = 2^1 + 2 ^8
Then, bitwise AND () with your column. The result needs to be equal to your
mask to have all the specific bits turned on. NOTE: This assumes you don't care
about the value in the
not sure about Q8, but Q13, presumably, implies some sort of single
tag/range of tags in cf9 to use those ws?...
Right, think cffeed... You don't have to use cffeed to use feeds --
after all, they're already xml. You could just build or parse the xml.
So what they're asking is if you think it
Ok, so the problem is that you want the where clause to be dynamic based
on some user-entered search criteria? So you want to match 0 to n
possible bits?
I see two possible SQL solutions right off:
1) Populate temp table with candidate records in a cursor or while loop
for each filter (yuck)
2)
I live in a city of about 250,000 and once I find a new job, I'll end coding
in a different language and there's nothing I can do about it. I've tried
finding positions that will let me work remotely, but with justification, a
lot of companies aren't comfortable with that and I'm not willing to
the only other thing I would add is a counter of bad log in attempts.
if 5 attempts failed, I would lock out the account for a minute. If
more than 20 attempts, I lock it out until I reset it.
I have one very important page set up so that the user has to log in
with the same set of credentials
That's pretty smart.
-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 3:35 PM
To: CF-Talk
Subject: Re: Secure login system
the only other thing I would add is a counter of bad log in attempts.
if 5 attempts failed, I would lock out the
Agreed, I know one of the big things here that the IT Architects used to say
CF is a dead or dying language was all the examples they could show of
businesses going away from it. Although they were on a mission to go pure
MS and not sure if anything could have beat them off that mission.
On Feb
I have a site that allows people to list items for sell. I keep getting errors
emailed to me that state, Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to numeric. brThe error occurred on line 30.
Here is my query:
cfquery
doh! That should be 2^0 + 2^7 (silly me)
myMask = 2^1 + 2 ^8
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Jeff,
myMask = 2^1 + 2 ^8
SELECT mycolumns
FROM mytable
WHERE BigIntColumn #myMask# = #myMask#
This was exactly what I was doing - irrespective of the CAST to change data
types - but it will only select records that have bit 1 AND Bit 8. What I
need to do is to select records that
Take the following xml string value:
1969 Chevrolet Camaro - Windsor, ON N8W 5J1 - $44900
I use the following code to extract and set the price:
cfif findNoCase($, theArray[i].description.xmlText)
cfset price = listlast(theArray[i].description.xmlText, $)
/cfif
Sometimes though,
Are any of your columns numeric? I would think that CatID, UserID, and Price
should be numeric columns, but your query treats them as strings. My guess
would be that a price is getting submitted with non-numeric data. (dollar
sign, commas, letters?)
The line number in the error detail may not
Ah, you changed the question :) You originally said AND, now it is OR!
It doesn't change the problem much.
Step 1: Create your mask
Step 2: Zero out the bits we don't care about with
Step 3: If we are left with anything, we have records that contain a flag.
WHERE myColumn myMask 0
enjoy!
Do a ListLen(str, $) to see if the second element is present first.
Adrian
http://www.adrianlynch.co.uk/
-Original Message-
From: Che Vilnonis
Sent: 05 February 2008 20:59
To: CF-Talk
Subject: String Manipulation Fun
Take the following xml string value:
1969 Chevrolet Camaro -
Ya know, you could always add a captcha to the login screen as well as
the username / password, would stop any mass-login attempt or brute
force password crackers.
Chris
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 3:38 PM
To: CF-Talk
As a CF developer for many years, I often feel as if I work twice as hard
selling my services to a potential small-biz client, than the closest PHP
developer. Not only am I selling myself, I also *have to* sell CF.
From my potential client's perspective, they really don't care much on how
Why not just use something like:
cfset parsed = listlast(theArray[i].description.xmlText, )
cfif Len(parsed) GT 1
cfset amount = Right(parsed, Len(parsed)-1
cfelse
cfset amount = 0
/cfif
Untested... be warned. The only reason I left the dollar sign was to make
sure a result came
They should put out a request specifically for people who are switching
to CF to contact them for use in their marketing materials as case
studies. They might get for example that FigLeaf client Dave Watts
mentioned.
Good idea. They do have quite a few case studies already, but you can never
Well it's a bit hard for CF, because of the pricing model. CF is priced per
Server, meanwhile all the other technologies you mention can be hosted for
(relatively) free. .NET makes it up by selling more Windows Server
licenses, and PHP and RoR are free.
Microsoft has done a good job
There's probably a better way of doing this though...
There is-- but I think it involves atomic data. :)
~Brad
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Thanks. Did the trick...
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 4:06 PM
To: CF-Talk
Subject: RE: String Manipulation Fun
Do a ListLen(str, $) to see if the second element is present first.
Adrian
http://www.adrianlynch.co.uk/
Nice, wonder how accurate the list is there, I see we are on there but I
know we have not bought CF for our data centers in a long time especially
since they are outsourced. We also are moving around from CF.
On Feb 5, 2008 3:25 PM, Josh Nathanson [EMAIL PROTECTED] wrote:
They should put out
As a CF developer for many years, I often feel as if I work twice as hard
selling my services to a potential small-biz client, than the closest PHP
developer. Not only am I selling myself, I also *have to* sell CF.
From my potential client's perspective, they really don't care much on how
Hmm...you're right, I'll remove the single quotes around CatID, UserID, and
Price.
I'm using JS validation that removes all non-numeric data from the Price field,
but maybe they have JS turned off?
Are any of your columns numeric? I would think that CatID, UserID, and Price
should be numeric
Hmm..update..I just emailed the latest person who generated the error. They
said that they weren't able to upload their images. Here's the complete query:
cftransaction
cfquery name=Product datasource=wioDB
SET NOCOUNT ON;
INSERT INTO Products (CatID, UserID, Designer, Model,
*always* validate on the server.
if you want to run some stuff on the client, that's fine... but
especially if you're talking about data... don't let the integrity of
your data rest on something you can't control (client side
validation).
easy enough to remove those non-numeric characters via cf
It seems to me, as a list, that your delimiter is a hyphen, not a dollar
symbol
trim(listlast(theXMLdata, '-'))
or if you don't want the dollar symbol...
replace(trim(listlast(theXMLdata, '-')), '$', '')
or a regex to grab everything after the $ (if you can guarantee no other
dollar symbols)
1 - 100 of 129 matches
Mail list logo
