The point in the whole discussion is not whether to use MySQL for your
projects, but WHEN to choose MySQL for your projects. Running a simple
website is pretty much a MySQL job, but when you are doing some serious
development whereas business processes heavily rely on database data,
data integrity
Bonjour Claude
I think we are both coming at this thing the same, but just from a
slightly different direction. I agree with almost everything you say,
but personally I would prefer to see the standard layed down agree by
all before it is implemented. Implementing something without telling
anyone
I'm not 100% sure about this, but I think the version of Verity
shipped with CF is so old that it does understand that your page with
the extension .xml is rendered like an HTML page in the browser and
therefore doesn't know how to parse it. I had a similar problem with
PDF file recently. The
Great!
Can anyone tell me how to configure IIS to do this?
Thanks.
If I'm logged onto my local machine in the local domain, is
there a way that ColdFusion can identify my username?
Is there a way of identifying if the user is logged onto the
local domain already? And who the user is?
Wow! Which version did you use last? I really want to hear an
explanation of this one
Cutter
Micha Schopman wrote:
MySQL is out of the question for sensitive information. MySQL is missing
to much functionality to maintain data integrity on db level.
Micha Schopman
Software Engineer
You need to disable Anonymous access under the security tab of the website
under IIS.
This will populate the cgi variable cgi.auth_user
This will only work on your intranet though.
Taco Fleur
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-Original
I quote, for foreign keys, transactions and triggers. Correct me If I am
wrong but this comes from the MySQL site.
Note that, for the moment, only InnoDB tables support foreign keys.
See section 16.7.4 FOREIGN KEY Constraints
On Thursday 02 Sep 2004 22:04 pm, Adrocknaphobia wrote:
This is def a driver/cfmx issue as you will not see this error in any
form in SQL*Plus.
Do you still see the error with the updated drivers from the Updater ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
Matt Robertson wrote:
Jochem wrote:
After doing a simple division by 2.20371, your balance doesn't quite
balance anymore.
You mean do the division in the sql?Thats something I would never
do, personally.
Where else can you do it and have control over precision and
rounding? In CF we
I have a query I need which is nothing short of awkward.I have a field
which is a date/time type storing data as a full date/time i.e.: 2004-09-03
10:37
I need to select them so that the value returned is 2004-09-03 00:00 but
more than this I need 3pm to be the date change.
For example.
James Smith wrote:
I have a query I need which is nothing short of awkward.I have a field
which is a date/time type storing data as a full date/time i.e.: 2004-09-03
10:37
I need to select them so that the value returned is 2004-09-03 00:00 but
more than this I need 3pm to be the date
there's an idea (i don't want to say generally held but it sometimes seems
so) among folks serious about their databases that mysql isn't quite
right-in-the-head. a few years ago the developers of mysql had this funny
publicly stated attitude about transactions as being a fancy, unnecessary
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE)
FROM table
or if you're not fortunate enough to have standards compliant db like
postgres,say sql server:
SELECT CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS
smalldatetime) AS yourNewDateTime
[Todays Threads]
2004-09-03 08:00 -- 2004-09-03 00:00
2004-09-03 14:00 -- 2004-09-03 00:00
2004-09-03 15:01 -- 2004-09-04 00:00
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS
DATE) FROM table
At first glance this looks good and the MySQL docs seem to support this
theory but it just throws an
James Smith wrote:
2004-09-03 08:00 -- 2004-09-03 00:00
2004-09-03 14:00 -- 2004-09-03 00:00
2004-09-03 15:01 -- 2004-09-04 00:00
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS
DATE) FROM table
At first glance this looks good and the MySQL docs seem to support this
theory but
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM
table
or if you're not fortunate enough to have standards compliant
db like postgres,say sql server:
SELECT
CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS
smalldatetime) AS yourNewDateTime
2004-09-03 08:00 -- 2004-09-03 00:00
2004-09-03 14:00 -- 2004-09-03 00:00
2004-09-03 15:01 -- 2004-09-04 00:00
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS
DATE) FROM table
At first glance this looks good and the MySQL docs seem to support
this theory but it just
I think the W3C
need to take more external advice from developer how actually have to
use their standards in day to work, not just from the people that make
the browser products like MS and Mozilla.
I'll second that.
Now, as far as HTML and _javascript_ standards are concerned, and about the way
James Smith wrote:
2004-09-03 08:00 -- 2004-09-03 00:00
2004-09-03 14:00 -- 2004-09-03 00:00
2004-09-03 15:01 -- 2004-09-04 00:00
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS
DATE) FROM table
At first glance this looks good and the MySQL docs seem to support
this theory but
My problem is with is piece of code in QueryB.
It is creating an ODBC error.
If your query contains quotes, you have to use
#preserveSingleQuotes(SQLQUERY)#
in your query B
--
___
REUSE CODE! Use custom tags;
See
Same old same old... commercial differences always get in the way of
progress. If everyone in the world worked together on everything and
shared all knowledge the we would probably have made more advances
then we have and be a much better place.
Vive La Monde!!! (not sure that is completely
Jochem van Dieten wrote:
Does the following work:
SELECT MessageDate + INTERVAL 11 HOUR AS DATE
FROM table
That should be:
SELECT MessageDate + INTERVAL 11 HOUR
FROM table
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and
Now I can do this by looping over a query and stinking the values into an
array but is it possible to do this directly in the SQL?
My feeling is that it would probabily be rather difficult with MySQL.
I would do it in a loop in CF.
--
___
REUSE CODE! Use
Is there anyway to do this? I do a lot of fusebox and I wanted to
change the colours so I can see what files are being called.
I KNOW how do do this is CFMXbut I need a solution for CF5
Any ideas?
--
Mark Drew
coldfusion and cfeclipse bloged:
http://cybersonic.blogspot.com/
[Todays Threads]
Vive La Monde!!! (not sure that is completely right!!!)
Almost: LE monde ;-))
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads]
7. What does zerofill do to a integer field? A database is
meant to store data, not to format it while storing.
Actually I find this to be a nice feature...if necessary.
For instance you are using Auto_Increment INT field and you
are using it as your order number.Maybe you want all of
Finally...
After much messing about I finally got a modified version of Jochem's
solution working...
Jochem's original:
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table
Working:
SELECT CAST((your_datetime_field + INTERVAL 9 HOUR) AS DATE) FROM table
Note the extra
Ok... only a guess anyway!!!
Andrew.
- Original Message -
From: Claude Schneegans [EMAIL PROTECTED]
Date: Fri, 03 Sep 2004 07:21:52 -0400
Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement...
To: CF-Talk [EMAIL PROTECTED]
Vive La Monde!!! (not sure that is
Ok, extension of this problem
SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date,
ItemCount
FROMtable
Works just fine and returns the dates exactly as I want, unfortunately I
need to be using sum(ItemCount) giving me...
SELECTCAST((MessageDate + INTERVAL 9 HOUR) AS DATE)
If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open.
There is no firewall on this computer, the only thing is I installed the sp2 and after disabling the
With a bit of experimenting...
SELECTCAST(DATE_FORMAT((MessageDate + INTERVAL 9 HOUR),'%d/%m/%Y') AS
CHAR) AS Purchase_Date,
sum(ItemCount) AS TotalSales
FROMtable
Works for my purposes this time, but it would still be nice to know why the
group by clause caused MySQL to convert the Date column
Judging by your paths I am going to guess that you are on Windows. You
might want to take a look at the verity spider. Just a thought.
Doug
Charles Chen wrote:
Hi All. I'm a fairly new CF developer. I'm having weirdness indexing a website that is mostly a collection of XML pages. I'm really
I have never tried to do it. I am hard pressed to think of why I would
ever want to maybe MM developers were the same way. Any chance you
could give me a real world application for this? Maybe I am missing
out on some revolutionary concept :)
Adam H
On Thu, 2 Sep 2004 13:01:42 -0700, Rob [EMAIL
On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote:
If I open it as a localhost from the same machine, yes then the website
opened, but if I open it with domain, the website is not getting open from
this machine, and rest of the world can open.
Check the DNS.
Can this machine 'ping' it's own
I'd found that out, too, and ended up adding error catching in the PL/SQL to
always make sure that I opened the ref cursor and passed it back, even if it
was empty.
- Original Message -
From: Adrocknaphobia
** this is a response to a post from 3/9/2004 which never seemed to be
Yes I ping the domain from the same machine, and got response.
I ping the external static ip, got response.
I ping the internal ip, got response.
I ping the computer name, got response.
infact I ping outside the network and got response as well.
thanks
On Friday 03 Sep 2004 13:10 pm, Asim
Not Adrocknaphobia, but as far as we'er concerned Don't know - the
updated drivers crash our whole system. :(
- Original Message -
From: Thomas Chiverton
Do you still see the error with the updated drivers from the Updater ?
[Todays Threads]
[This Message]
[Subscription]
Hi,
I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set?
Basically what I have is like a to do
Can you use the domain names on other PCs on the network and see the
sites properly?
Here, we're behind a firewall using NAT... port forwarding...
Presently, I cannot use domain nameswith other PCs on the network.
If I do, I just get the firewall box. But the external world has
access without
Since CFHTTP support is broken in all versions since CF 4.5 (as in
CFHTTPPARAM automatically urlencodes all the names and values, and there's
nothing we can do about it), I was wondering if there are any CFMX
alternatives to CFHTTP, short of writing your own java classes every time
you need to
Thanks Yves,
I am not on that location now, but thats a good point. I will test this in the eveing and post the reply tomorrow.
- Asim
Can you use the domain names on other PCs on the network and see the
sites properly?
Here, we're behind a firewall using NAT... port forwarding...
Presently, I
If you're on windows, you can modify your hosts file and map the domain name
to an ip manually in there.
The file is in C:\WINDOWS\system32\drivers\etcand it's called hosts
Just add a line in there such as
192.168.0.5 www.mysite.com http://www.mysite.com/
and it should work from your
On Fri, 3 Sep 2004 10:16:17 -0400, Russ [EMAIL PROTECTED] wrote:
Since CFHTTP support is broken in all versions since CF 4.5 (as in
CFHTTPPARAM automatically urlencodes all the names and values, and there's
nothing we can do about it), I was wondering if there are any CFMX
alternatives to
Hi.
I have have problem with accented characters in file names when they
are uploaded using CFFILE. The file name in question was:
Lonidas.pdf
And the with changed to a question mark (L?onidas.pdf), however the
variables returned by CFFILE had it create, so when the code used the
file name
Jochem... I second that.Use the database handle data manipulation. I've
worked on lots of sites where the original developers where not knowledgable
about SQL and they wrote good CF code, but handled EVERYTHING in CF ... not
a good solution. It's like trying to change a tire with a pliers.
-mk
I have never tried to do it. I am hard pressed to think of why I would
ever want to maybe MM developers were the same way. Any chance you
could give me a real world application for this? Maybe I am missing
out on some revolutionary concept :)
Adam H
Never tried to copy a node from one XML
If you have a NAT type scheme you may have an external address and an
internal address.It's pretty comon for DNS administrators to not keep
the internal zones up to date.Add an entry to your host file.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday,
I believe this is a multilanguage issue. Check on multilanguage settings in
your CF Admin if you have access.
Or, if it is expected that people will be naming things using accents
frequently, parse out accented letters and replace with the corresponding
unaccented letters prior to executing your
I'm not a DHTML guy by any means. Could someone point me in the right
direction to figuring out how to use DHTML to take a record from within a
record set, drag it to a higher or lower position, and have it change its
position within the record set?
Guy,
I recently set up a drag-and-drop
Hi Matthieu,
That's exactly the launching pad I was hoping for. Not to mention the exact
same functionality that I am going for. Your description is excellent and
concise. Might you think of doing a tutorial on it for other folks?
Thanks again.
~Guy
[Todays Threads]
[This Message]
That thing works well. and problem is gone.
But I don't understand one thing.
Can this entry could be removed when I un-install the sp2? i mean it was working fine 2 days ago. and suddenly it stops serving locally.
What could be the cause of this. removal of sp2 or something else.
If you're on
Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes
the new #3 and the old #3 becomes #4 and so on.
I think in your case, I wouldn't use true drag'n drop, I mean drag events.
Drag events are really to copy some
I did read the docs. The docs state:
encoded
Optional
Yes
Applies to FormField and CGI types; ignored for all other types. Specifies
whether to URLEncode the form field or header.
I am using it on a cookie type.
Russ
_
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Is this a CF problem or any OS problem
Looks like an OS issue, does Linux support accents in file names?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Hi everyone,
Does somebody have a reference to any custom tag or udf written to get
the zodiac sign from a day and month.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
There is an alternative written in c++
http://www.cftagstore.com/tags/cfxhttp5.cfm
I havn't used it but the claims made on the website are impressive.
Andrew.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I'll post back with more information about drivers. I'm going to be
running test against oracle's drivers, as well as the latest ones MM
released with the updater.
(I'm still struggling with a thread locking issues, on another system,
that seem to be related to the DataDirect 3.2 drivers not
Please disregard this email. I found one on www.cflib.org
On Fri, 3 Sep 2004 11:19:43 -0400, Qasim Rasheed [EMAIL PROTECTED] wrote:
Hi everyone,
Does somebody have a reference to any custom tag or udf written to get
the zodiac sign from a day and month.
[Todays Threads]
[This Message]
On Fri, 3 Sep 2004 11:18:05 -0400, Russ [EMAIL PROTECTED] wrote:
I did read the docs. The docs state:
encoded
Optional
Yes
Applies to FormField and CGI types; ignored for all other types. Specifies
whether to URLEncode the form field or header.
I am using it on a cookie type.
I did think about parsing the file name and replacing the characters,
but the people the site is for will not allow the file name to be
changed. It is a government funded project and therefore everything
has not be exactly right!!!
Andrew.
- Original Message -
From: [EMAIL PROTECTED]
Yes, it really is an issue, as several sites that I'm pulling the data from
require login, and they don't recognize the URLEncoded session cookies sent
by CF.
Russ
_
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 11:31 AM
To: CF-Talk
Subject: Re: CFHTTP
Looks like an OS issue, does Linux support accents in file names?
If I FTP the file up it works ok, so I guess Linux is ok with the
accented file name.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I'd be interested to hear how the Oracle drivers work for you. We had to
roll back from the latest MM drivers. But, I don't think they've tried any
of the Oracle ones. Are there new drivers with this latest release? It
hasn't been installed here yet.
- Original Message -
From:
On Fri, 3 Sep 2004 16:41:01 +0100, Andrew Dixon [EMAIL PROTECTED] wrote:
I did think about parsing the file name and replacing the characters,
but the people the site is for will not allow the file name to be
changed. It is a government funded project and therefore everything
has not be
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where?
--
Ian Skinner
Web Programmer
BloodSource
Thanks Andrew, I'll try it. Seems impressive.
Russ
_
From: Andrew Grosset [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 11:22 AM
To: CF-Talk
Subject: Re: CFHTTP Alternatives
There is an alternative written in c++
http://www.cftagstore.com/tags/cfxhttp5.cfm
I havn't used it
Ian Skinner wrote:
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where?
Recording proxy or the FireFox LiveHTPHeaders plugin.
Jochem
[Todays Threads]
[This Message]
Guy,
Thanks for the kind words.The truth is that I learned by reading some
tutorial somewhere myself.If I could have remembered where it was, I would
have just sent you the link, because it was quite good.
That said, my application of what I learned was more specifically geared
toward
I had the same problem with CF and BlueDragon and I had to write something
like this to change the file name on the server.. I kept the original name
in my database and when I serve the file with cfcontent I rename to the
original name. Since my variable name are in french, the first one is all
I'm experiencing some kind of redirect/cflocation endless
loop.Is there some easy way to trap the iterations of
this loop so that I can see what is trying to redirect to
where?
Create a custom tag to wrap the cflocation tag. Replace all instances
of cflocation with cf_location or whatever the
I'm experiencing some kind of redirect/cflocation endless loop.Is there
some easy way to trap the iterations of this loop so that I can see what is
trying to redirect to where?
Ian,
I don't know if this applies, but when I have confusing and unplanned
page-to-page routing, I add a dummy URL
Russ wrote:
I did read the docs. The docs state:
encodedOptional Yes
Applies to FormField and CGI types; ignored for all other types. Specifies
whether to URLEncode the form field or header.
I am using it on a cookie type.
IIRC you can use the CGI type to send cookies as well:
Hi, is there a tag or something to know exactly what is the CF version on
our hosting?
Thanks
Pat
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
S.Isaac Dealey wrote:
I'm experiencing some kind of redirect/cflocation endless
loop.Is there some easy way to trap the iterations of
this loop so that I can see what is trying to redirect to
where?
Create a custom tag to wrap the cflocation tag. Replace all instances
of cflocation with
I did think about parsing the file name and replacing the characters,
but the people the site is for will not allow the file name to be
changed.
Then keep the original file name in you db, store the document under any file name you want, store this on as well
in you db, then restitute the
#server.coldfusion.productversion# I think...
Hi, is there a tag or something to know exactly what is
the CF version on
our hosting?
Thanks
Pat
s. isaac dealey954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
server.ColdFusion.ProductVersion
Should tell you what you need to know
Spike
Stephen Milligan
Code poet for hire
http://www.spike.org.uk
Do you cfeclipse? http://cfeclipse.tigris.org
-Original Message-
From: [EMAIL PROTECTED]
It's one of the SERVER scoped vars I think
try a page with CFDUMP var=#SERVER# and you should see it...it's part of the debugging output.
Of course you could just ask the ISP ;-)
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone:
I was going to suggest something similar.You could use a + and -
button to move the item up or down.Then _javascript_ just needs to find
the currently selected item(s) and then add or subtract one to the index
and adjust the other indexes accordinly to move the others into the
right place.I guess
is there any tool out there to convert the infobase data to access or MSSQL or maybe excel.
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Pat,
Charlie Arehart wrote a tag that checked the server for the CF
version.Info on it can be found here:
http://www.findarticles.com/p/articles/mi_m0MLU/is_5_5/ai_101527468
I can't find anything online that shows he has updated it in the last
18 months or so.
Rick Mason
- Original
Try this code:
CFOUTPUT
Product: #Server.ColdFusion.ProductName#BR
Version: #Server.ColdFusion.ProductVersion#BR
Level: #Server.ColdFusion.ProductLevel#BR
CFOUTPUT
Or just dup the SERVER scope.
_
From: Rick Mason [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 12:46 PM
To:
On Fri, 03 Sep 2004 18:01:25 +0200, Jochem van Dieten
[EMAIL PROTECTED] wrote:
Russ wrote:
I did read the docs. The docs state:
encodedOptional Yes
Applies to FormField and CGI types; ignored for all other types. Specifies
whether to URLEncode the form field or header.
I am using
Jillian Koskie wrote:
I'm moving an application from CF 5 to CFMX... and I'm having a problem
with some of my data.
The database is PostgreSQL.
For posterity:
The database was originally using the encoding SQL-ASCII. With CF
5 this results in characters with accents being treated as
Yeah, according to Forta one of the major reasons they relased the 6.1
Updater was because they got some new drivers made for Blackstone and
didnt want to make us wait for them. Previously the lastest dataDirect
driver they released was 3.3, so I assume that the ones included with
the 6.1 Updater
On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia
[EMAIL PROTECTED] wrote:
Yeah, according to Forta one of the major reasons they relased the 6.1
Updater was because they got some new drivers made for Blackstone and
didnt want to make us wait for them. Previously the lastest dataDirect
driver
Ok, I know this is off topic, but the previous questions about the
onDrag and onDrop events got me curious and since most government
employees (my customers) are off today, I'm kinda piddling around with
some ideas.With that said, I got some onDrag and onDrop events working
with images dropping
not 100% surebut the text could be in a div and the div could have somehting along the lines of
onFocus(this.blur;);of course that may stop you from dragging it as well ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
Check out the dragdrop library at http://www.walterzorn.comWe've
used it for a couple things, and it's pretty slick.
cheers,
barneyb
On Fri, 3 Sep 2004 13:20:13 -0400, Burns, John D
[EMAIL PROTECTED] wrote:
Ok, I know this is off topic, but the previous questions about the
onDrag and onDrop
Hi All,
I have a table that I would like to replicate each time the output loops
through, based on grouping. However, within the table there are outputs
that call to the request scope variables. That in turn throws an error as
the request scope variables aren't a part of the grouped query's
Check out the dragdrop library at http://www.walterzorn.comWe've
used it for a couple things, and it's pretty slick.
yeah we use walter's stuff (he's got a nifty js drawing lib too) for many
clientside functions. its the bee's knees.
[Todays Threads]
[This Message]
[Subscription]
[Fast
You can definitely call request-scoped variables from inside loops.
Are you scoping the variable call with request.?
cheers,
barneyb
On Fri, 3 Sep 2004 13:46:11 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi All,
I have a table that I would like to replicate each time the output loops
Dave which version of the Oracle JDBC drivers are you using?
-Adam
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
Date: Fri, 3 Sep 2004 13:23:19 -0400
Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion
To: CF-Talk [EMAIL PROTECTED]
On Fri, 3 Sep 2004 13:15:31
I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward.
In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point.
Josen
GoMotorbids.com
[Todays
On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia
[EMAIL PROTECTED] wrote:
Dave which version of the Oracle JDBC drivers are you using?
Using the script at the below URL, this is what I get:
[Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721
Script:
Still use Find() or FindNoCase()...but reverse the string using Reverse()...like so
FindNoCase(Reverse(MyString))
HTH
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL
On Fri, 03 Sep 2004 13:59:31 -0400, Josen Ruiseco
[EMAIL PROTECTED] wrote:
I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward.
In other words, it finds the first occurance of a substring within a string but
How about passing the string to reverse() first.Won't be perfect,
because you'll need to reverse your search string as well, and then
subtract the returned index from the length, and unreverse everything
to use it, but it'll function.YOu can wrap all that up in a UDF
pretty easily.
Or, if you're
It doesn't do everything you want, but the core of it can be accomplished
easily using my ObCollectionOrdered _javascript_ abstraction here (long URL
alert!):
http://www.depressedpress.com/depressedpress/Content/Development/_javascript_/
Extensions/ObCollectionOrdered/Index.cfm
The collection
These suggestions are all good. The problem I have is that I am searching out text from an cfhttp call. When I reverse the cfhttp.filecontent it becomes a huge mess and is difficult to work with.
Thanks for the ideas...
Josen
How about passing the string to reverse() first.Won't be perfect,
1 - 100 of 134 matches
Mail list logo