> ESRI/Eagle Technology donated ArcView for producing the maps. ARCIMS
Server
> is an option but it requires high bandwidth and IE5. We need a simpler
> solution to cater for conservationists with old browsers/pcs and slow
> modems.
my shop like yours is a not-for-profit environment organization
Jim,
Don't know what DB you're using, but I implemented the following for a similar
situation once. This works with MS SQL Server.
SET NOCOUNT ON
UPDATE ListStats
SET Hits = MsgsIn + 1
WHERE ListI
Doesn't oracle support @@identity?
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 3 January 2002 3:19 PM
To: CF-Talk
Subject: Re: Database AutoNum column
Not directly. But you can create a SEQUENCE. Then you use the value from
that sequence in your
Not directly. But you can create a SEQUENCE. Then you use the value from
that sequence in your query:
INSERT INTO table
(pk,value,value)
VALUES
(sequencename.nextval,'value','value')
(What I DON'T know how to do is use that same value in subsequent queries
without selecting it from the table I j
Hi Dave
That seems a very workable solution. We have 2 sites. The main site is
50,000 static pages plus images. The coldfusion site and database back ends
it within frames and is totally dynamic. I guess the CF site can mine the
static one for maps with the system you suggest.
Thanks
Mike
--
Thanks Len for your suggestion
We will still use ArcIMS accessed via a password area for community groups
to change their maps. This will be hosted elsewhere. ESRI has been helping
us out so would be a bit opportunist to "jump ship".
The maps will be batch generated and stored as static jpeg fil
Hi guys
Is there an autonum feature in oracle 8i, if so how do I define it?
Thanks
Sam
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Set
>NZERN (a volunteer non-profit environmental group) needs to display several
>thousand maps as jpg files on a coldfusion site. The users need to be able
>to move from one map to the next by up/down left/right nav keys. Also zoom
>in/out. Anyone got any insites into how to approach this task.
We h
You can give each map an X,Y coordinate number. Have a table with MAPID,
XCord, YCord and FileName as the columns. Then, you can surround each map
with links to the adjoining X,Y coords, hit the database to get the file
names. You can populate the links dynamically using whatever sequencing
met
Thanks Bryan
Mike
-
Bryan Lentz" <[EMAIL PROTECTED]>
-
Hi,
Peak Geodesign has great mapping software with a very reasonable cost
.compared
to most other mapping programs. It is pretty fast and has in the past worked
> > Not to mention access to JSP tag and libraries (and other
> > Java bits), native XML support, the ability to access and
> > publish Web services, a brand new (and dramatically improved)
> > editor, and the list goes on and on.
>
> What web services do you mean here? Stuff based on SOAP? Wi
Thanks that did it exactly as needed!
Neil
- Original Message -
From: "Ron Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 8:43 PM
Subject: RE: Machine Name
> Don't know if you would consider this SIMPLE, but here's what I use:
>
> act
> Is there a server variable or a SIMPLE way to get the machine
> name?
If you just mean the fully-qualified host and domain name (for example:
www.mysite.com) that the user typed in, there are CGI variables for that:
CGI.SERVER_NAME, and perhaps CGI.HTTP_HOST.
If you mean the Windows machine n
Don't know if you would consider this SIMPLE, but here's what I use:
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 5:39 PM
To: CF
Is there a server variable or a SIMPLE way to get the machine name?
Thanks,
Neil
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.penn
Hi Alan, how about setting up a datasource for .XLS?
-Mike
Alan Walker wrote:
> Hello All,
>
> Happy New Year to everyone. Does anyone know of a way to upload an
> excel spreadsheet and loop over the contents of that spreadsheet? I
> know that you can use the read function on cffile but that
Hello All,
Happy New Year to everyone. Does anyone know of a way to upload an
excel spreadsheet and loop over the contents of that spreadsheet? I
know that you can use the read function on cffile but that only works
for text files.I need to upload the spreadsheet and then insert the
data i
Raymond Camden wrote:
>>My subfolder's application file would look like this:
>>
>>CSOnline = "True";
>>
>>
>>
>>Like I said, it seems to work. Any reason not to do this? Thanks!
>>
>
> As long as you are aware that changes to the root app.cfm affect the
> children - I say go for it. I've used t
Hi,
Peak Geodesign has great mapping software with a very reasonable cost
..compared
to most other mapping programs. It is pretty fast and has in the past worked
very well on older PC's
http://www.colorview-peak.com/
Check them out they may be able to Help.
Bryan
-Original Message-
Fr
> Yep, that's another nifty feature of , the
> doesn't catch those errors. Here's what I use:
In my experience CFPOP *does* catch these errors. I've got my to
look for 'bad login' and 'timeout' in the catch message, and that has worked
fine for me. Have you found that this isn't always the c
What I do is move all variables into a separate file (like
inc_globals.cfm or something) and include that in the root
Application.cfm. Then I can include that same file in any custom tags or
sub Application.cfm's.
> I haven't heard of anyone ever doing this, but it seems to work for me, s
o I
> w
Hi Folks
NZERN (a volunteer non-profit environmental group) needs to display several
thousand maps as jpg files on a coldfusion site. The users need to be able
to move from one map to the next by up/down left/right nav keys. Also zoom
in/out. Anyone got any insites into how to approach this task.
Yes please as well
I'd really like to look at your code and see if if it will help get this
system going.
Thanks
Mike Peters
NZERN
Mail: PO Box 9000, Christchurch
(03) 338-5451
E-mail: [EMAIL PROTECTED]
http://www.bush.org.nz
-
You could use an Oracle stored procedure to write out the results to a
file/files on the web server. Then you are just serving files from a web
server--no big deal. You might need to be creative in how you re-assemble
the files, or you might need to map a drive so the web server and your db
server
Yes Jim. You can use the Application scope inside custom tags
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com
- Or
For that matter so is both the FORM and URL scope.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 1:49 PM
To: CF-Talk
Subject: RE: Inheriting Application.cfm?
> Question: Do custom CF tags "see" the parent template's
> application scop
> I'm trying to jump to a specific part of a page using a
> javascript OnChange event but can't seem to find the correct
> syntax. It works without the '#Page2' but I need to jump to
> this portion of the page. Maybe an extra set of eyes will help.
>
> onChange="location.href='Home2.cfm?Folde
> Question: Do custom CF tags "see" the parent template's
> application scope variables? Without testing it, I'm
> guessing the answer is 'No'. How then, would I access
> application variables from a custom tag? Can I do a
> 'caller.application.whatever = something'?
Yes, the Application scop
I'm trying to jump to a specific part of a page using a javascript OnChange
event but can't seem to find the correct syntax.
It works without the '#Page2' but I need to jump to this portion of the
page.
Maybe an extra set of eyes will help.
onChange="location.href='Home2.cfm?Folder='+this.option
>
>Dear Microsoft .NET Passport Member:
>
>Thank you for using Microsoft® .NET Passport. Because Microsoft
recognizes
>the importance of security and reliability when using Internet software,
>we have now made available free browser security upgrades to better
>protect your online information.
Question: Do custom CF tags "see" the parent template's application scope
variables? Without testing it, I'm guessing the answer is 'No'. How then,
would I access application variables from a custom tag? Can I do a
'caller.application.whatever = something'?
Jim
- Original Message -
F
Lucky Verity employees...
They're off until the 7th... I'll know more then.
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
-Original Message-
From: jon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 2:10 PM
To: CF-Talk
Subject: RE: vspider --- help please
I
Yep that should work but I did not see anyway to automate things in the
future using that method or temporarly pointing the sites to port numbers.
I called Verity this morning to find out pricing on the full spider
unfortunately their offices are closed from Dec 24 to Jan 4 (nice
vacation!).
Se
I *may* have found a solution -- it's plugging away right now.
Basically, since the machine's actual IP is 206.239.147.xx I changed IIS to
serve the same site at 206.239.147.xx and www.epilepsyfoundation.org. It's
plugging away like it knows wassup, so apprently that solved the problem. We
shall
Your site must use relative links _and_ be addressable using the Localhost
address.
1) Configure your website so that the below address works...
http://localhost/index.cfm (using IIS just add the 127.0.0.1 IP and use the
Host Header of "Localhost") Localhost is the only address I've been able t
Ouch you just ran into the same problem I did I ended up scrapping the
vspider, may purchase the full blown one. You cannot, that I have found,
get the spider to do its thing on anything but the base IP of the server,
127.0.0.1, localhost, servername, or servername with a port number. The
spi
Ok... the spider is driving me friggin' insane.
The spectrum astro docs were good enough to get me started, but I'll be
darned if I can get it to spider my site.
Here's the issue -- we've got multiple IP addresses on a single machine. I
was able to create the collection alright, but I can't get
Able Commerce's e-comm package is built around just such an approach and it
seems to work well.
Mark
-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 12:32 PM
To: CF-Talk
Subject: Inheriting Application.cfm?
Hi,
I haven't heard of a
Ditto to Ray's comment. I use it all the time and it works great!
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com
> My subfolder's application file would look like this:
>
> CSOnline = "True";
>
>
>
> Like I said, it seems to work. Any reason not to do this? Thanks!
As long as you are aware that changes to the root app.cfm affect the
children - I say go for it. I've used this method multiple times in the
Hi,
I haven't heard of anyone ever doing this, but it seems to work for me, so I
was wondering if it was in some way poor programming or otherwise not
recommended.
I've got an application.cfm file in my root folder, whose properties also
apply to a subfolder since no application.cfm file is in
That's an interesting thought
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 12:03 PM
To: CF-Talk
Subject: Re: Efficient Logging Application
Mark,
I follow you now. Sounds like a very good idea. Use the struct to
parrallel the dat
It will be far more efficient to do the whole query in SQL rather than
creating 2 queries in CF. Let SQL do the work, it is very good at it. I
suspect that you IN clause is causing the Query optimizer to have problems
determining which index to use which is why you are seeing a huge difference
i
Cameron,
Thank you.. thats what I thought it did but the client is saying it sent
him a txt file attachment before and I was like looking at the script and
was like no it outputs in the main body of the message.
but I'm not going to sit there and fight with the client that just goes no
were s
Have you tried hitting that page from the server console (actually logging
into the server and firing up IE or Netscape)? Perhaps it's a DNS issue on
your webserver.
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Mark,
I follow you now. Sounds like a very good idea. Use the struct to
parrallel the database table so that I can avoid checking the table itself
before doing an UPDATE.
I guess your question about StructKeyExists() really gets down to how
structs themselves are implemented in CF and how effi
Really weird but once I moved those text files to a different URL on the
same server, It works??? Anyone know why? Maybe CFhttp doesn't play well
with subdomains?
New file location:
www.careerlearn.org/KrisKart/courses.txt
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Jim,
Yes those are all issues. 10,000 records doesn't seem like too much
(depending on your hardware and how managed your code is) however. My
structure of symbols grows from 0 to around 18,000 routinely throughout the
day. For you, the first time it is built it will be slow, but after that not
> Does it put the results in a tx file or directly into the email??
In the body of the message... Your txt file would look something like this,
and the output would simply replace the placeholders (in brackets) with the
form field data. The first three lines of the txt file actually dictate
Since you are running 5.0 Ben Forta wrote a UDF that uses Java to do the
lookup. I'm pretty sure that Java doesn't have any leaks...
http://www.cflib.org/udf.cfm?id=447
jon
- Original Message -
From: "Craig Fisher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, Ja
Good question. We also run a web log analyzer. There are a couple of
things that a web stats package can't do for us. First, if it's not storing
data in a database that we can query, then we're limited in the types of
queries that we can do, and we're limited to the particular presentation of
t
Ok...
Here is the link to the file:
http://webmaster.wsboces.org/courseinfo/courses.txt
The code is:
http://webmaster.wsboces.org/courseinfo/courses.txt";
method="Get"
delimiter=","
throwonerror="yes"
textqualifier="||"
columns="sname, Catalog_code, Catal
Under idea #2:
Can you make an adjustment to the content production side of the fence,
so when a content producer does a new page insert a corresponding insert
is also done to your log db? That would keep the two tables synch'd and
you'd be down to one query doing UPDATEs.
--Matt Robertson--
MSB
Kris,
I'm getting a 500 Server Error. Is the rest of the site working okay?
Perhaps you could post the code for us to take a look at.
Regards,
--Paul
Paul W. Wille[EMAIL PROTECTED]
--
--
I
Ack even a txt file I mean not a tx.
- Original Message -
From: "Troy Montour" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 1:29 PM
Subject: Re: Sorry was wondering if anyones use this CGI Script
> Cameron,
> Does it put the results in a tx
Craig, in the call or any interactivity to the CFX tag locked? if not I
strongly recommend that it should be.
Mike Brunt
Sempra Energy
213.244.5226
"Smith & Wesson - the original point and click interface."
-Original Message-
From: Craig Fisher [mailto:[EMAIL PROTECTED]]
Sent: Wednesda
ack.. txt file I mean not tx.
- Original Message -
From: "Cameron Childress" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 12:05 PM
Subject: RE: Sorry was wondering if anyones use this CGI Script
> We have a few "legacy" clients using that scrip
All-
I am working with a client who is using the tag CFX_GETHOSTBYADDR. They are
running CF 5.0 on a Windows 2000 box and they are having problems with
memory leaks. I have no particular reason to suspect the tag (in fact we
have much more likely candidates for the leak) but in the interest of
Cameron,
Does it put the results in a tx file or directly into the email??
Troy
- Original Message -
From: "Cameron Childress" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 12:05 PM
Subject: RE: Sorry was wondering if anyones use this CGI Scr
What are any of these homebrew page view scripts performing that can't
be derived from the webserver logs?
Webtrends sells their Log Analyzer for $499. How many development hours
will you spend before you've spent more than $499 of your time? The
reporting functionality of WebTrends should be a
Just 1 error:
The page cannot be displayed
;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com
- Original Message
I AM HAVING AL SORTS OF PROBLEMS WITH CFHTTP...
HTTP://Webmaster.wsboces.org/test.cfm
Refresh the page multiple times and notice a bunch of different error
messages
Notice all the different errors anyone have any idea on how or why this
__
Mark,
That's a possibility. I'd have to evaluate how much memory that might
require. There could easily be 10,000 distinct records. I think I'd either
need to just keep only a day's worth of data within this application
structure, or else write it out periodically to disk, just in case the CF
Yes. It comes with ColdFusion. You can also download the SDK as well as many many
examples from www.intrafoundation.com
HTH,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Serve
Outlook 2000 .pst, exported to Access then sql on the
'from email' address. Some people have more than one
email address and more than one exact name.
Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health
Center for Information Technology
Division of Computer System Services
--
Is there a SDK for creating custom tags with C++?
Thanks,
Jaye Morris
[EMAIL PROTECTED]
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Set
Not quite, but I've fired up Enterprise Manager (on remote machine) for SQL
Server 7/2000 and had that toast the server and force reboot...w ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
--
Jim
I do the following to keep track of hits, monthly to my web pages:
I have a table to hold the current monthly web pages info and an
identical historical table.
I call a tag that checks to see if the page is already in the table
if not it creates a record with hits=1
Has anyone experienced a CF Application Server lose the
ODBC connections to a native box and reboot itself?
Any ideas?
Randy Adkins
Tech Lead - Novient
SRA International
[EMAIL PROTECTED]
(703) 803-1677
__
Why Sha
Yep, that's another nifty feature of , the
doesn't catch those errors. Here's what I use:
I then do a on the output page if there's an error. And I'm not
sure about locking tags but if you use , it
is going to save multiple
I'm not familiar with the query analysis capabilities of sql2000, but you
could look to see how that query might be behaving with respect to the
database and get some suggestions for optimization that way, with any too
ls
available. Perhaps you could try indexing that table on the zip code (if
it
> If the ID list is really long, you could imagine how many 'OR' statements
> you are sticking into your query, and how slow it will make it run. I
> suspect restructuring your query to avoid the huge 'IN' list will speed
your
> query up substantially.
one trick is to shove those IDs into a temp
Jim,
How about an application variable - a structure with all the "current"
pages that is built from your table. Check the structure
(structkeyexists( )) to see if the your ap is aware of the page - if it's
not, do an insert, otherwise proceed to the update. I have used this method
before for t
I need to log views of dynamically generated pages in a MySQL database.
We're just going to be logging on a monthly basis, so this means that each
page will have one log record per month.
A couple of ideas we're kicking around:
1. Every time a page is accessed on the site, we'll call a CF tag th
http://peach.ease.lsoft.com/archives/visbas-beginners.html
http://peach.ease.lsoft.com/archives/visbas-l.html
http://groups.yahoo.com/search?query=vba
http://peach.ease.lsoft.com/archives/index.html
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.griso
Tracy,
When using 'IN' keep in mind that
SELECT blah
FROM table
WHERE ID IN (1,2,3)
is basically the same as:
SELECT blah
FROM table
WHERE ID = 1
OR ID = 2
OR ID = 3
If the ID list is really long, you could imagine how many 'OR' statements
you are sticking into your query, and how slow it wil
> Are you checking for 's "special" errors such as
> "COM.Allaire.ColdFusion.POPAuthFailure" and
> "COM.Allaire.ColdFusion.POPConnectionFailure"?
No, I wasn't aware of those. Where should I have looked to find out about
these?
> I was pulling a similar non-descriptive error and I had
> to put a
> Other attributes of which may be of help in speeding up a
> query is to try using
> whick specifies the max number of rows to fetch at a time
> from the server
> or if you want to limit the number of rows returned.
FYI - The MaxRows attribute of the CFQUERY tag is applied AFTER the dataset
ha
CFPOP is a little flaky at times. After all, lots of things can go wrong
when you are 1) looking up a mail server DNS entry 2) depending on the
network connection to the mail server remaining up 3) depending on the mail
server itself being up 4) depending on the mail server not to throw errors
5)
Are you checking for 's "special" errors such as
"COM.Allaire.ColdFusion.POPAuthFailure" and
"COM.Allaire.ColdFusion.POPConnectionFailure"? I just built an app that
extensively used (arrrggg! Note to Neo-philes: please make Neo
email friendly) and I was pulling a similar non-descriptive err
Out of curiosity, what tool are you using to generate these stats?
-Cameron
Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
> -Original Message-
> From: Hoffman, Joe (C
We have a few "legacy" clients using that script on a MindSpring server.
The layout of the text file should be defined by a special formatting file.
RTM at the MIT site and look for that formatting file in the original code.
-Cameron
Cameron Childress
elliptIQ Inc.
p.770.460
My suggestion would be to create a table in your SQL Server that contains
the list of zip codes that a user can see. Each record would contain the
user's ID and 1 zip code they can see. Then you can either join this table
in, or user it in the "in" clause.
So your select statement would be some
Hello,
was wondering if anyone has used http://web.mit.edu/wwwdev/cgiemail/
CGI script before?? I don't have a unix sever to find out what the out
put use to look like and I need to convert it to something that works on
windows so I figured I would use CF but need to know what the out put
Does anyone know of a java or flash based drag and
drop file uploader (like the ones they use on Photo
Album websites)?
Thanks!
__
Do You Yahoo!?
Send your FREE holiday greetings online!
___
I've converted the dateadd function to sql as suggested. It looks like
it has taken about 17ms off the time by doing that. Thanks, as every ms c
ounts.
Also have used the query of query feature as Sandra suggested, and that r
eally
helped. I'll for sure be a query of query junkie now.
Here's the
http://peach.ease.lsoft.com
They have good lists on various pieces of software and levels. I'm on the
VB beginner list and it has helped greatly.
Good Luck
David
pieces
- Original Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, Janu
In addition to Sandys rules of thumb, I would convert any query you have
into a stored procedure. One of the added benefits is that you can have
multiple result sets when using stored procs. Also, index columns that
are frequently accessed and/or columns you use in your where clause.
Mark
hmmm how many zipcodes are we talking, and which database? and how many
total records?
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:55
To: CF-Talk
Subject: RE: Speeding up select queries
This query takes about 47ms to execute, which
Maybe sorting the zip list might help. Although if it contains that
many zip
codes it might be worthwhile having a re-think.
One more thing, the dateadd in your query, I'd convert that into SQL
functions rather than CF, as follows.
so..
Appt_Time < #DateAdd("h", -48,"#Now()#")#
would become s
If you are using CF5, why not do this in 2 queries. Query the database and
then query the query.
SELECT FileNo, Order_ID, Appraiser_ID, HouseNo, Street, UnitNo, City, Cou
nty,
State_ID, Date_Ordered,time_ordered,Appt_Date,Appt_Time,AMorPM, Lender_ID
, Zip,
(SELECT State FROM T_States WHERE Sta
Is it necessary to lock CFPOP? I'm getting intermittent errors with CFPOP.
I've gone over everything with a fine-toothed comb making sure everything's
locked, and I wasn't sure about this. You have to lock CFFILE, right, so if
CFPOP is saving attachments, then logically CFPOP should be locked to
Other attributes of which may be of help in speeding up a
query is to try using
whick specifies the max number of rows to fetch at a time
from the server
or if you want to limit the number of rows returned.
Regards,
Declan
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTE
This query takes about 47ms to execute, which I can live with that:
SELECT FileNo, Order_ID, Appraiser_ID, HouseNo, Street, UnitNo, City, Cou
nty,
State_ID, Date_Ordered,time_ordered,Appt_Date,Appt_Time,AMorPM, Lender_ID
, Zip,
(SELECT State FROM T_States WHERE State_ID = O.State_ID) AS Sta
hehe... hey - it happens to the best of us. If it wasn't so complicated
we'd all be making minimum wage - right ?
-Original Message-
From: Kevin Cundick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:36 AM
To: CF-Talk
Subject: RE: Scheduler Running Processes Twice
Mark,
There is a nice custom tag on allaire for this.
http://devex.allaire.com/developer/gallery/info.cfm?ID=0FFF0D11-BF26-11
D5-83
F700508B94F85A&method=Full
There are two major products that come out of Berkeley: LSD and [Unix] BS
D.
We don't believe this to be a coincidence.
Doug Brown
Check out qForms:
http://www.pengoworks.com/qForms/
I got this from another post on this list. It might help.
-Original Message-
From: joachim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:24 AM
To: CF-Talk
Subject: Validating forms (security)
Hi,
I'm tuning a for
You could index the pri key.
There are two major products that come out of Berkeley: LSD and [Unix] BS
D.
We don't believe this to be a coincidence.
Doug Brown
- Original Message -
From: "Tracy Bost" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02
General rules of thumb I use.
Avoid Select * always specify your fields.
Fastest is to select fields in the following datatype order, integers,
numeric, strings according to field size. Memo or Long text fields are
always last. The latter one is most important because all fields selected
afte
Someone mentioned using createodbcdate, which should work fine if you
have your datasource set up as an ODBC datasource.
If you are using access as an OLE datasource, you'll (probably) have to
use Access's native format, which surrounds it by pound signs:
INSERT INTO t_sectest
1 - 100 of 136 matches
Mail list logo