Hey all,
Is there a way to take a word file and run it through some sorta funky cold
fusion thing and insert the text into a database? and then loop it so it
will do a collection of documents (I guess that one is sorta wishful
thinking)
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives
Have you tried using Verity collections?
They can build a text index of a large range of document tyoes including MS
Word.
Cheers
Pete
-Original Message-
From: Mark Smeets [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 06:03
To: CF-Talk
Subject: word files and databases
Hey all,
I
Take a look at the code in the following link:
http://www.cfcomet.com/cfcomet/Word/index.cfm?ArticleID=54E12395-5696-11D3-B
3E8004033E03EF9
(warning to wrap)
I hope I understood...
Have a nice day
Gianluca Pinelli (Italy ;
- Original Message -
From: "Mark Smeets" <[EMAIL PROTEC
Is there a way to use cfquery connect to MSSQL without ODBC?
Thanks.
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pen
All,
I'm trying to ensure only one user can run a block of code at a given
moment, putting off any others for a moment until that user's operation
is done. There's not much chance a conflict will arise, but I'd like to
make sure.
Will this code do the trick? At 2am my thinking is even cloudier
DirectLoad can do this directly from your client box.
http://www.flymicro.com/cf/directload
Mark Smeets wrote:
>
> Hey all,
>
> Is there a way to take a word file and run it through some sorta funky cold
> fusion thing and insert the text into a database? and then loop it so it
> will do a co
Try with OLEDB it is like ODBC but more fast.
Let me now ;-)
Gianluca Pinelli
- Original Message -
From: "Rudy Rustam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 10:50 AM
Subject: CFQUERY connect to MSSQL
> Is there a way to use cfquery co
There are various email to sms and email to fax gateways you could use.
My (home) isp has a free email to fax gateway (has advertising).
http://www.deltica.com offers email to sms.
HTH,
Ian
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2002 15:53
>
>
> ..stuff goes here...
>
>
..seems to work correctly...and it should work the way you wish..
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/M
Can anybody advise me what is the best/simplest way of converting a SQL
Server database to Access in the following instance.
My user needs to be able to just go to the website click on a button and
the database needs to be converted.
Then the user can just download the Access db and analyse it w
Hi,
We have developed a CFX tag for coldfusion for ftp upload and
download. Our main reason for developing it was for speed, the
coldfusion cfftp putfile and getfile are too slow.
As an example, the cfftp tag taks 7-9 seconds to upload a file while our
tag takes 1-2 seconds (ftp to same server,
Can CF handle LOB and BLOB object types?
For example, how do I use CF to send and retrieve LOB's to an
oracle/postgreSQL database?
Cheers,
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Wednesday, January 09, 2002, 8:48:26 AM
Hello cf-talk,
I've just dumped my CFSERVER 4.5 for the new "developers edition"
5.0 server trial.
Everything installs fine, but where did Server Administrator go? I
don't have a link to get to the administrator control panel in my
start up menu
In general, there's no need to lock cfdirectory, unless you're creating,
deleting or renaming. As for the name of the lock, just make sure it's
unique for that particular operation. That is, if you're using
cfdirectory in a couple different places that access the same directory
structure, I would
A few things that we do:
On images, we Use Flash 5 to create a mouse over with text from our
legal
department, and we have also disabled printing of the Flash Movie. We
do
that by:
"If you don't want any frames in the main Timeline to be printable, you
label a frame as !#p to make it nonprinta
My suggestion would be to go to
http://www.cfcomet.com/cfcomet/sql_server/ - the first article is about
exactly what you're trying to do.
Mark
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 6:08 AM
To: CF-Talk
Subject: RE: Using a DTS
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=f
a
x
Mark
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:53 AM
To: CF-Talk
Subject: OT: Fax notification
Hey All,
I'm looking for a solution(s) for sending f
Have you tried ipAddresss/cfide/administrator/
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 12:53 AM
To: CF-Talk
Subject: Where is CF Administrator?
Wednesday, January 09, 2002, 8:48:26 AM
Hello cf-talk,
I've just dumped my CFSERVE
If I understand you correctly, once a user has logged in, you don't want
them to click on the IE icon or Nutscrape and go to your site and log in
again? If this is right, just capture their IP on login. When the next
user logs in, make sure that the IP's aren't the same.
This will work to prevent
Ok, I'm using code from CFCOMET, to turn a HTML page into a DOC and then
print it. The trouble is, it keeps giving me a "Can not Print. No printer
found." Message. Even if I specify an active printer. It should just use the
default. Does any body have any experience with this? This is all taking
_
Nobody has mentioned the MEDIA element of a LINK tag
If you have two links to style sheets thus:
by simply styling the text as very small, same colour as the background
and invisible in the MEDIA="PRINT" style sheet will flummox most
people. Won't of course stop ctrl-c
Certainly works in
hello,
i have pb with cf session variables.
i have created two numeric session variables in cf (the site is in cf) that
i need in a cgi script wich launch an api. but these variables seem not to
be recognized by the cgi script. with an asp example that i have there is no
pb.
in cf i have created
This is what I do, and it seems to work quite well. My standard procedure
for forms is roughly as follows and it is the most efficient way I have
found to do forms:
The dsp_Message.cfm file displays any error message. I use
Dave,
The project I am currently engaged in ran into this problem a couple of
months ago. Due to the dynamic manner in which data is placed in the
database (since the project has gone through several teams), JavaScript
was
used to catch "double-clicking" of submit buttons. I will say, that wh
Session variables in CF are not automatically passed along to either CGI
or
ASP scripts. ASP scripts in particular have a "Session" scope, but that
does not connect to CF's Session scope at all. If the script needs any C
F
session variables, then you need to manually pass them along when your c
That looks like it, James. Thank you.
I went back through my logs and found many examples where an error caused t
wo entries in the application.log: the Oracle error (from the native driver
, I assume) and the same error but from a CFML point-of-view (error templat
e's name, browser type, etc.)
I've built some survey apps that set a cookie when the user submits the
form. Then, if they try to submit again, it will not accept the submissi
on.
However, the cookies are set to die when the browser is closed, so if the
user comes back in, they can submit again. You could set the cookie to l
Just another thing to add, I used to generally used the cflocation approach
to redirect the user to a confirmation page. However after comparing this
with the other option (checking if the record exists in the database) I
realised there is a noticeable delay with using the cflocation approach
whil
My only work with databases is through ColdFusion, largely
Access.
In designing the tables, Access forces you to define a Primary
Key, but I've only ever used the Relationships view where
you define the actual relationships for visualisation purposes.
Most of the sites I've done have been relativ
"Can" you design your database with no primary keys? Yes, you can. Do I
recommend this, even on the smallest of databases? Absolutely not! It's
my opinion that if you're going to do something, do it right all the
time. Get in the habit of doing things the best way possible, even if it
takes you a
Dimo:
Your problem is the 18 nested tables you use to display the page. Netscape
parses tables from the innermost to the outermost, and will not render the
page until ALL of the tables have been parsed. To get your page to load
faster in Netscape, reduce the number of NESTED tables you are usin
I installed CF and Apache on a 98 machine and get the following message in
Apache error log:
[Wed Jan 09 00:36:57 2002] [error] Cannot remove module mod_coldfusion.c:
not found in module list
Any advice?
Jeff
_
Get your FREE do
Are you sure that the "relationships" are only used in the Access GUI? My
understanding is that they were true constraints.
I'd recommending building your schemas the "right" way - for "practice" sake
and for future robustness of those applications.
- Original Message -
From: "Gyrus" <[
Thanks Christian:
I thought the problem could be somewhere along this line, but wasn't
sure, since IE and NN 6.2 process the page with a normal speed. I'll try
to decrease the number of tables... geez, 18 tables... did I really need
that many of them? :)
Cheers,
Dimo
Christian Abad wrote:
>
there is a place in the config file...I am assuming you are running 98 or
ME? I had the same problem under ME.add in the following:
# module mod_coldfusion.c
well something like that..use the same wording as what you see and it sho
uld
work.
Tammy
-Original Message-
From: Jeff Reilly [m
yes yes yes primary and foreign keys are essential to data integrity ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macrome
I have this happen as well but in NS 4.06. I can tell you that NS renders tables much
slower than
IE (when there is a lot of tables anyways), but I suspect there is more to it than
that.
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e.
Bizarre - went to fusebox.org, and for a few minutes, received one of
those stupid "domain for sale" pages (you know, with the cheesy 'click
and make me money' wanna-be portals). Everything appears to be ok now.
__
Why Share?
On a new project, I need to choose a good DHTML menu system. The one I
like is Hiermenus (http://www.webreference.com/dhtml). The one my team
lead likes is the one that Fireworks auto generates. I'm wondering what
you all like. Have I missed other, better DHTML menus?
Thanks :)
I am in a need of a free and quick tool for real-time statistics for a
test version of a site. Can I get several recommendations what you guys
are using?
I'd prefer to go with one that does not require a banner or an image,
but since it is a test site, this is not that strict.
Thanks in advan
Check out http://www.zdnet.com/downloads/stories/info/0,10615,36011,00.html
Dan Phillips
CFXHosting.com
-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:43 AM
To: CF-Talk
Subject: Web statistics
I am in a need of a free and quick
> Are you sure that the "relationships" are only used in the Access GUI? My
> understanding is that they were true constraints.
You're right, I believe - only I've never had a single problem
so far with not defining them inside the DB (apart from PK's,
which Access forces, and I've got into the
If cost is an issue for you then the decision may already be made. Following
a post here on the topic I checked with the creators of Hiermenu and was
advised that a license for EDU use was $650/per site.
Needless to say, that script has been removed from the site.
Ken
-Original Message--
On Wed, 9 Jan 2002 09:15:28 -0500, Mark Stewart <[EMAIL PROTECTED]>
wrote:
>If I understand you correctly, once a user has logged in, you don't want
>them to click on the IE icon or Nutscrape and go to your site and log in
>again? If this is right, just capture their IP on login. When the next
>u
I've had fantastic success with AllWebMenus (http://www.likno.com/)
Highly recommended.
Erika
-
Erika L. Walker-Arnold, VP, RUWebby, LLC
http://www.ruwebby.com
55 Tunstall Road
Croydon, Surrey, United Kingdom CRO 6TY
-
Greetings list,
I had a working call to cfhttp w/ resolveurl set to true. The target is a
data/graphing collector in our intranet. The CF template grabbed the page
and I redisplayed it with the images (which live in the same web dir)
without a problem.
Now for some reason the image links are
Gyrus,
A well-designed normalized relational database will require you to use
less code to produce the results you want in your web application. The
process of normalizing a database design is intended to eliminate data
redundancy and deletion/addition anomalies. Your question about
constrain
Javascript, but I really like http://milonic.co.uk/menu/
I have built a CF wrapper for this which builds dynamic cascading menus
of unlimited depth, contact me off list if you are interested.
Eric Carlisle wrote:
>
> On a new project, I need to choose a good DHTML menu system. The one I
> lik
Well here is my thought. As far as my DB is concerned I fully use
creating a pri key and foreign key relationships where needed on all my
tables. This helps so much in avoiding someone delteting something from
one table that relies on something in another table. Another reason for
doing this i
MS SQL's DTS supports various scripting languages that would be able to
handle copying today's log to a standard file name that gets overwritten
everyday. That way, the file name (and text datasource) can remain the same
and the script handles the file name issues. We're doing something similar
to
At 03:31 PM 01/09/2002 +, you wrote:
>My only work with databases is through ColdFusion, largely
>Access.
>
>In designing the tables, Access forces you to define a Primary
>Key, but I've only ever used the Relationships view where
>you define the actual relationships for visualisation purposes
> Well here is my thought. As far as my DB is concerned I fully use
> creating a pri key and foreign key relationships where needed on all my
> tables. This helps so much in avoiding someone delteting something from
> one table that relies on something in another table.
As I said, I do rigorou
What is the determining factor whether you need a Mapping for your
application or not? Is it necessary for the app to work?
James
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Inst
Howdy all. I'm in need of a database that would have a news event for
every day from 1900 thru today. Any ideas on where such a beast
exists? The client is certainly willing to pay rather than populating
it himself.
Thanks. Sorry for the OT post.
--
Bud Schneehagen - Tropical Web Creations
Well if someone attempted that, they would get a primary key contraint
violation. This is not a very friendy error message, but you can always
create your own error template to be defined in CF Admin and make it
alot more friendly to the user. It would look like so without a user
friendly temp
At 05:49 PM 01/09/2002 +, you wrote:
> > Well here is my thought. As far as my DB is concerned I fully use
> > creating a pri key and foreign key relationships where needed on all my
> > tables. This helps so much in avoiding someone delteting something from
> > one table that relies on someth
Whether or not you wish to use mappings in your application. You'd use them
in CFInclude and CFModule
- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 11:53 AM
Subject: CF Mappings
> What is the determinin
not sure if this will help.. but certainly some people and site that might
be able to turn you onto a product..
http://search-intl.netscape.com/Society/History/On_This_Day_In_History
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 13:04
To: CF-Ta
You could contact some of the sites that have this functionality and see if
they'd sell. Do a search for "on this day" (keep the quotes) in Yahoo or
Google. You'll get results for sites like http://www.on-this-day.com/
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <
You're right, not defining the relationships won't cause anything to crash,
but can compromise the integrity of your database
- Original Message -
From: "Gyrus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 10:52 AM
Subject: Re: Defining internal
Hi,
It should be located at http://YourWebServer/cfide/administrator/.
HTH
Mike
> -Original Message-
> Everything installs fine, but where did Server Administrator go? I
> don't have a link to get to the administrator control panel in my
> start up menu anymore!
_
There would be an error, but IMHO, *this is a good thing* - during
development, it would illustrate an area where data integrity was being
violated, and allow you to fix the problem (cascading deletes through
triggers, or done manually through cfml)
- Original Message -
From: "Gyrus" <[EM
Mostly if you need access to files or templates from CFINCLUDE and CFMODULE
that are not accessible to CF through a relative path. Both tags use
relative addressing to specify files, so you might have a situation where
you can't get to a file using a relative path. For example, when you have
fil
On that note, is it possible to declare mappings dynamically (from
Application.cfm I'd imagine), without using the CF Admin interface?
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:11 AM
To: CF-Talk
Subject: Re: CF Mappings
Whet
It can make some things easier. For instance, the webroot map will allow
you to locate files relative to the root, making it easier to use modular
code from different directories. You can also set up mappings to store
design elements, so if you ever want to change design you can change the
des
hmmm, ok. my question came about because i have two apps right now on CF 4.5
running on NT server. One works just fine, it has a mapping which I did not
know of until today since I did not set it up. The second one i have does
not. I get the error:
I have the same webroot for each site, it is on the D: drive.
-Original Message-
From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 1:34 PM
To: CF-Talk
Subject: Re: CF Mappings
It can make some things easier. For instance, the webroot map will allow
you t
No, there is no need to set up a mapping (though the error message seems to
indicate it). Mappings are more or less for convenience sake - you can
point to a file without a mapping (using the relative path)
Your error indicates that the file doesn't exist.
- Original Message -
From: "Ja
Has anyone written a simple "media library" application that they would be
willing to share?
All it needs is a client login to view and download their own media files
(all audio) and a backend to upload media files on a per client basis. It
needs to be MS Access based - no SQL Server or better a
HierMenus is the best I've seen, and people think its still free.
Unfortunately its not, although the notices given on this are very
vague, IMHO. I was told by an internet.com rep over the phone that they
want (retroactively -- enforced by attorneys) $500-$1,495 for
single-site use.
Dynamic Driv
It should be
/cfide/administrator/index.cfm
Anthony
> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 09, 2002 8:53 AM
> To: CF-Talk
> Subject: Where is CF Administrator?
>
>
> Wednesday, January 09, 2002, 8:48:26 AM
> Hello cf-talk,
>
>
I know you're probably getting a lot of information here, but...
Why add extra code to your app when you can let the db do it's job. I'm
a firm believer in letting the different parts of an application (i.e.
db, cf, com, java, etc.) do it's particular job that it was intended to
do. In addition,
yes, i agree with you. The thing is, the files do exist. It works fine on my
local CF server.
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 1:48 PM
To: CF-Talk
Subject: Re: CF Mappings
No, there is no need to set up a mapping (though
Couldn't help but chuckle when I saw this on the Developer's Exchange.
A web based project management system that competes with SiteSpring -
seems like the product name similarity could cause Macromedia's lawyers
to use someone's head as a trampoline. :-)
___
I use them specifically for cfincludes. Instead of referencing a
template path as ../dir/dir/filename.cfm, you can reference it as
/mapping/dir/dir/filename.cfm - much cleaner
Mark
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 12:54 P
Hi,
Does anyone know if there is a way (using cf) to check where users are from?
(like country)I know you can do this with a program like web trends but I
wonder if there is a more practical way to do this. (run a traceroute dos
command via cf perhaps?)
--
Mar
Good point and probably a little bit more cleaner.
Mark
-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:55 AM
To: CF-Talk
Subject: Re: how to prevent user from opening multiple browsers..
On Wed, 9 Jan 2002 09:15:28 -0500, Mark St
> Does anyone know if there is a way (using cf) to check where users are
from?
> (like country)I know you can do this with a program like web trends but I
> wonder if there is a more practical way to do this. (run a traceroute dos
> command via cf perhaps?)
not exactly cf but www.geobutton.com wo
Thanks for the great responses! :) I'm looking into the alternatives
posted here. I'm assuming that the licencing for the DHTML meuns
generated by Fireworks are included in the licence for Fireworks.
EC
__
Why Share?
I am curious to know who CF Developers use for
online credit card processing?
I was looking over PayPal and LinkPoint. What
are some of the others and basically what is the
cost?
I know with PayPal is can be as low as 2.2% and
$ .30 per transaction.
Thanks in advance
Randy
___
comment out mod_coldfusion.c in your .conf file
On Wed, 9 Jan 2002, Jeff Reilly wrote:
> I installed CF and Apache on a 98 machine and get the following message i
n
> Apache error log:
>
> [Wed Jan 09 00:36:57 2002] [error] Cannot remove module mod_coldfusion.c:
> not found in module list
>
Hi,
I am trying to add the values from a second query to my first query but for
some reason it is setting all rows to the first value of the query. Can
someone tell me what I did wrong? TIA.
Tammy
_
Um, got a bigger problem right now. I accidentally changed the webroot
mapping in the administrator, oops. Now, I can't access the administrator.
Is there anyway to restore it without reloading CF?
-Original Message-
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January
Does anyone know of a better way to deploy a project than ColdFusion's
Project Deployment? Not sure if it is just me, but I have always found
ColdFusion's project deployment to be rather slow, and it doesn't delete old
files and directories off the server that don't exist in the project
anymore.
Tammy,
First, use "arrayResize( )" to kill the first loop code:
Then, use the query array syntax to grab the data you want from the second
(offlineApps) query ... like so:
CFLOOP query="qryGetOnlineApps">
Of course I'm assuming that the second query has at leas as many rows as the
I got it. Must of been the last one for the day to get it. If you want
it
let me know and I will email you a copy 30.4kb
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 9:44 AM
To: CF-Talk
Subject: RE: Better Javascript/DHTML Calender!
I use the synchronize utility built into WS-FTP Pro. I don't have the
knowledge to compare it to CF Studio's built in functionality (Never used
it).
At 02:02 PM 01/09/2002 -0600, you wrote:
>Does anyone know of a better way to deploy a project than ColdFusion's
>Project Deployment? Not sure
Of course. Just define a variable that has the target directory and call
the path with #variable# where the path is supposed to go. I suggest the
request scope for such a variable, since you don't have to worry about
locking it.
At 11:30 AM 1/9/02 -0700, you wrote:
>On that note, is it possibl
Ouch.
This is not something you want to do...
Query results should be joined using the UNION operator in SQL. Many
people
don't realize that you can hard-code query columns to aid in this
effort
like so...
SELECT appID, appName, '1' AS isOnline
FROM apps
WHERE whatever IS NOT NULL
UNION
SELE
I'm using "http://foo.pdf " and I'm having trouble getting a
PDF or Doc to load in a modal dialog box.
Is this possible; am I beating my head against a wall. If so, how can I
achieve the same type of thing some other way? I need the minimize button to
be disabled, and really like how the user ca
i would like, y not just attatch it to you next e-mail
- Original Message -
From: "ronmyers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 3:12 PM
Subject: RE: Better Javascript/DHTML Calender!
> I got it. Must of been the last one for the day t
I need to read the contents of a comma or tab
delimited .txt file, and have the contents placed in
the appropriate fields in a database. For example,
the text file will look like:
Course name
1 First person
2 second person
3 third person
etc.
The database will have a "course_name" field, and a
Is cftransaction only to be used with queries or can you use it in
conjunction with other things? I'm inserting data into the database and
then emailing that data to a client but I don't want the insert to occur
if the e-mail fails and I don't want the e-mail to be sent if the insert
fails.
In short..no it's not meant for what you're doing.
Try this for the sending mail if insert flys:
1) after insert..do a SELECT to determine if the new record is in the DB (mabye just
by determining
if insert query exists)
2) If the new record is there..send your mail.
Now as far as not inserti
Gotcha. I thought it might be a poor man's solution for error control.
The more I think about it, the less sense it makes.
Thanks Bryan
Michael Corrigan
Programmer
Endora Digital Solutions
1900 S. Highland Avenue, Suite 200
Lombard, IL 60148
630/627-5200 x-136
630/627-5255 Fax
- Ori
Is it possible to sort multi-dimensional arrays? I have a two dimensional
array and want to sort by the first "column".
Array name is "foo":
foo[1][1] = "b"
foo[1][2] = "1"
foo[2][1] = "a"
foo[2][2] = "2"
So in this case I want to sort the first "column" (alpha characters "b & a"
alphabeticall
What luck have you had with ArraySort(foo, text)?
Michael Corrigan
Programmer
Endora Digital Solutions
1900 S. Highland Avenue, Suite 200
Lombard, IL 60148
630/627-5200 x-136
630/627-5255 Fax
- Original Message -
From: Matt Kornguth
To: CF-Talk
Sent: Wednesday, January 09, 2002
Well I sort of got what you are trying to explain. I created a UNION SQL
statement and it is giving me the correct recordcount.
SELECT DeptName, Count(*)
FROM TableName
WHERE IsOnline = 1
GROUP BY DeptName
UNION ALL
SELECT DeptName, Count(*)
FROM TableName
WHERE IsOnline = 0
GROUP BY DeptName
O
You try...
http://www.cflib.org/udf.cfm?ID=390
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
Does anyone know if verity indexes text within html comments
thanks,
phillip
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyh
1 - 100 of 144 matches
Mail list logo
