Yes, maybe, and yes. :)
If you are talking about rewriting it I assume you have the open
source version. CF Forums main bottleneck is that it uses subqueries
to generate the message counts. Get a lot of messages, or a lot of
forums and it starts to blow a gasket. It's also been a while and
there m
> doc.write and innerHTML is the same thing...it's all writing out html
> with _javascript_, and it's old, lame, and slow. I'd though that was
> implied. It's all DOM 1. I wouldn't even mind DOM 1 if it was fully
> implemented, but it's not
It's clear to me you just like to complain for the sake o
Is the forum using Access or SQL Server?
If it is using Access then up the database to SQL Server and that should help alot.
Clint Tredway
www.digital12studios.com
Original Message:
Return-Path: <[EMAIL PROTECTED]> Thu Oct 16 21:25:44 2003
>Received: from houseoffusion.com [64.118.64.245] by ma
Do you mean that if the next report is on the next day then it doesn't show?
i.e.
Previous = 8
This >
Next = nothing
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Friday, 17 October 2003 5:02 p.m.
To: CF-Talk
Subject: OT: SQL Query
I need to write a query a
I need to write a query and really don't know where to start -- here is the description.
I have a number of reports all dated, but dated by day (no time).
Some of the reports are on the same day If I have an ID value, I need to grab the report before and the report after that ID and it needs to be
I did a hack and made it work, good enough for now, thanks all.
Eric
_
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:29 PM
To: CF-Talk
Tony, thanks for the pointer...
Wow...am I out of it...
It is breaking at row 1, 3, and 5 instead of 2 4 and 6
Tony, thanks for the pointer...
Wow...am I out of it...
It is breaking at row 1, 3, and 5 instead of 2 4 and 6. Ideas?
Eric
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:05 PM
To: CF-Talk
hello eric.
do this.
in your looping, check to see if th
Hi all,
Has anyone here implemented a high volume site using CF FORUM 2000?
We have just inherited one, and am wondering how solid the code is.
Its a very busy forum, doing about 3 gigs of traffic per day, and its
started to show signs of breaking down, e.g. deadlock errors,
timeouts, "No more da
the only other thing you could add, just in case there is
an odd number of rows, you would want to protect against that so
that your table was correct in its format and you didnt have a hanging
there with no at the end, would be, hmmm, not sure
too late, and no time to think about it...but im su
hello eric.
do this.
in your looping, check to see if the queryname.currentRow mod 2
and if so, add a and start a new row.
this should work like a charm, closing the row if its th
This is elementary I am sure, but brain is fried out...
I have some records that need to be displayed left to right, 2 columns per
row...
So,
Column 1 Column 2
(record 1) (record 2)
(record 3) (record 4)
How do I do something this simple? All the monkey business I am figuring
out doe
Michael, perhaps your scripts could avoid blindly truncating at the first
row of dashes, and instead check for the dashes, and then some additional
critera.
Here's the complete text of my message:
I've been having a lot of problems with the JRun connector to Apache of
late. I'm running CFMX 6.1,
A bit of a reach but maybe check to see "mapCheck" variable is set to 0
in ur jrun.xml
8
1
1000
0
20
500
true
*
51010
300
Apache spawns a child process on every request to perform this mapping
lookup if it's NOT set to zero.
HTH!
Stace
_
I've been having a lot of problems with the JRun connector to Apache of
late. I'm running CFMX 6.1, Apache 2.0.47, and RedHat Linux 8.0 on a dual
Xeon with a gig of RAM. Aside from a couple ssh sessions, there is nothing
else running on it.
I'm using http_load against the server at 85 requests p
Thanks, everyone! GREAT recommendations!
Dave
--
David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
775-832-2445
Marlon Moyer wrote:
>
> Here's the start of some code that would do it. You'd need to make a
> function out of it.
>
> declare @test varchar(50)
> declare @
I presently have a query run against an Access 2000 db in preparation for a
Verity on CF5. This is 5 fields containing about 17,000 records -
runs fine (but slow) on the CF5 box.
Here's the query:
SELECT *
FROM citationsTable
I now want to move this over to CFMX 6.1, but running just a simple
Generally it is. With radio buttons and checkboxes you'll probably find it
isn't.
However, it's generally considered good practice to cfparam all of the form
variables.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, 17 October 2003 12:03 p.m.
To: CF-Talk
Any consultants interested in a 30 day quick in-and-out job in San
Diego? ColdFusion knowledge is a must, working with LDAP or siteminder a
plus. XML a plus. The job will be to extend an existing app to support
authentication, and batch processing.
Ray Bujarski
[Todays Threads]
[This Message
Thanks Matthew... so if a form field entry is left blank, the variable
is not passed to the receiving template?
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:54 PM
To: CF-Talk
Subject: RE: passing empty form field entry
Basically cfp
Basically cfparam is a way of saying "let's just make sure this variable
exists as we're relying on it." You can also also do other things with it
but that's the basic deal.
Here's a custom tag I knocked together this morning which is similar to
cfparam but a bit more featureful. You call it lik
I did not try that... I will actually give that a shot and if it works, I
will have to ask someone to help explain why :-)
Thanks Ken.
Mike
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:43 PM
To: CF-Talk
Subject: RE: CreateUUID() /
Where do you set the cfparam? In the receiving template such as
I've always struggled with CFPARAM
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:36 PM
To: CF-Talk
Subject: RE: passing empty form field entry
The standard way is a c
No response as to why it's happening but have you tried doing a
whatever = "#CreateGUID()#"> and then using the whatever value in your
cfprocparam?
Ken
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:32 PM
To: CF-Talk
Subject: RE:
thanks that did it.
duane
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 5:19 PM
To: CF-Talk
Subject: Re: Help with A Query
Jochem van Dieten wrote:
>
> In SQL it would be:
>
> SELECT
> ID,
> CASE
> WHEN ImageURL6 IS NOT NULL
>
The standard way is a cfparam.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, 17 October 2003 11:21 a.m.
To: CF-Talk
Subject: passing empty form field entry
If a web site visitor completes a form without entering data in a field
(which in this case may be O
Thursday, October 16, 2003, 2:20:37 PM, you wrote:
>> MF> Just tell me about something that you would like to implement as DW's
>> MF> extension and you can't due to the API's limitations
>>
>> For one example, setting focus. Focus needs to be able to be set from
>> anywhere, to anywhere. This is e
Any takers :-)
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:23 AM
To: CF-Talk
Subject: CreateUUID() / CreateGUID()
I am noticing something strange here and am hoping someone can enlighten
me..
My form has a field called userId
If a web site visitor completes a form without entering data in a field
(which in this case may be OK), how do you set up the coding for
inserting that "blank" entry into a database (or ignoring that field).
If I include the field in the SQL insert statement, I get an error
"resolving parameter"
OK, now don't shoot me. The problem was between the the chair and the
keyboard, namely me.
I er, um, ahh put in some test data in the classDates table and BECAUSE it
was test data I set the classID to non-existent numbers.
Funny how getting some sleep helps. I saw it the moment I came back.
Than
> is there anyway to include java servlets in a CF page on an
> MX CF server that is running on IIS, I'm getting errors when
> trying to do this, although the same template runs fine on a
> dev box that is running the jrun stand alone from install.
Can you run the servlets directly through IIS?
It's actually pretty easy. XML is just text. Create a variable with your
XML, then use cffile to write it. Something like:
jpegURL="asdfg">zxcvb
-Original Message
We used one with a Flash/CF application. Piece of cake. The card swiper
plugs in between the keyboard and the computer and it sends keystrokes and
an enter key just as if someone had typed it into the keyboard (at least the
one we used).
Just have to make sure focus is in the right place when th
Can you change your character encoding to UTF-8? That might enter the
apostrophes correctly (sans box) and output them correctly.
Or maybe that is the problem and you should switch it to ISO 88...
whatever Windows uses (since Access is Windows).
--
Austin
[Todays Threads]
[This Message]
[
All:
CDI, my employer in WV, passed this position onto me today. NOTE (VERY IMPORTANT): If anyone from this list applies to this position, make sure they mention that they heard about it from the West Virginia Macromedia Users Group posting on this list. The position is a contract position
I haven't had what seems to be an annoyingly basic question in a while,
so here goes:
All of my other websites on this server work correctly. I added a new
website in IIS. For this new website, default pages in a directory
(index.cfm) load just fine. If however I try to open the same page by
s
Jochem van Dieten wrote:
>
> In SQL it would be:
>
> SELECT
> ID,
> CASE
> WHEN ImageURL6 IS NOT NULL
> THEN numPhotos = 6
> WHEN ImageURL5 IS NOT NULL
> THEN numPhotos = 5
> WHEN ImageURL4 IS NOT NULL
> THEN numPhotos = 4
> WHEN ImageURL3 IS NOT NULL
> THEN numPhotos = 3
>
Hi all,
Anyone out there have any experience connecting a credit card swiper to
a ColdFusion application? We have a POS that we built for a client.
Right now they enter CC numbers by hand. But they're busy (that's a
good thing) so they want to ease the process.
Ideas?
Thanks in advance,
Ian
Duane Boudreau wrote:
>
> SELECT ID,
> IF ImageURL6 IS NOT NULL
> BEGIN
> SET @numPhotos = 6
> END
> IF ImageURL5 IS NOT NULL
> BEGIN
> SET @numPhotos = 5
> END
>
> ...
>
> ELSE
> BEGIN
> SET @numPhotos = 0
> END
>
> FROM cdmdatafeed
In SQL it would be:
SELECT
ID,
Eric,
So it's being saved in the DB as a sqaure box symboldoes it output as a single quote (i.e. select it and cfoutput it). I haven't worked with Access in so longcan't quite recall what it does with single quotes
- Original Message -
From: Eric Creese
To: CF-Talk
Sent
touche! ;-)
- Original Message -
From: Calvin Ward
To: CF-Talk
Sent: Thursday, October 16, 2003 2:32 PM
Subject: Re: Dumb Question
I might try a variation of this...
Do this thing...
- Calvin
- Original Message -
From: [EMAIL PROTECTED]
I might try a variation of this...
Do this thing...
- Calvin
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Thursday, October 16, 2003 5:09 PM
Subject: RE: Dumb Question
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
S
i know nothing about xml so any help would be appriciated
im making a slideshow in flash that draws the images out of a folder and
is read by an xml file to import them into flash
flash needs to read the xml file which i just have as slides.xml
the xml looks like this
Picture Description.
P
Stop teasing me you bastards! I can't go! ;^)
Jim Davis
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 12:48 PM
To: CF-Talk
Subject: RE: Web Services for MX
http://www.macromedia.com/macromedia/conference/sessions/ss201h.html
-
Should I do a replace before submitting?
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:36 PM
To: CF-Talk
Subject: Re: One more dumb question
what database?
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: T
Access
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:36 PM
To: CF-Talk
Subject: Re: One more dumb question
what database?
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Thursday, October 16, 2003 2:30 PM
I have a csv file that I am importing into an existing db. Contained within
the data are 6 fields, imageurl1 - imageurl6. I need to insert the data into
my dabase and store the number of images associated with the record. Right
now I have the below but am getting errors:
DECLARE @numPhotos int
SET
what database?
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Thursday, October 16, 2003 2:30 PM
Subject: One more dumb question
I am passing from a form a textarea field that has word like home's, they'll. I have not had problems with this before but I am experien
I am passing from a form a textarea field that has word like home's, they'll. I have not had problems with this before but I am experiencing issues with the single quote being saved as a Square.
Any help would be appreciated.
My condolences to all you Cubie fans, I was pulling for your team even
> Example:
>
Would cfwitch do this better? - depending on exactly what you're trying
to do
--
Les Mizzell
-
Mihi placent, O Pincerna!
Virent ova! Viret perna!
Dapem posthac non arcebo.
Gratum tibi me praebebo.
[Todays Threads]
[This Message]
[Subsc
not for me :)
im not the one lookin, it was , david delbridge.
and don't mind jochem, I think that's just his brand of humor.
although not very funny sometimes, its just jochem, and we deal.
he is a db wizard.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[E
or to make it a bit more legible...
charlie
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Thursday, October 16, 2003 2:06 PM
Subject: Dumb Question
I have a dumb question. when using CFIF I want to check against multiple criteria.
Example:
I get an e
mayo wrote:
> Troubleshooting
>
> 1. see if simple queries (one table) work -- they do
> 2. take out the WHERE clause to make certain the join works -- it does
>
> The error is with the date as the WHERE clause works with other fields
>
> Can there be a date v date/time issue?
Yes.
> If so ho
THANKS EVERYONE!
-Original Message-
From: Eric Creese
Sent: Thursday, October 16, 2003 4:07 PM
To: CF-Talk
Subject: Dumb Question
I have a dumb question. when using CFIF I want to check against multiple criteria.
Example:
I get an error when doing this. can some post the correct way t
YOu have to have complete boolean expressions between the OR and AND
operators. So you want this:
'contact'>
cheers,
barneyb
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:07 PM
To: CF-Talk
Subject: Dumb Question
I have a d
OR
Cheers
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Thursday, October 16, 2003 2:06 PM
Subject: Dumb Question
I have a dumb question. when using CFIF I want to check against multiple criteria.
Example:
I get an error when doing this. can some p
Probably something like
'contact'>
Thanks,
CC
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
You must have a complete comparison for each - ie -
this may be easier to read
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:07 PM
To: CF-Talk
Subject: Dumb Question
I have a dumb question. when using CFIF I want to check against multiple criteria.
Example:
I get an error when doing this. can some post the corr
I have a dumb question. when using CFIF I want to check against multiple criteria.
Example:
I get an error when doing this. can some post the correct way to do this.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Benjamin S. Rogers wrote:
>>Sure. I would use:
>>
>>SELECT *
>>FROM SourceIPSpamCount
>>ORDER BY SourceIP
>>
>>But I don't use MS SQL Server ;-)
>
> I'm afraid that comment was lost on me? If you could give me a bit more
> information, perhaps I could come up with an equivalent in SQL
CF-Pros:
Are there any issues with using Ray Camden's FileRead UDF inside a loop ?
In the code (slightly modified from original version) appended below, I'm
using the "CF_DIRECTORYLIST_ENHANCED" custom tag to collect directory
information, and then want to search each individual file name returne
Here's the start of some code that would do it. You'd need to make a
function out of it.
declare @test varchar(50)
declare @pos1 tinyint
declare @pos2 tinyint
declare @Oct1 char(3)
declare @Oct2 char(3)
declare @Oct3 char(3)
declare @Oct4 char(3)
SET @test = '2.3.125.105'
SET @pos1 = 1
SET @pos
> that doesn't work perfectly.
>
> 166.141.22.4
> 166.141.22.40
> 166.141.22.41
> 166.141.22.47
> 166.141.22.48
> 166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.',
> Sure. I would use:
>
> SELECT *
> FROM SourceIPSpamCount
> ORDER BY SourceIP
>
> But I don't use MS SQL Server ;-)
I'm afraid that comment was lost on me? If you could give me a bit more
information, perhaps I could come up with an equivalent in SQL Server
for Tony.
Benjamin S. Ro
Set up directories not to allow any execution of files (an exe file)
- Original Message -
From: Ray Bujarski
To: CF-Talk
Sent: Thursday, October 16, 2003 12:35 PM
Subject: Scanned uploading
We have an application we would like to open up to the public with the
ability to u
Troubleshooting
1. see if simple queries (one table) work -- they do
2. take out the WHERE clause to make certain the join works -- it does
The error is with the date as the WHERE clause works with other fields
Can there be a date v date/time issue?
If so how to determine it?
I'm inputting dat
I'm a newbie as well...
1. a new mandrake just came out, i hear that's good. I always stick with
redhat because it's popular.
2. ... for dummies series is a great start.
3. partition your drives in half, install XP, then linux. Choose to install
a boot manager like grep when you install linux. Y
I'm using VK2 spider (bundled with the old CF5) to crawl a Web site.
Some indexed CFM pages are returning titles, while others are not.
I've painstakingly compared "view-source" code from pages that do have
titles in the index, and those that don't: I can't find *any* common
element(s) in the code
Benjamin S. Rogers wrote:
> Stripped this out of a DNSBL we run (the DNSBL actually reverses the
> order of octets in an IP address). This code should work, though I
> imagine there's a prettier way to do it.
Sure. I would use:
SELECT *
FROM SourceIPSpamCount
ORDER BY SourceIP
But I
that doesn't work perfectly.
166.141.22.4
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
166.141.22.5
is wrong.
that should be
166.141.22.4
166.141.22.5
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.nav
I want to get in to linux... got 3 questions
1. What distro is best?
2. Any one recomend a good book on beginning with Linux?
3. Also, how can I dual boot it with WinXP Pro?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Stripped this out of a DNSBL we run (the DNSBL actually reverses the
order of octets in an IP address). This code should work, though I
imagine there's a prettier way to do it.
SELECT *
FROM SourceIPSpamCount
ORDER BY
SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1),
SUBSTRING(SourceIP, CHAR
Hrm, I see the problem. My bad. I looked around on google a bit, but
didn't see any answers beyond using an Oracle Text index on the field.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:07 PM
To: CF-Talk
Subject: Re: Constrain on a
Anyone out there using vcp.exe, part of SecureCRT to do command line
file transfers with cfexecute?
I can get it working just fine from the command line, but cannot get it
to run from a cf page with CFEXECUTE or cfx_SpawnExec?
Thanks,
Scott
[Todays Threads]
[This Message]
[Subscription]
Does anyone know of a Web service anyone that can return geocoded data
in decimal degrees based on a U.S. street address?
Thanks,
M
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Why not fix the IPs in the database to be zero padded for each octet on the way IN?
117.041.145.002
Then sorting is easy.
Just a thought
Jerry Johnson
>>> [EMAIL PROTECTED] 10/16/03 03:44PM >>>
Well, if he _could_ do work after the query and before the display, he
could easily make a structure
that's what I build, the left pad of the octets :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:46 PM
To: CF-Talk
I have a little thingie built (soon to be cfc) that takes an ip address,
strips the .'s out
makes it one big number
166.141.23.1
166.141.23.10
166.141.23.2
166.141.23.20
and then you could order them because they then become
166141023001
166141023002
166141023010
166141023020
so that we can sto
Dave,
> I like Raymond's link, though. I wonder if I couldn't strip the
> punctuation and convert to integer in the query, rather than parse out
> each octet?
>
> Hmmm...
What I'd recommend doing is storing the IP address in integer format in the
database (you can store the IP in octet format a
I stand corrected :-)
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:44 PM
To: CF-Talk
Subject: RE: Sorting IP Addresses
Well, if he _could_ do work after the query and before the display, he
could easily make a structure where the ke
David Delbridge wrote:
> SQL 2000 Server.
That's too bad.
Probably the easiest is to use a function that splits the octets.
Slightly harder a function left-pads the different octets.
Another option would be to convert to an integer (remember that
you need all 32 bits, so a signed INT4 will not
Well, if he _could_ do work after the query and before the display, he
could easily make a structure where the key is the IP and the value is
dec version. Then he could just use structSort to get a list of sorted
keys.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[Us
Remember that the type of join used depends on how your data is organized.
If you have values in one table that do not have corresponding data in the
second table you will probably have to use a LEFT JOIN with Classes being
the table on the left of the join operation, this will return all classe
Then you'd have to figure out how to put the "periods" back in... in the
right places. :-)
-Original Message-
From: David Delbridge [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:34 PM
To: CF-Talk
Subject: Re: Sorting IP Addresses
Thanks, guys. Unfortunately, everything m
Thanks, guys. Unfortunately, everything must happen in the query itself
(or at the SQL server) because I'm using a custom tag which takes a raw
SQL query as input and spits out the results in a particularly-formatted
(and quite attractive) table. Hence, there is not a place for me to
manipulate t
SQL 2000 Server.
Thanks.
Jochem van Dieten wrote:
>
> David Delbridge wrote:
> >
> > I have some lengthy tables filled with IP addresses. Given that the
> IP
> > addresses are contained in a single text field (and not four
> individual
> > octet fields), what would be the SIMPLEST way to sort t
mayo wrote:
> For the following SQL there is no error, I just don't get any records ...
Verify there are actual records present. Easiest way is to change
your inner join to a full outer join and see what happens.
> NOT TRUE, and maybe significant -- I only get the first record in the
> classes t
>I've seen this question before and the answer, but I couldn't find it
>anywhere. Here's what I can remember.
>
>The problem is that the MapPoint WSDL defines multiple services. While
>this
>is a perfectly valid thing to do, AXIS doesn't support multiple service
>definitions in a single WSDL. T
That's funny, I almost bought Ray the barbie that was previosly listed.
-Original Message-
From: Robyn Follen [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:08 PM
To: CF-Talk
Subject: RE: number of occurrences in a string.
Heh... looked at this and thought... Wow!
Thanks for the info Sam. The namespace declaration was a little
different so Office XP and up weren't opening it although Office 2000
would open it now problem. Everything works now though.
marlon
[EMAIL PROTECTED]
Samuel Neff wrote:
> You can specify what view to open Word in with a littl
mayo wrote:
> I have a join that's not working:
What is the error message?
Jochem
For the following SQL there is no error, I just don't get any records ...
NOT TRUE, and maybe significant -- I only get the first record in the
classes table on days when that entry exists. !?! (I'm doing an
quer
David Delbridge wrote:
>
> I have some lengthy tables filled with IP addresses. Given that the IP
> addresses are contained in a single text field (and not four individual
> octet fields), what would be the SIMPLEST way to sort those IPs in a SQL
> query?
What database?
Jochem
[Todays Thread
It should be.
> Would this help?
>
> http://www.cflib.org/udf.cfm?ID=946
>
> I'm not sure if the dec rep of the IP will be in the same order though.
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Probably easier to split into octets first, and then use those. You'll have
to split them anyway to do the sorting, so better to do it once, rather than
as part of each query.
-Original Message-
From: David Delbridge [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 12:06 PM
This is getting odd, but I noticed the same thing. I went to a blog,
noticed the guy had his wish list, and when I clicked on it, I saw mine
as well. Is there something special about Amazon wish lists?
Sorry for the OT crap folks, I'll try to make up for it with a good blog
post later today. :)
Would this help?
http://www.cflib.org/udf.cfm?ID=946
I'm not sure if the dec rep of the IP will be in the same order though.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
There are 2 ways I can think of. The first is to get the IPs and then write
an IPSort() function to do the sorting for you post query. The second is to
have SQL parse each IP part into it's own var and sort on each of the vars.
Ugly as sin, but
> Hi all,
>
> I have some lengthy tables filled w
mayo wrote:
> I have a join that's not working:
What is the error message?
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Heh... looked at this and thought... Wow! This guy wants all the same stuff
that I want!
I suppose that since it WAS my list, it makes a little sense. Looks like
this is the link to yours:
http://www.amazon.com/exec/obidos/registry/2TCL1D08EZEYE/ref=wl_s_3/103-9347
519-1760600
7519-17606
Hi all,
I have some lengthy tables filled with IP addresses. Given that the IP
addresses are contained in a single text field (and not four individual
octet fields), what would be the SIMPLEST way to sort those IPs in a SQL
query?
For example, 'SELECT IP FROM IP_TABLE ORDER BY IP' produces the
f
1 - 100 of 224 matches
Mail list logo