Cold Fusion vs. Ihtml
This is a multi-part message in MIME format. --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work in a shop that uses Ihtml. People there swear that CF is = inferior to Ihtml. IS that any data that shows how CF out performs Ihtml or = expresses the advantages of CF over Ihtml? I would very much appreciate the assistance. Jaye Morris, Interactive Developer, Motion Graphics Design [EMAIL PROTECTED] www.jayezero.com +++ Paradox, Humor, and Change - Go Wireless! +++ --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 6.00.2403.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DVerdana color=3D#ff size=3D2STRONGI work in a = shop that uses=20 Ihtml.nbsp; People there swear that CF is inferior toBRIhtml.nbsp; = IS that=20 any data that shows how CF out performs Ihtml or expressesBRthe = advantages of=20 CF over Ihtml?nbsp; I would very much appreciate=20 theBRassistance./STRONG/FONTBR/DIV DIVSTRONGFONT face=3DVerdana color=3D#80 size=3D2Jaye = Morris,nbsp;=20 Interactive Developer, Motion Graphics DesignBRA=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/ABRA=20 href=3D"http://www.jayezero.com"www.jayezero.com/ABR= +++BRParadox,=20 Humor, and Change - Go=20 Wireless!BR+++BR/FONT/STRONG/DIV= /BODY/HTML --=_NextPart_000_009A_01C09271.C598D060-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: User history..where are users coming from?
Yep, cgi.http_referer (a classical mis-spelling) is what you're looking for.
CFIF NOT FINDNOCASE("http://www.YourDomainHere.com",CGI.HTTP_REFERER)
CFLOCATION to where you want them to start
/CFIF
best, paul
At 05:06 PM 2/8/01 -0800, you wrote:
I have been searching past posts and our reference texts looking for this
but I cannot seem to find anything.
I want to be able to ensure that visitors to certain parts of our site are
actually arriving there by browsing our site. We have outside vendors
linking to product manuals and downloading them from their site. When this
happens I would like to bounce them to our home page and deter vendors from
using our site to provide services to their customers. It is ok if someone
surfs our site and downloads the manuals.
We have considered using session variables but that would require
restructuring the existing site. I seem to remember a variable http_referrer
but I can't find anything on it. Am I close? Any suggestions are
appreciated.
Thanks in advance,
Tony Gruen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dupes
It's a temporary problem, soon to be fixed. I get them too. Tom At 07:55 PM 2/8/01, you wrote: Why does this list constantly have duplicates posted to its members? Any thoughts? Regards, Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Query Column Order - Random?
Let me expand on Michael's mention of WDDX. (Thanks, Michael, for
pointing me in this direction.)
The WDDX packet contains a "recordset" tag which has a "fieldNames"
attribute. The value of this "fieldNames" attribute is a list of the
fields in the same order as they appear in the SELECT clause. So you can
convert the query to WDDX, get the correctly-ordered column names from
the packet, throw out the WDDX packet, and then loop over the column
names to output the original query. (I don't know if that's what Michael
meant, but it works for me.)
Here's some sample code.
1. Make the query
cfquery name="qEmpData"select empID, empName, empSalary as Salary from
Employees/cfquery
2. Convert the query to WDDX.
cfwddx action="cfml2wddx" input=#qEmpData# output='qEmpDataWDDX'
The packet looks like this:
wddxPacket version='0.9'header/headerdatarecordset rowCount='5'
fieldNames='EMPID,EMPNAME,SALARY'field name='EMPID'...
3. Get the "fieldNames" part of the packet
cfset fieldNamesStart = "fieldNames='"
cfset fieldNamesStartPos =
FindNoCase(fieldNamesStart,qEmpDataWDDX)+Len(fieldNamesStart)
cfset tmp = Right(qDataWDDX,Len(qEmpDataWDDX)-fieldNamesStartPos)
cfset fieldNamesStop = "'"
cfset fieldNamesLen = FindNoCase(fieldNamesStop,tmp)
cfset colList = Mid(qEmpDataWDDX,fieldNamesStartPos,fieldNamesLen)
4. Ignore the WDDX packet.
5. Loop over the query rows and columns.
table border="1" cellspacing="1" cellpadding="5"
!--- Header row ---
trcfloop index="iCol" from="1"
to="#ListLen(colList)#"thcfoutput#Trim(ListGetAt(colList,iCol))#/c
foutput/th/cfloop/tr
!--- Data ---
cfloop query="qEmpData"
tr
cfloop index="iCol" from="1" to="#ListLen(colList)#"
cfset colName = Trim(ListGetAt(colList,iCol))
cfoutputtd#Evaluate(colName)#/td/cfoutput
/cfloop
/tr
/cfloop
/table
To be safe, you could wrap step #3 in a CFTRY/CFCATCH block, and if there
is an error, set colList to the ColumnList query property. You wouldn't
get the nice column ordering, but at least it'd work.
I'm aware of these other methods for getting the query columns in the
right order:
* Parse the SQL statement's SELECT clause into your own ColumnList, and
then loop over that. This can be tricky, since fields may be designated
in many ways, such as {Employees.empID, empID, empID as ID,
Employees.empID "ID",empID "ID", etc.}
* Use CFOBJECT to get an ADO recordset
* Nate's CFX_QueryColumns tag
-David
On Wed, 07 Feb 2001 "Caulfield, Michael" [EMAIL PROTECTED]
writes:
I think the order is alphabetical (if I remember correctly). To get
the actual order you can either use a database server-specific
method (get colorder from the table syscolumns in SQL Server)
or you can WDDX the query, which for some reason outputs
the columns in the right order.
-Original Message-
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 11:53 AM
To: CF-Talk
Subject: CF Query Column Order - Random?
When you make a CFQUERY, the variable queryName.columnList
variable returns a list of field names from the query. However, this
order doesn't appear to reflect the order of columns from the SELECT
statement, or the table itself. Is there some logic to how its ordered?
And, is there a way to access the columns in the order of the
SELECT statement?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bizarre disappearing page - help!!!
Time Out Maybe -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 9:43 PM To: CF-Talk Subject: Bizarre disappearing page - help!!! Hi everybody! I've got this page which works until you have more than 1300ish records, and then the page comes back completely blank! Not even CF debugging! The problem occurs in a simple loop: cfloop query="Q_GetAllCustomers" cfoutput tr valign="top" td#CustomerName#/td td#OldClientNumber#/td td/cfoutput cfif DeletedFlag is "No" cfoutputa href="JobAd.cfm?CustomerID=#ID#"Create a job ad/a |/cfoutput /cfif cfoutputa href="EditCustomer.cfm?Fn=#Fn#ID=#ID#"Edit/a |/cfoutput cfif DeletedFlag is "No" cfoutputa href="Delete.cfm?Fn=#Fn#ID=#ID#"Inactivate/a/cfoutput cfelse cfoutputa href="Reanimator.cfm?Fn=#Fn#ID=#ID#"Re-activate/a/cfoutput /cfif cfoutput /td /tr/cfoutput /cfloop If you don't like the code, its not ours! ;) Any thoughts, let me know! David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Insert Using Select
You answered your own question in your last paragraph - you _can_ put constants and expressions in your select statement. Try something like this: INSERT into tbl (MyUUID, name, VersionID) SELECT '#CreateUUID()#', name, VersionID + 1 FROM tbl WHERE MYUUID = '#form.MyUUID#' Bob -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 11:00 PM To: CF-Talk Subject: Problem with Insert Using Select I want to insert new records into a table which has MyUUID as its primary key as well as a column, VersionId, which needs to be updated. Each new record should be identical to the old record, except for a new MyUUID and an incremented VersionID. For example, this old record: MyUUID: BT784-PI89 MyName: Smith VersionID: 1 should have its corresponding new record: MyUUID: A622T-U8FF MyName: Smith VersionID: 2 I can't use the query syntax: INSERT into tbl (MyUUID, name, VersionID) SELECT MyUUID, name, VersionID FROM tbl WHERE MYUUID = '#form.MyUUID#' because that would be overwriting (making non-unique) the UUID, not to mention the version number. Is there a way to do the insert with the Select as well as a dynamically generated uuid? In other words, to simultaneously use the select for given columns (MyName) and passed-in values for other columns(MyUUID, VersionID). I need this to work with CF4.5; any ideas? Thanks ahead of time, Andrew Kopelman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
thumbnails
I've tried using CFX_GIFGD and CFX_IMAGE, but neither one allows you to set the quality (compression ratio) for JPG files. I'm trying to make low quality (fast loading) thumbnails auomatically. The thumbnails I make with ACDSee are about an eighth the size. Any suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP Link Checker?
You could use CFHTTP to do a GET on the URL. If it fails then it's not valid.. (I'd keep a running log of the number of times, then you can say after 4 times in a week, then the link must be down.) Darryl Lyons -Original Message- From: John B Venable Jr [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 2:00 PM To: CF-Talk Subject: CFHTTP Link Checker? Is there any way to check for the validity of HTML links by using Cold Fusion. If so, any resources to explain how would be of great help. TIA. -- John B. Venable Jr. it took men about five thousand years, counting from the beginning of number symbols, to think of a symbol for nothing. --Isaac Asimov Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: W2K vs. NT
Dave, -- From: Dave Watts [mailto:[EMAIL PROTECTED]] If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... Is there a way of making that technique work? I.e. can you make IIS evaluate URL from left to right instead of from right to left as its seems to be doing? The only way to make this work, if you're running NT 4 SP6 or Win2K, is to downgrade to NT 4 SP5 or earlier. -- I don't know what all this talk is about fusebox style urls (index.cfm/foo/bar/var/new/x.htm) not working on a Win2k box. We recently were forced (hardware failure) to rebuild one of our servers and decided to upgrade to Win2k. We have numerous sites on this box using the fusebox style urls and haven't had any problems with them whatsoever. One example . . . http://www.emeraldball.com/index.cfm/showsection/contact/page.htm .. . . which is clearly running on win2k: http://uptime.netcraft.com/up/graph/?host=www.emeraldball.com Thanks, Jeff Howden Sr. Web Application Engineer [EMAIL PROTECTED] AlphaShop Network Services http://www.alphashop.net/ Mobile: 503.804.9938 Voice: 541.681.4078 Fax:541.681.4084 AIM - Active Information Management ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Refresh issue with shopping cart
Couldn't you add the items to the cart in one template and then do a cflocation to another? Then, if the user does a reload, they're simply refreshing the page that you did the relocate to instead of the one that did the cart update? Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "James McCullough" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 11:36 PM Subject: Refresh issue with shopping cart I am wondering how to get around this problem. When I add an item to a shopping cart, the correct number of items is added. However, when the refresh button is hit, the items are added again with each refresh button. This happens with Able Commerce carts as well. How would you get around this? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: hardware
APC MasterSwitch... works like a charm. TCP socket, Telnet, or Web (HTTP) control interface! At 08:08 AM 2/8/01 -0700, Nick Call wrote: O.T. warning. I am trying to find a remote power cycling switch that is IP based, not telephony based. Anyone have experience or a good source for these? My application does not permit me to string in a dedicated phone line for the switch, it has to be IP based communication. I have seen them before, but I am not having much luck locating vendors. Thanks in advance. end O.T. Nick [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
harpoon
thanks for sending the beta location... it looks fantastic! does anyone have any urls of where i can actually see some of the apps in action? thanks chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: User history..where are users coming from?
a... methinks thou art great, all who have helped me with this ponderous
dilemma.
T
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 9:04 PM
To: CF-Talk
Subject: Re: User history..where are users coming from?
If your site is www.site.com then you could do something like:
cfif findnocase("www.site.com",cgi.http_referer) is 0
cflocation url="www.site.com"
/cfif
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!
- Original Message -
From: "Tony Gruen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 8:06 PM
Subject: User history..where are users coming from?
I have been searching past posts and our reference texts looking for this
but I cannot seem to find anything.
I want to be able to ensure that visitors to certain parts of our site are
actually arriving there by browsing our site. We have outside vendors
linking to product manuals and downloading them from their site. When this
happens I would like to bounce them to our home page and deter vendors
from
using our site to provide services to their customers. It is ok if someone
surfs our site and downloads the manuals.
We have considered using session variables but that would require
restructuring the existing site. I seem to remember a variable
http_referrer
but I can't find anything on it. Am I close? Any suggestions are
appreciated.
Thanks in advance,
Tony Gruen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing Advanced Security on NT4
Yes you can. When I re-installed a previous employer's server, I was able to add advanced security easily on a subsequent install of CF Enterprise. K - thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Removing the documentation and sample applications
WRT security, does anyone know off the top of their head what files need deleting (and any other changes that might need making) in order to remove the sample applications and documentation if they were selected when installing ColdFusion on a server? I think they're all in the CFDOCS directory. Thanks. I guessed we've have to bin that one, but are there any other things that should be deleted that could be potentially hazardous? For example, are there any CFXs that are only registered when you install the sample apps and documentation? -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session timeout question
that's not exactly true. if you define the timeouts of session variables in an application.cfm file, they can timeout at different times. if you set one to timeout in 15 minutes and another at 30 minutes, then idled for 20 minutes, the first would timeout, the second would not. How would you code that? I've only ever used SESSIONTIMEOUT used globally in the CFAPPLICATION tag. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying the IP of a server
What variable holds the IP address of a server? CGI.REMOTE_ADDR Umm.. that's looks like my IP. Not the IP of the server. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: W2K vs. NT
At 2/8/2001 09:25 PM -0500, you wrote: If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... Is there a way of making that technique work? I.e. can you make IIS evaluate URL from left to right instead of from right to left as its seems to be doing? The only way to make this work, if you're running NT 4 SP6 or Win2K, is to downgrade to NT 4 SP5 or earlier. Actually, just to beat this a little more off-thread-topic, I understand that appending ".cfm" to the URL will make this work again. E.g. some.server.com/index.cfm/some/variables/passed.cfm Can't swear to that. I use the other method to make this work, which is not using IIS ;-) Cheers, -Max ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
COM problem
Hello all. I received a com object from securepay.com to connect to their real time processing via https. I've installed it and rebooted and removed, rebooted then reinstalled and rebooted twice. When I try and run a test against it I get: Error - 10060 The current connection has timeout I am also working on a site for a company that installed the same file on their server. Same setup, NT4 and CF 4.01, and my same test files work fine there. The only difference is they're running IIS and I'm running WS Pro. But the tech guy at securepay tested my test files on his server with WS Pro also, same version, and it works fine for him. Anyone have an idea why this would be happening? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL syntax for contol characters
How about square brackets? Nick -Original Message- From: Richard Kern [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:29 AM To: CF-Talk Subject: SQL syntax for contol characters A question for you. I have inherited an access db upsized to SQL7 that has some nasty column names, obviously won't ouput in CF without an alias. However is formating the SQL statement using a single quote returns the literal string within the quote and using a backtick to set it off generates an error in CF. So how does one specify the target column name for an alias? ex SELECT `home phone` AS PHONE FROM EMPLOYEE or SELECT `TBR@40` AS TBR FROM EMPLOYEE produce a syntax error and SELECT 'home phone' AS PHONE FROM EMPLOYEE produces 'home phone' in the field instead of the number Thanks Richard kern ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 2000
The coolest 2K extra is direct XML support. You can perform a http: query directly to the db and have XML returned or transformed XML via XSL into ... HTML or whatever. http://yourdomain/SQLRoot?sql=SELECT+*+FROM+products+FOR+XML+AUTOroot=root Also, I really like the upgrade to query analyzer. Bill Reichard Willow Gold In a message dated 2/8/01 7:33:46 PM Eastern Standard Time, [EMAIL PROTECTED] writes: My recollection of the insight of some SQL Professionals is the SQL2000 is mostly an upgrade for large enterprise users (the Oracle wars). best, paul At 02:44 PM 2/7/01 -0600, you wrote: what features does it have that SQL 7 doesn't? Bug fixes maybe? I mean, is it worth upgrading to considering how much it costs? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Combinations
If your're doing it in Cf then sounds like you need to do it in the database. Something like this depending what you're using. 1 Build first query for add direct links and add to a temp table. 2 Then get a query with just the departure and not destination. 3Add these to temp table or query and link by destination-to-departure to a second query of those with destination and not departure. 4 Add this list to your original temp table. 5 To go down further levels you could repeat step 3 with an intermediate link (departure only) linked from destination to departure (all departures) linked from destination to departure (destination only) Add these to your original temp table And so on -Original Message- From: Rob Eastland [mailto:[EMAIL PROTECTED]] Sent: 08 February 2001 19:44 To: CF-Talk Subject: Combinations I've been struggling a bit with a search function. Scenario: I'm trying to build a search function that finds a any combinations of voyages (seafaring shipping company client) that match the search criteria of departure and arrival port. There is also some date qualification, but that will just complicate the description so I'll leave that out for now. Basically I'm trying to find a way to get combinations of voyages that meet the search criteria without doing endless looping which has been proven to not work without timing out. I have all of the individual voyages in a single table with the departure/arrival ports and dates. Finding a single voyage that matched the citeria was simple by using a single query and outputting the results. Next, I tried using one query to find any voyages that left from the desired departure port and another to find any that arrived in the desired port. Then I looped through the first set of results while looping through the second set inside that loop and using a cfif statement to see if any two voyages combined matched the requirements and output any true results. It's not particularly fast, but it works. Problem: I tried to continue this logic with another query to get any remaining voyages with another embedded loop an expanded logic statement to see if any remaining voyage could connect a voyage from the first set with a voyage from the second set. This simply times out before it can complete, and theoretically I need to this process to continue until it finds all possible combinations that can fit together to meet the search criteria. It's sort of like finding a combinations of flights that could get someone from New York to Los Angeles. He could get a direct flight, or a flight from NY to Chicago then from Chicago to LA. Or, from NY to Chicago, Chicago to Denver, Denver to LA. etc I thought the solution could be narrowing the number of comparisons by embedding a query in the loop that just retrieved possible connections for each departure and arrival set that it was going to compare instead of comparing all remaining voyages for a valid connection voyage, but running that many queries seemed to actually make it slower. In one example I have about 30 voyages that leave from the desired departure port and about 40 that arrive in the desired arrival port which makes about 1200 possible combinations to test. That part actually works, but when I try to compare those to another ~150+ possible connecting voyages the number goes up very quickly to about 180,000 comparisons and would grow exponentially as I tried to find multiple connections, but I can't even do that without timing out. Any ideas would be greatly appreciated. :--)) Rob Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML/OS - WRRONG
We exclusively run Netscape Servers here. Never had a problem. Mary ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Books on CF,
Does anyone know of what up coming books are being published on CF besides the one that WROX is publishing? TIA Michael B ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL on NT
Hi all Could we have a quick show of hands for something: We're using CF 4.5 (SP2) on NT 4 SP6 - trying to send mails using CFMAIL. When the CF server sends to a Linux-based SMTP server, between the 2 (NT/Linux), it's stripping CR's from the mail, leaving bare LF's (i.e. each line should end with a CR/LF - but the CR is getting stripped somewhere, leaving only the LF). Has anyone experienced problems with CFMAIL when using CF on an NT box, connecting to a mailserver on a Linux box? And, finally - how many people are using NT/Linux in this configuration. Thanks all. Simon. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Wanted: Sr. Developer
Does that mean we need another list for TALKing about JOBS? I don't suppose so, but jobs shouldn't be posted here... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I display an image from a database?
Is there a way you can display an image from a database in ColdFusion? (no need to start with the reasons not to have images in a database, I am way past that issue, it really is fine to have them in the database in this particular application). I want to be able to have IMG tags in my HTML that are like IMG SRC="/getimage.cfm?imageid=3" and then have getimage.cfm get the binary image data from the database and give it to the browser. Right now the image data is stored in Base64 format in a text type field in the DB. I was trying to use this code: CFSETTING ENABLECFOUTPUTONLY="Yes" SHOWDEBUGOUTPUT="No" CFQUERY NAME="getimg" DATASOURCE="dsn" SELECT image from image WHERE imageid = CFQUERYPARAM VALUE="#Attributes.imageid#" CFSQLTYPE="CF_SQL_INTEGER" /CFQUERY CFCONTENT TYPE="image/jpeg" CFOUTPUT"#ToBinary(getimg.image)#/CFOUTPUT But this gives me this error: Expression result cannot be converted to a string. Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. In a word - DON'T - you shouldn't get image data from a database for 2 reasons; Firstly, the OS probably won't have written the file by the time the web server requests it Secondly, if 10 people ask for the same file, each will have to be written, displayed and killed later It's easier to have a reference to the file and just put that in the IMG SRC Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stop Query From Caching
I have a page that calculates the shipping method after a person updates their cart. It looks in their shopping cart database table for the ship method, recalculates then redirects to the cart page. The problem is that sometimes the database gets changed, but the query runs off of "old" data. IE it's not making a new query. How can I force a query to use data from a table and not from cache? The obvious answer is to not cache it in CF If you need to use caching in CF, then when it's updated, use CACHEDWITHIN="#CreateTimeSpan(0,0,0,0)#" and the same SQL - this should refresh the cache on that one query Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL syntax for contol characters
I have inherited an access db upsized to SQL7 that has some nasty column names, obviously won't ouput in CF without an alias. However is formating the SQL statement using a single quote returns the literal string within the quote and using a backtick to set it off generates an error in CF. So how does one specify the target column name for an alias? ex SELECT `home phone` AS PHONE FROM EMPLOYEE or SELECT `TBR@40` AS TBR FROM EMPLOYEE produce a syntax error and SELECT 'home phone' AS PHONE FROM EMPLOYEE produces 'home phone' in the field instead of the number Use square brackets, otherwise it's a string... SELECT [home phone] as Phone Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stop Query From Caching
Don't use the chachedwithin attribute in cfquery - Original Message - From: "Josh R" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 10:57 PM Subject: Stop Query From Caching I have a page that calculates the shipping method after a person updates their cart. It looks in their shopping cart database table for the ship method, recalculates then redirects to the cart page. The problem is that sometimes the database gets changed, but the query runs off of "old" data. IE it's not making a new query. How can I force a query to use data from a table and not from cache? HELP! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bizarre disappearing page - help!!!
possibly odbc timeout rather than cf timeout... -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 09 February 2001 05:53 To: CF-Talk Subject: RE: Bizarre disappearing page - help!!! Time Out Maybe -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 9:43 PM To: CF-Talk Subject: Bizarre disappearing page - help!!! Hi everybody! I've got this page which works until you have more than 1300ish records, and then the page comes back completely blank! Not even CF debugging! The problem occurs in a simple loop: cfloop query="Q_GetAllCustomers" cfoutput tr valign="top" td#CustomerName#/td td#OldClientNumber#/td td/cfoutput cfif DeletedFlag is "No" cfoutputa href="JobAd.cfm?CustomerID=#ID#"Create a job ad/a |/cfoutput /cfif cfoutputa href="EditCustomer.cfm?Fn=#Fn#ID=#ID#"Edit/a |/cfoutput cfif DeletedFlag is "No" cfoutputa href="Delete.cfm?Fn=#Fn#ID=#ID#"Inactivate/a/cfoutput cfelse cfoutputa href="Reanimator.cfm?Fn=#Fn#ID=#ID#"Re-activate/a/cfoutput /cfif cfoutput /td /tr/cfoutput /cfloop If you don't like the code, its not ours! ;) Any thoughts, let me know! David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Insert Using Select
that wont work - db would look for a field with the generated UUID as a name... you need to have a subselect: INSERT into tbl (MyUUID, name, VersionID) SELECT (select '#CreateUUID()#') as MyUUID, name, VersionID + 1 FROM tbl WHERE MYUUID = '#form.MyUUID#' that should work... HTH Dan -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 09 February 2001 05:49 To: CF-Talk Subject: RE: Problem with Insert Using Select You answered your own question in your last paragraph - you _can_ put constants and expressions in your select statement. Try something like this: INSERT into tbl (MyUUID, name, VersionID) SELECT '#CreateUUID()#', name, VersionID + 1 FROM tbl WHERE MYUUID = '#form.MyUUID#' Bob -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 11:00 PM To: CF-Talk Subject: Problem with Insert Using Select I want to insert new records into a table which has MyUUID as its primary key as well as a column, VersionId, which needs to be updated. Each new record should be identical to the old record, except for a new MyUUID and an incremented VersionID. For example, this old record: MyUUID: BT784-PI89 MyName: Smith VersionID: 1 should have its corresponding new record: MyUUID: A622T-U8FF MyName: Smith VersionID: 2 I can't use the query syntax: INSERT into tbl (MyUUID, name, VersionID) SELECT MyUUID, name, VersionID FROM tbl WHERE MYUUID = '#form.MyUUID#' because that would be overwriting (making non-unique) the UUID, not to mention the version number. Is there a way to do the insert with the Select as well as a dynamically generated uuid? In other words, to simultaneously use the select for given columns (MyName) and passed-in values for other columns(MyUUID, VersionID). I need this to work with CF4.5; any ideas? Thanks ahead of time, Andrew Kopelman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: harpoon
There are example applications included with the Beta. If you are not already on the beta, send a request to [EMAIL PROTECTED], asking to participate. They will give you a login, which you can then use to download the Beta, including the samples. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: chad jackson [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 2:24 AM To: CF-Talk Subject: harpoon thanks for sending the beta location... it looks fantastic! does anyone have any urls of where i can actually see some of the apps in action? thanks chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date Validation
oh, i dont want to change the date format, i want to validate against
the "mm/dd/" format.
"Sicular, Alexander" wrote:
that doesn't do much for you because you are checking date against itself in
a different format.
this will check to make sure that the data passed is a valid date.
cfif isdate(form.due_date)
/cfif
then you can change it's format via dateformat()
good luck,
-alex
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 9:39 AM
To: CF-Talk
Subject: Date Validation
I want to do check to see if users are entering the date properly in my
form. Is this correct?
cfif #form.due_date# IS NOT #DateFormat(form.due_date, "mm/dd/")#
XCRIPT LANGUAGE="XavaXcript" TYPE="text/XavaXcript"
!--alert ('Your Date entry is
invalid.')location.href='XavaXcript:window.history.back(1)'//--
/XCRIPT
cfabort
/cfif
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCOOKIE 101 - Need help
Hi all, Despite having used CF for 2 years, only know am I venturing into using CFCOOKIE. I have a couple of questions: - How can I make sure the browser has cookies enabled? - How much can I store in them? - Presumably I can encrypt / decrypt the contents? - Any pitfalls I should look out for (other than CFLOCATION on the same page)... Thanks Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: User history..where are users coming from?
Tony wrote: I want to be able to ensure that visitors to certain parts of our site are actually arriving there by browsing our site. We have outside vendors linking to product manuals and downloading them from their site. When this happens I would like to bounce them to our home page and deter vendors from using our site to provide services to their customers. It is ok if someone surfs our site and downloads the manuals. One option is to use the following in an application.cfm file and then name your cf files _filename.cfm. I got this from Cameron in a security/login thing he wrote. !--- Keep hackers outta your code --- CFIF Left( ListLast( GetTemplatePath(), "\"), 1 ) is '_' CFABORT /CFIF This may or may not be workable depending on your application. You might be able to use it on a certain portion of your site and change the cfabort to a cflocation url="www.yoursite.com". Hope this helps Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Issues with CFX_IMAP4
Has anybody out there had any problems using the custom tag CFX_IMAP4? Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Thoughs on Macromedia Takeover of Allaire
I've been thinking to day of the different possible scenario's we could face as CF developers. One of them struck me as quite amusing. Since MM are very much into integrating with Microsoft products does this mean we are going to start seeing "Wizards" in Access which generate CF code along with bloated xml and the like? Will there be CF extentions to frontpage?! Will CF be an intraverted technology from now on? As developers are we going to see our specialism disappear in a puff of smoke as CF succumbs to the marketing machines of huge coroporations desperate to increase revenue rather than develop technology with the end user in mind? Are we to believe that Microsoft and MM are customer led? I don't think so, and in the new age of e-business, thats what counts. Management led e-businesses are few and far between, or should be. I have also heard a disturbing rumour that the ASP (Application Service Provider not MS ASP!) industry is about to collapse. It hasn't taken off as expected at all. Will this also contribute to the decline of our chosen technology? Martin. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [separate box for CF]
is your current setup slow? do you think you'll be getting more traffic or more CF intensive code executing? "Adrian Cesana" [EMAIL PROTECTED] wrote: Im getting ready to upgrade our servers and am wondering if I should be running CF on a dedicated box, whats a good way to gauge this? Thanks,Adrian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: User history..where are users coming from?
Tony wrote: I want to be able to ensure that visitors to certain parts of our site are actually arriving there by browsing our site. We have outside vendors linking to product manuals and downloading them from their site. When this happens I would like to bounce them to our home page and deter vendors from using our site to provide services to their customers. It is ok if someone surfs our site and downloads the manuals. oops... I forgot to mention that the files with the _ in front, now have to be cfincluded like so cfinclude template="_filename.cfm" This way if someone types in the url/_filename.cfm the application file will either abort or "redirect" (see below). One option is to use the following in an application.cfm file and then name your cf files _filename.cfm. I got this from Cameron in a security/login thing he wrote. !--- Keep hackers outta your code --- CFIF Left( ListLast( GetTemplatePath(), "\"), 1 ) is '_' CFABORT /CFIF This may or may not be workable depending on your application. You might be able to use it on a certain portion of your site and change the cfabort to a cflocation url="www.yoursite.com". Hope this helps Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: weather feeds
Thanks. There are several custom weather tags at Allaire. But the Weather Channel has copy and paste code that's free and brain dead easy. I'll stick with that unless the client wants a more nuetral look. DJ "C. Hatton Humphrey" wrote: If memory serves proppery, wx.com (which is CF based) provides a WDDX feed. This is your best "put it in my look-and-feel" solution, but I never looked into the pricing of it. There are several other options, including some custom tags that make use of the CFHTTP, but I don't know the legal implications of those tags. Personally I'm using the stickers provided by wunderground.com. HTH Hatton Humphrey -Original Message- Hi, I need to find out how easy/hard expensive/inexpensive a weather feed for a web page is, and if there are any cf-centric solutions. TIA, Douglas Jordon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Mailing List Server Explosion?
IF you guys read the admin e-mail, you would have already know this and why it happened. --=@ greg @=-- - Original Message - From: "Jason Larson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 5:14 PM Subject: RE: Mailing List Server Explosion? YES!!! AAARRRGGGH!! -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 7:00 AM To: CF-Talk Subject: OT: Mailing List Server Explosion? Did anyone else just get a huge amount of repeats last night, or do I need to talk to my network admin about our mail server recreating 24 e-mails about 100 times... I walked in this morning and had 233 e-mails from this list... and no dupes from anything else. Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying the IP of a server
There's a custom tag in the gallery called cfx_nslookup that will allow you to get this. It can do a forward or reverse lookup. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 3:28 AM To: CF-Talk Subject: RE: Displaying the IP of a server What variable holds the IP address of a server? CGI.REMOTE_ADDR Umm.. that's looks like my IP. Not the IP of the server. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bind complete managment system
I was thinking of coding a complete management system for Bind 8, would there be anyone interested in me making something like this? Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Installing an ActiveX control in Netscape
I have an ActiveX control that I need to be cross-browser. I have a plug-in for Netscape that will allow the control to be run, but unfortunately it will not install the control first... the only way I can currently do it is to force the user to view the page first in IE and then the control will work (via the plug-in) in Netscape. Can anyone tell me if there is a way to force an ActiveX control (it is a .cab file containing an .ocx and an .inf) to install? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PDF Detection
I'm there, thanks for the referral. -Original Message- From: Stephen M Aylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 11:29 PM To: CF-Talk Subject: Re: PDF Detection Good question for www.planetpdf.com Steve - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 12:30 PM Subject: OT: PDF Detection Is there a way to detect if a user does not have the ability to view PDFs on their IE machine? Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion vs. Ihtml
Can you get the people who swear that CF is inferior to tell you what is bad about CF and what is good about ihtml? Kind of a Pros and Cons then we can tell you what is accurate and what is not accurate. -Original Message- From: Jaye Morris [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 7:25 AM To: CF-Talk Subject: Cold Fusion vs. Ihtml This is a multi-part message in MIME format. --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work in a shop that uses Ihtml. People there swear that CF is = inferior to Ihtml. IS that any data that shows how CF out performs Ihtml or = expresses the advantages of CF over Ihtml? I would very much appreciate the assistance. Jaye Morris, Interactive Developer, Motion Graphics Design [EMAIL PROTECTED] www.jayezero.com +++ Paradox, Humor, and Change - Go Wireless! +++ --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 6.00.2403.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DVerdana color=3D#ff size=3D2STRONGI work in a = shop that uses=20 Ihtml.nbsp; People there swear that CF is inferior toBRIhtml.nbsp; = IS that=20 any data that shows how CF out performs Ihtml or expressesBRthe = advantages of=20 CF over Ihtml?nbsp; I would very much appreciate=20 theBRassistance./STRONG/FONTBR/DIV DIVSTRONGFONT face=3DVerdana color=3D#80 size=3D2Jaye = Morris,nbsp;=20 Interactive Developer, Motion Graphics DesignBRA=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/ABRA=20 href=3D"http://www.jayezero.com"www.jayezero.com/ABR= +++BRParadox,=20 Humor, and Change - Go=20 Wireless!BR+++BR/FONT/STRONG/DIV= /BODY/HTML --=_NextPart_000_009A_01C09271.C598D060-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion vs. Ihtml
I work in a shop that uses Ihtml. People there swear that CF is = inferior to Ihtml. IS that any data that shows how CF out performs Ihtml or = expresses the advantages of CF over Ihtml? I would very much appreciate the assistance. There is only one definite advantage that iHTML has over CF (out of the box), apart from being free with WebsitePro; It can create images on the fly. don't expect it's textual ones to be any good, but it does make them Apart from that, it's just another language that runs on a web-server We dropped our development with iHTML a few years ago, mainly because at that time, when it crashed it took the whole server down... We haven't looked at the tech since then, but I'm sure it's moved on (like CF has) since then Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion vs. Ihtml
Just a few that I'm aware of (I'm not all that familiar with iHTML): iHTML runs in the address space of the web server (not as a separate service). So, iHTML would be more prone to taking down a web server than CF. iHTML does not support COM (not sure if it supports CORBA but I doubt it). iHTML does not have native clustering. iHTML does not support template encryption. Custom tags are almost non-existant. iHTML supports extensions (iHTX) but there are no good examples from Inline nor is there a "developer's exchange" where you can acquire custom tags. There is a code exchange of sorts, though. A few iHTML pluses that I know of: Multi-platform support (Windows, Unix) Devoted community (like the CF community) You get questions answered directly from the iHTML developers consistently (Inline). Strong motivation by Inline to support free and open standards (Open ODBC, MySQL, etc.) Less pricey than CF. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Jaye Morris" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 09, 2001 8:24 AM Subject: Cold Fusion vs. Ihtml This is a multi-part message in MIME format. --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work in a shop that uses Ihtml. People there swear that CF is = inferior to Ihtml. IS that any data that shows how CF out performs Ihtml or = expresses the advantages of CF over Ihtml? I would very much appreciate the assistance. Jaye Morris, Interactive Developer, Motion Graphics Design [EMAIL PROTECTED] www.jayezero.com +++ Paradox, Humor, and Change - Go Wireless! +++ --=_NextPart_000_009A_01C09271.C598D060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 6.00.2403.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DVerdana color=3D#ff size=3D2STRONGI work in a = shop that uses=20 Ihtml.nbsp; People there swear that CF is inferior toBRIhtml.nbsp; = IS that=20 any data that shows how CF out performs Ihtml or expressesBRthe = advantages of=20 CF over Ihtml?nbsp; I would very much appreciate=20 theBRassistance./STRONG/FONTBR/DIV DIVSTRONGFONT face=3DVerdana color=3D#80 size=3D2Jaye = Morris,nbsp;=20 Interactive Developer, Motion Graphics DesignBRA=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/ABRA=20 href=3D"http://www.jayezero.com"www.jayezero.com/ABR= +++BRParadox,=20 Humor, and Change - Go=20 Wireless!BR+++BR/FONT/STRONG/DIV= /BODY/HTML --=_NextPart_000_009A_01C09271.C598D060-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: Re: CF Query Column Order - Random?
After a night's sleep, I see that it may be simpler to outut the data
directly from the WDDX packet. So instead of throwing the WDDX packet
away, you'd throw away your original query, and parse the packet. This
would avoid the use of Evaluate().
-David
- Forwarded Message -
From: David Shadovitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Thu, 8 Feb 2001 21:23:51 -0800
Subject: Re: CF Query Column Order - Random?
Let me expand on Michael's mention of WDDX. (Thanks, Michael, for
pointing me in this direction.)
The WDDX packet contains a "recordset" tag which has a "fieldNames"
attribute. The value of this "fieldNames" attribute is a list of the
fields in the same order as they appear in the SELECT clause. So you can
convert the query to WDDX, get the correctly-ordered column names from
the packet, throw out the WDDX packet, and then loop over the column
names to output the original query. (I don't know if that's what Michael
meant, but it works for me.)
Here's some sample code.
1. Make the query
cfquery name="qEmpData"select empID, empName, empSalary as Salary from
Employees/cfquery
2. Convert the query to WDDX.
cfwddx action="cfml2wddx" input=#qEmpData# output='qEmpDataWDDX'
The packet looks like this:
wddxPacket version='0.9'header/headerdatarecordset rowCount='5'
fieldNames='EMPID,EMPNAME,SALARY'field name='EMPID'...
3. Get the "fieldNames" part of the packet
cfset fieldNamesStart = "fieldNames='"
cfset fieldNamesStartPos =
FindNoCase(fieldNamesStart,qEmpDataWDDX)+Len(fieldNamesStart)
cfset tmp = Right(qDataWDDX,Len(qEmpDataWDDX)-fieldNamesStartPos)
cfset fieldNamesStop = "'"
cfset fieldNamesLen = FindNoCase(fieldNamesStop,tmp)
cfset colList = Mid(qEmpDataWDDX,fieldNamesStartPos,fieldNamesLen)
4. Ignore the WDDX packet.
5. Loop over the query rows and columns.
table border="1" cellspacing="1" cellpadding="5"
!--- Header row ---
trcfloop index="iCol" from="1"
to="#ListLen(colList)#"thcfoutput#Trim(ListGetAt(colList,iCol))#/c
foutput/th/cfloop/tr
!--- Data ---
cfloop query="qEmpData"
tr
cfloop index="iCol" from="1" to="#ListLen(colList)#"
cfset colName = Trim(ListGetAt(colList,iCol))
cfoutputtd#Evaluate(colName)#/td/cfoutput
/cfloop
/tr
/cfloop
/table
To be safe, you could wrap step #3 in a CFTRY/CFCATCH block, and if there
is an error, set colList to the ColumnList query property. You wouldn't
get the nice column ordering, but at least it'd work.
I'm aware of these other methods for getting the query columns in the
right order:
* Parse the SQL statement's SELECT clause into your own ColumnList, and
then loop over that. This can be tricky, since fields may be designated
in many ways, such as {Employees.empID, empID, empID as ID,
Employees.empID "ID",empID "ID", etc.}
* Use CFOBJECT to get an ADO recordset
* Nate's CFX_QueryColumns tag
-David
On Wed, 07 Feb 2001 "Caulfield, Michael" [EMAIL PROTECTED]
writes:
I think the order is alphabetical (if I remember correctly). To get
the actual order you can either use a database server-specific
method (get colorder from the table syscolumns in SQL Server)
or you can WDDX the query, which for some reason outputs
the columns in the right order.
-Original Message-
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 11:53 AM
To: CF-Talk
Subject: CF Query Column Order - Random?
When you make a CFQUERY, the variable queryName.columnList
variable returns a list of field names from the query. However, this
order doesn't appear to reflect the order of columns from the SELECT
statement, or the table itself. Is there some logic to how its ordered?
And, is there a way to access the columns in the order of the
SELECT statement?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Admin) Fixed
The list is important and all, but I don't think it's right you need to find another job just because the mail gets clogged up every so often, are there any close CFers here you could maybe give admin access to the server or anything so that you could alleviate this problem. Or maybe give out the code of your mail processing so that some of us could maybe give some new suggestions that maybe might have slipped by at 3 in the morning while writing code. For a free email system you do more than you already should. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 11:27 PM To: CF-Talk Subject: (Admin) Fixed The mail server blew up yesterday afternoon and its taken me some time to get it all working again properly. I apologies for both the blasts of mail that everyone got and the duplicates that were received by some. It took some time to clean up a few hundred thousand messages that were clogging up the server and I still haven't started to read through the logs to see why this happened. I'm working to keep this list up and stable with as much energy as I can. Unfortunately, I'm doing contract for the federal reserve and they have both a massive firewall (that I can work through with special tools) and no sense of allowing me to fix anything that's not theirs. For that reason, I'm going to be leaving that contract as soon as I can either find a new contract or get a solid job. To fill the gap here, I'm going to get a ricochet module for my laptop and slip into the bathroom if any emergencies come up. :) Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session timeout question
i don't think that's strictly correct. you can't "define the timeouts" of session variables, you define them of the entire session. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:34 PM To: CF-Talk Subject: RE: Session timeout question that's not exactly true. if you define the timeouts of session variables in an application.cfm file, they can timeout at different times. if you set one to timeout in 15 minutes and another at 30 minutes, then idled for 20 minutes, the first would timeout, the second would not. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:49 PM To: CF-Talk Subject: Re: Session timeout question On 2/7/01, Phoeun Pha penned: Oh, i know the question now! Are individual session variable timeouts independent of other session variables, or are they all affected at the same instance? All session variables that exist are refreshed at the same time when cfapplication loads and will time out simultaneously, or real close to it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Refresh issue with shopping cart
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi James, You can do this: In the form action page that takes the addition of shopping cart items, update their cart and then do a cflocation to a page that shows the items in their cart. Refreshing *that* page won't do anything but get them the shopping cart status page again... HTH Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 2000
I hate trying to read M$'s licenses. Which paragraph is this in? best, paul At 11:05 PM 2/8/01 -0500, you wrote: Don't forget the fact that MS seems to have the option of pulling the plug on SQL 7 licensing at their whim. Then you'll have to purchase the upgrade to 2000 and surely end up spending more in the long run. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQLServer - mySQL
Are there any conversion utilities for SQLServer to mySQL and what are the interface tools like for Win2k? One of my clients signed up for a hosting package on Solaris box. I specifically stated that SQLServer was required. The tech support and sales group told them the could just "upload SQLServer". Brilliant bunch of chaps! Now I gotta convert my DBs to either mySQL or Access (if supported - does Merant have ODBC drivers for access?). Some kinda fun! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB construction...
Pick Database design for mere Mortals... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Books on CF,
There are lots of books in the works ... * My two CF books (published by Que) are being revised for CF5. * The Mastering book (Sybex) is being revised for CF5 too. * My "Certified ColdFusion Developer Study Guide" ships in a few weeks. * McGraw Hill is also working on a title. * The O'Reilly book should ship soon (Rob Brooks-Bilson's title). * Prima has another one in the works. As I said, lots of books on the way. --- Ben -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 10:06 AM To: CF-Talk Subject: Books on CF, Does anyone know of what up coming books are being published on CF besides the one that WROX is publishing? TIA Michael B ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Syntax error in INSERT INTO statement
Hello,
This gets me all the time. I created a simple survey form; checked and
double-checked all fields and I still get a "Syntax error in INSERT INTO
statement error. All the fields correspond in the form CF page, and Access
table.
Is there some kind of bug or trick Im missing here? Any help would be
appreciated.
Robert O.
Web Admin
CFQUERY name="getsurvey" datasource="survey"
INSERT INTO survey
(Date,info,infosuggestions,bio,quote,quotes,otherquotes,futurepage,onlinecat
alog,catalogfunction,othercatalog,content,contentsuggestions,rate,rateexplan
ation,category,lastcomments,Institution,Name,Title,Email)
VALUES
('#DateFormat(Now())#','#FORM.Info#','#FORM.infosuggestions#','#FORM.Bio#',
'#FORM.Quote#','#FORM.Quotes#','#FORM.Otherquotes#','#FORM.Futurepage#',
'#FORM.Onlinecatalog#','#FORM.Catalogfunction#','#FORM.Othercatalog#',
'#FORM.Content#','#FORM.Contentsuggestions#','#FORM.Rate#','#FORM.Rateexplan
ation#','#FORM.Category#','#FORM.Lastcomments#','#FORM.Institution#','#FORM.
Name#','#FORM.Title#','#FORM.email#')
/cfquery
-
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
SQL = "INSERT INTO survey
(Date,info,infosuggestions,bio,quote,quotes,otherquotes,futurepage,onlinecat
alog,catalogfunction,othercatalog,content,contentsuggestions,rate,rateexplan
ation,category,lastcomments,Institution,Name,Title,Email) VALUES
('09-Feb-01','','','','','','','','','','','','','','','Select','','vnbvnvbn
b','','','')"
Data Source = "survey"
SQL = "INSERT INTO survey
(Date,info,infosuggestions,bio,quote,quotes,otherquotes,futurepage,onlinecat
alog,catalogfunction,othercatalog,content,contentsuggestions,rate,rateexplan
ation,category,lastcomments,Institution,Name,Title,Email) VALUES
('09-Feb-01','','','','','','','','','','','','','','','Select','','vnbvnvbn
b','','','')"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:46).
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying the IP of a server
You could try to ping cgi.server_name. I think there is a tag by Lewis Sellers at www.intrafoundation.com that does this. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Native Oracle Driver
Good morning list, does anyone know of a problem with the native oracle drivers in CF4.5.1 Enterprise? If the native driver is used and dates are selected, only the day and month are passed to CF. If ODBC is used, everything works correctly. The system runs CF Enterprise 4.5.1 (no SP) on NT4.0SP6a, Oracle 8.1.5 on NT40.0SP6a Thanks, Stefan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying the IP of a server
What variable holds the IP address of a server? CGI.REMOTE_ADDR Umm.. that's looks like my IP. Not the IP of the server. That's correct. There's no CGI variable which exposes any meaningful information about the IP address or DNS entry for a server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and VSS
ColdFusion Developer Web Server WWWRoot Check out the files to a working directory Test and Check back in Is there a way to make VSS when you check it in copy it to wwwroot from the working directory? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP Link Checker?
You could pull all http, mailto, ftp links that are submitted, submit them to a table then run a scheduled task to 1. (4.X) use cfx_http to get the response header that is returned. 2. (4.5) use cfhttp to "get" the "CFHTTP.StatusCode" Beware- both techniques have returned errors on certain urls, which stops template from processing any more urls. The cfhttp tag has a timeout option but doesn't always seem to catch server problems. I have a beta cfx tag that is written in java that seems to by-pass some of the above problems. If interested in experimenting with the tag, email me off-list and I'll send it to you. Jeff Sarsoun [EMAIL PROTECTED] -Original Message- From: John B Venable Jr [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 11:00 PM To: CF-Talk Subject: CFHTTP Link Checker? Is there any way to check for the validity of HTML links by using Cold Fusion. If so, any resources to explain how would be of great help. TIA. -- John B. Venable Jr. it took men about five thousand years, counting from the beginning of number symbols, to think of a symbol for nothing. --Isaac Asimov Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: User history..where are users coming from?
For your purposes this is probably fine, but readers should realize this is
not guaranteed effective; the browser can send whatever it wants as the
referer, and I think there are some "privacy-oriented" and other customized
browsers that don't send anything at all.
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001 2:00 AM
To: CF-Talk
Subject: RE: User history..where are users coming from?
a... methinks thou art great, all who have helped me with this ponderous
dilemma.
T
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 9:04 PM
To: CF-Talk
Subject: Re: User history..where are users coming from?
If your site is www.site.com then you could do something like:
cfif findnocase("www.site.com",cgi.http_referer) is 0
cflocation url="www.site.com"
/cfif
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!
- Original Message -
From: "Tony Gruen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 8:06 PM
Subject: User history..where are users coming from?
I have been searching past posts and our reference texts looking for this
but I cannot seem to find anything.
I want to be able to ensure that visitors to certain parts of our site are
actually arriving there by browsing our site. We have outside vendors
linking to product manuals and downloading them from their site. When this
happens I would like to bounce them to our home page and deter vendors
from
using our site to provide services to their customers. It is ok if someone
surfs our site and downloads the manuals.
We have considered using session variables but that would require
restructuring the existing site. I seem to remember a variable
http_referrer
but I can't find anything on it. Am I close? Any suggestions are
appreciated.
Thanks in advance,
Tony Gruen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: W2K vs. NT
You have to read the posting carefully. The problem is with IIS. best, paul At 10:34 PM 2/8/01 -0800, you wrote: Dave, I don't know what all this talk is about fusebox style urls (index.cfm/foo/bar/var/new/x.htm) not working on a Win2k box. We recently were forced (hardware failure) to rebuild one of our servers and decided to upgrade to Win2k. We have numerous sites on this box using the fusebox style urls and haven't had any problems with them whatsoever. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Image Resizing
Is there a way to dynamically resize an image other than custom CF tags? I have a site that builds a dynamic web page for each member. Image URLs are stored in the database and are called to the page. Some of the stored images are larger that I would like and I trying to get any image over 400 pixels wide to resize. Any help would be appreciated. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stop query caching UPDATE
PLEASE READ CAREFULLY (Technical info - Using CF 4.5.2 to query MS Access 97 SR2 database for a text field and date field for unknown number of recordnumbers) OK. I have flushed the query by making a dynamically changing query name (I.E. cfquery name="shipments#uniquefield#") and made the page reload using both unique html calls (I.E. updatecart.cfm?ID=#uniquefield2#") and (meta http-equiv="pragma" content="no-cache") (META HTTP-EQUIV="Expires" CONTENT="Mon, 06 Jan 1990 00:00:01 GMT") codes. It even loads itself into a second page with the exact same code with all NEW uniquefields. There is no way (that I see) this query can get "old" data. BUT, that's exactly what it's doing. It grabs the data previous to updating the database (even though the database has been verifyably updated before this query.) I've even rewritten the query to see if it was just how the query was written. It still occasionally grabs "old" data. In short, grabbing this particular information sometimes grabs "old" data instead of what is verifyably in the database. This problem does not occur on ANY other queries throughout the entire site. Original Query (cfquery name="shipments#uniquefield#" datasource="mine" dbtype="ODBC") SELECT shipdate, shipmethod, Count(*) as totalCount FROM shopcart WHERE MyCart = '#url.cart#' Group by shipdate, shipmethod(/cfquery) Different Query asking for same (cfquery name="shipments#uniquefield#" datasource="mine" dbtype="ODBC") SELECTshipdate, shipmethod FROM shopcart WHERE MyCart = '#url.cart#' (/cfquery) Both Queries often come out with "old" data. Why is this data stuck? Why is this only happening with this info? Why am I being tortured like this? HELP!! _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Multiple conditions in a single CFIF statement.
So far I've only used single CFIF statements - hence don't know syntax for multiple conditions and haven't been able to find an example in the books I have. Can someone give me a hint or example of the CF syntax to do state the following condition: CFIF mTEST1 EQ "ABC" AND mTEST2 EQ "DEF" without using nested CFIF statements??? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
