OT: Access ODBC to SQL Server failing
Sorry for the way off topic post... but I'm not currently a member of a lot of lists, and this one has a few smart people who've done a lot of varied stuff. We've got a bit of a weird one here. We're using Access to connect to a SQL database (an Access VB app), and it completely gives up the ghost if the ODBC connection is interrupted temporarily. It refuses to reconnect at all unless you restart Access. Any ideas? David ~~ 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: I guess i was unclear...try this..
There is no such thing as a specific row, the order the records are returned
to you (the rows) is random and undefined, it makes very little sense to ask
'what is the value of 'firstname' in the 2nd row.
If you really wanted to (for debugging I guess), you could
cfscript
lookfor=2;
for(i=0;iqQuery.recordcount;i=i+1){
if (i eq lookfor){ output row }
}
-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 2:42 AM
To: CF-Talk
Subject: I guess i was unclear...try this..
I guess I was unclear. Let's suppose I have no interest in a specific value
like ID=3 but just want to know what is in a particular row and column. Am I
always stuck using a where statement having to look for a particular value?
I understand that a where statement can locate an instance of some
particular. I would just like to do a search on a row and a column in
general.
greg
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:20 PM
To: CF-Talk
Subject: RE: Thanks everyone but one last question
You can create whatever WHERE statement you wish to select whatever rows you
need from the DB
to get row 2, column 2:
SELECT password
FROM table
WHERE ID = 3
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:02 PM
To: CF-Talk
Subject: Thanks everyone but one last question
Thanks for the help on my newbie question. I learned a great deal believe it
or not. You were all kind.
Now one last question before I go back to the books.
See the database setup below.
ID PASSWORD FIRSTNAME LASTNAME
4 sdf greg landry
3 gth tom jones
Lets say I wanted to see what is in the second record and see what's under
the column FIRSTNAME. What I am learning is that I have to print out the
entire database to see what is in it. I would just like to be able to know
how to access a particular element in a database. Like what's in row 2,
column 2?
Thank you so much for your patience and time.
Greg "the ever curious newbie"
~~
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: The northern CFer
As someone about to embark on an intranet development with Content Management I can say totally objectively that you should release it open source, preferably within the next couple of weeks. I'm sure I'm not alone. -Original Message- From: Kent Bulmer [mailto:[EMAIL PROTECTED]] Sent: 19 March 2001 16:45 To: CF-Talk Subject: The northern CFer I was wondering if anyone could look at this for me: http://www.networkcentrix.com/cftalk/netcen.cfm It's just a few screen shots and some comments about a development system I've built over the past few years. I was just looking for some comments on it's usefulness to anyone else. I've tried a handful of Content Management systems (i.e. Spectra, Cartouzer, PaperThin, etc. -- none of them extensively) and I haven't seen the same type of features, but I'm willing to be corrected on this by any of you who would have a better knowledge of these systems, especially Spectra users. I've tried to convince people in my company that this would be a good CF development tool for other programmers. Just lookin' for ammo. I'm on the east end of Canada -- even some Canadians forget we exists so there's not much of a CF community around here. Any comments are appreciated. -- Kent Bulmer Application Developer BMG Consultants Inc. [EMAIL PROTECTED] pers: http://inkwell.bmgconsultants.com/ work: http://www.networkcentrix.com/ "...only visiting this planet..." (Larry Norman) ~~ 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:
Avrom, not sure about Linux but i have sybase on Sun Solaris, and for unix you need to installed a Sybase Client for CF to access Sybase DB. hope this help - Original Message - From: "Avrom" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 3:27 PM Hi! Anyone having problems with Sybase under Linux using CF 4.5? I am having discrepancies about the native drivers being/not being threadsafe and a lot "Sybase Connection Errors" intermittantly. -- Avrom 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: Coldfusion access to a DSN-less SQL 7.0 =
It is possible, as long as you have a dsn on the system pointing to a SQL 7.0 ds - then access tables etc. as #dbname#.dbo.#tablename# HTH Dan -Original Message- From: Winston Sia [mailto:[EMAIL PROTECTED]] Sent: 01 March 2001 02:51 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: This is a multi-part message in MIME format. --=_NextPart_000_003A_01C0A23D.8EED6040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI, Is it possible for Coldfusion to have access to a DSN-less SQL 7.0 = database? This DSN-less database is being used by our ASP templates. Now, we want = to use our CF templates to be able to access this same database.. Any = idea? Our webhost is Hostcentric (Virtualscape) so we would be asking them to = do for us what your recommendations will be.. TIA. Winston --=_NextPart_000_003A_01C0A23D.8EED6040 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 content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArialHI,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialIs it possible for Coldfusion to have access to = a DSN-less=20 SQL 7.0 database?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialThis DSN-less database is being used by our ASP = templates.=20 Now, we want to use our CF templates tonbsp; be able to access this = same=20 database.. Any idea?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialOur webhost is Hostcentric (Virtualscape) so we = would be=20 asking them to donbsp; for us what your recommendations will = be../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialTIA./FONT/DIV DIVFONT face=3DArialWinston/FONT/DIV/BODY/HTML --=_NextPart_000_003A_01C0A23D.8EED6040-- 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: Coldfusion access to a DSN-less SQL 7.0 =
this is not possible until CF 5 is released. There has to be an OLEDB dsn setup on the server. If this is done, you can pass the UID,PWD,DB Name, and the server name to access you database. HTH -- 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: Coldfusion access to a DSN-less SQL 7.0 =
see my previous reply -this is possible under odbc as long as you already have (and use) a ds already set up on the server (with associated login details etc...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 11:09 To: CF-Talk Subject: RE: Coldfusion access to a DSN-less SQL 7.0 = this is not possible until CF 5 is released. There has to be an OLEDB dsn setup on the server. If this is done, you can pass the UID,PWD,DB Name, and the server name to access you database. HTH -- 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: Coldfusion access to a DSN-less SQL 7.0 =
You are correct, but he is asking about DSN-less connections, which at this point is not possible. You can simulate DSN-less connections with a single OLEDB DSN, then you can connect to multiple databases just by changing the UID,PWD and other details. Your suggestion is not what this person is looking for - no offense. That is all I am saying. Clint ~~ 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: QUERY TROUBLE
I am using Access as a database and it does not support the PATINDEX function. Any
other thoughts?
Seva Petrov wrote:
Frederic,
You can try using PATINDEX to set a bit on the matching town and then order
on the results of the PATINDEX, which will return the town with the bit set
first:
cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC"
SELECT PATINDEX('#RMOTOWN#', T.RMOTown) as pmatch,
T.RMOTown as town, T.Chamberwebaddress as webad,
T.Cllustername, A.PrimaryName as pname, A.Description as descipt
,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
as
email, a.WebSite as web
FROM RMOTownName T, Attractions A
cfif LEN(trim(get_cluster.Cllustername)) gt 0
WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName
WHERE
RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
cfelse
WHERE T.RMOTown='#RMOTOWN# ' AND A.RMOTown=T.RMOTown
/cfif
order by pmatch DESC, by T.rmotown, A.PrimaryName
/cfquery
HTH,
Seva Petrov
I have a query that returns a list of attractions in a certain
town. If the town is in a "cluster" (a group of
related towns) it also needs to order by the selected town first
and then list the rest of the towns
alphabetically.
How would I get this output from the following queries?
cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC"
SELECT T.RMOTown, T.Cllustername
FROM RMOTownName T
WHERE T.RMOTown='#RMOTOWN#'
/cfquery
cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC"
SELECT T.RMOTown as town, T.Chamberwebaddress as webad,
T.Cllustername, A.PrimaryName as pname, A.Description as descipt
,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
as
email, a.WebSite as web
FROM RMOTownName T, Attractions A
cfif LEN(trim(get_cluster.Cllustername)) gt 0
WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName
WHERE
RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
cfelse
WHERE T.RMOTown='#RMOTOWN# ' AND A.RMOTown=T.RMOTown
/cfif
order by T.rmotown, A.PrimaryName
/cfquery
Is there something I can do in the ORDER BY clause that will
allow for this?
I know I can use an if statement in the output to output the selected
town's info first but this will probibaly mess with the way my
pagination through the results works and is not the
most efficient
method.
Thanks,
Frederic.
~~
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: @@identity
You need to use SET NOCOUNT ON / SET NOCOUNT OFF round your query to be able
to access the info in cfquery
e.g.
cfquery datasource="#request.dsn#"
name="qAddEntry"
SET NOCOUNT ON
INSERT INTO tblUsers(name, jobtitle,
company, address, town, postcode, countryID, email, website, password, hint,
maillist, brieflist, foundsiteID)
VALUES ('#form.name#', '#form.jobtitle#',
'#form.company#', '#form.address#',
'#form.town#','#form.postcode#',#form.countryID#, '#form.email#',
'#form.website#', '#form.password#', '#form.hint#', #maillist#, #brieflist#,
#form.foundsiteID#)
SELECT newID = @@IDENTITY
SET NOCOUNT OFF
/cfquery --
cfoutput#qAddEntry.newID#/cfoutput
this works.
HTH
Dan
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 20 March 2001 05:07
To: CF-Talk
Subject: RE: @@identity
When I do that CF says not a valid query specified.
-Original Message-
From: CF [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:04 AM
To: CF-Talk
Subject: Re: @@identity
You need to give your query a name. Instead cfquery name="", use cfquery
name="queryName". Then you just access that variable as:
queryName.identity
Also, I don't know it it matters to your database or not, but you might want
to put a ; at the end of your first query to differentiate it from the next
. just to avoid confusion.
Todd Ashworth
Web Application Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)
- Original Message -
From: "Joshua Tipton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:32 PM
Subject: @@identity
I know how to use @@identity to select the last inserted record right
under
an insert but how do I display that id of that record?
cfquery name="" datasource="gunledger" dbtype="ODBC"
INSERT INTO dbo.distrib(compname, phonenum, address, address2, city,
state,
zip, fflid, expires)
VALUES('#compname#', '#phonenum#', '#address#', '#address2#', '#city#',
'#state#', '#zip#', '#fflid#', '#expires#')
select @@identity as 'identity'
/cfquery
How do I output the identity
Josh
~~
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: Query Trouble
Bryan, This works for returning two separate result sets (one for the selected town and another for the clustered towns if available) The problem is that the client wants to be able to page through all the results of the clustered towns query starting with the actual town selected no matter where it falls alphabetically in the cluster. Then continue though the rest of the towns in alphabetical order. Unless I am missing something there is no way for me to actually page through a complete resultset here because if I am using the the first query the pagination will not continue after the last entry for the seleted town and if I page through the second resultset I will not be including the selected town information. Thanks, Frederic Bryan Love wrote: run two queries: The first one gets all info for the selected town and the second gets all info for towns of the same cluster (if it's not blank) but NOT for the selected town like so (set the select list to a variable so you don't have to mess with two queries later on): cfset selList = "T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress as email, a.WebSite as web, cllustername" cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT #preserveSingleQuotes(selList)# FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfif get_cluster.Cllustername IS NOT "" cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECT #preserveSingleQuotes(selList)# FROM RMOTownName T, Attractions A WHERE A.RMOTown=T.RMOTown AND T.RMOTown'#RMOTOWN#' AND Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') ORDER BY T.rmotown, A.PrimaryName /cfquery /cfif Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Freddy [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 3:50 PM To: CF-Talk Subject: QUERY TROUBLE I have a query that returns a list of attractions in a certain town. If the town is in a "cluster" (a group of related towns) it also needs to order by the selected town first and then list the rest of the towns alphabetically. How would I get this output from the following queries? cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown, T.Cllustername FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress as email, a.WebSite as web FROM RMOTownName T, Attractions A cfif LEN(trim(get_cluster.Cllustername)) gt 0 WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown cfelse WHERE T.RMOTown='#RMOTOWN# ' AND A.RMOTown=T.RMOTown /cfif order by T.rmotown, A.PrimaryName /cfquery Is there something I can do in the ORDER BY clause that will allow for this? I know I can use an if statement in the output to output the selected town's info first but this will probibaly mess with the way my pagination through the results works and is not the most efficient method. Thanks, Frederic. ~~ 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
Locale
Anyone had any problems with settting a Locale? I am using SQL server and Although I have explicitly set it as UK it seems to be stuff in US? What other params so I need to check? ~~ 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
error acessing a Paradox (*.DB) database
i have a paradox database associated to a datasource... right! but when a do a query like this: select * from cities i get the following error page: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Paradox Driver] External table is not in the expected format. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (9:49). What is going on? thanks... Anderson ~~ 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
passwrord protecting a page and hipping off to another
Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: link color
What do you want? Netscape to be IE 5.5 compatible??? Netscape 6 supports the DOM in a way far more compatible with the CSS guidelines than either Netscape 4 or IE 5. This does unfortuneately mean that code that worked in Nutscrape 4 and ie 5 probably wont work in NS6 If coded correctly accoring to the CSS standards, code that works in NS6 should normally work ok in IE5... I agree this is a big hassle for developers, but if everyone can work to the same standard, surely this is far better in the long run... Cheers Dan -Original Message- From: Mike Tyranski [mailto:[EMAIL PROTECTED]] Sent: 19 March 2001 23:25 To: CF-Talk Subject: Re: link color Dylan, I've seen Netscape 6 in action and I almost jumped out of my skin. Sites that had working DHTML for Netscape 4.X don't seem to work with Netscape 6. Maybe there is an option you need to turn on in Netscape 6, but I'm not sure. In my opinion, the Netscape browser lacks in support of DHTML as well as overall browser performance. On another note, your 3-layer DHTML menu sounds interesting. Is it on a public domain site that we could peek at? Thanks. Mike Dylan Bromby wrote: I've just built a 3-layer menu in DHTML that works well and didn't need any workarounds, so I would be hesitant to blame DHTML per se. The problem is Netscape 4.x doesn't follow the DOM very well, whereas IE 5/5.5 do a pretty good job. Netscape 6 is supposedly much better, but I haven't used it much. -Original Message- From: Mike Tyranski [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 1:29 PM To: CF-Talk Subject: Re: link color Robert, There is no sure fire way to do this in Netscape that I have found. There is some code at the link below that comes close though: http://www.webreference.com/js/column4/workaround.html This code relies on setting the position of a layer to absolute for every link you do this for. If you are positioning all of your content with DHTML, this might work OK, but I tend not to trust DHTML. Mike Robert Orlini wrote: Any CF tag or coding (even JavaScript) someone can spare out there that changes a color when a mouse goes over a link? It is similar to the DHTML and CSS that does it so well in IE, but would work in Netscape as well. Thanks. Robert O. HW Wilson ~~ 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: passwrord protecting a page and hipping off to another
just ise cflocation to redirect to the pages needed. ~~ 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: passwrord protecting a page and hipping off to another
there are lots of ways of achieving this, but they depend on your setup. Where is the other page? Is it on the same server? If not, is it on a server which would be able to read a domain cookie set on the first page? Are both pages ColdFusion scripts? Where are the usernames and passwords stored (DB, file, WinNT users), or is there just one username and password? Mark At 12:20 PM 3/20/2001, you wrote: Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: Sites on site architecture?
if you have any good links to sites that explain good site architecture planning i would appreciate it. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq:47658358 ~~ 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: passwrord protecting a page Got it..THANKS!
Thanks I think I'm all set. I'm using cfhttp METHOD=GET resolveurl="Yes" URL="http://www.blahblahblah"#CFHTTP.FileContent#/cfhttp inside and if then else. If the password and id (checked from an access database) are correct then the above tag is executed. This book I'm using "Mastering Cold Fusion 4.5" seems to answer all my questions but it's an issue of finding the correct sections. From the newbies, Greg -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:38 AM To: CF-Talk Subject: Re: passwrord protecting a page and hipping off to another there are lots of ways of achieving this, but they depend on your setup. Where is the other page? Is it on the same server? If not, is it on a server which would be able to read a domain cookie set on the first page? Are both pages ColdFusion scripts? Where are the usernames and passwords stored (DB, file, WinNT users), or is there just one username and password? Mark At 12:20 PM 3/20/2001, you wrote: Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: passwrord protecting a page Got it..THANKS!
if I understand you correctly, this leaves the URL you are getting with CFHTTP un-protected. At 12:49 PM 3/20/2001, you wrote: Thanks I think I'm all set. I'm using cfhttp METHOD=GET resolveurl="Yes" URL="http://www.blahblahblah"#CFHTTP.FileContent#/cfhttp inside and if then else. If the password and id (checked from an access database) are correct then the above tag is executed. This book I'm using "Mastering Cold Fusion 4.5" seems to answer all my questions but it's an issue of finding the correct sections. From the newbies, Greg -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:38 AM To: CF-Talk Subject: Re: passwrord protecting a page and hipping off to another there are lots of ways of achieving this, but they depend on your setup. Where is the other page? Is it on the same server? If not, is it on a server which would be able to read a domain cookie set on the first page? Are both pages ColdFusion scripts? Where are the usernames and passwords stored (DB, file, WinNT users), or is there just one username and password? Mark At 12:20 PM 3/20/2001, you wrote: Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: Locale
Have you set both CF and SQL server to use the same locale? At 12:24 PM 3/20/2001, you wrote: Anyone had any problems with settting a Locale? I am using SQL server and Although I have explicitly set it as UK it seems to be stuff in US? What other params so I need to check? ~~ 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 Books
thankswe will be using the 4.5 version...when I look online, Ben Forta's develpment books are for 4.0is 4.0 and 4.5 the same, or similar enough to where I can use the 4.0 version of the book? Julie Absolutely go for the recommendations already presented, particularly the Forta books which are the standard. But also take a look at 'ColdFusion - fasteasy web development', T.C.Bradley III, PrimaTech, ISBN0-7615-3016-9, $24.99. I stumbled across this book at BN. I was skeptical at first because of the title, however the more I looked at it the more I liked it, and I ended up buying it. It's a straightforward, concise book, written for CF 4.5.1, and it is built around screen shots of the code and the resulting outputs. Each screen shot has accompanying notes pointing to the appropriate section explaining what is happening. Bradley covers most, if not all, of the routine things one would normally want to do with Cold Fusion. For a beginner, especially, I think that this is an outstanding book and we will be giving a copy to each person here who is or will be doing Cold Fusion development. George [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Shopping carts
OK, now i have this splendiferous CF powered shopping cart superscript, anyone have a suggestion for a host/service to complete the transaction? specifically process the credit card? ~~ 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: Sites on site architecture?
Here are a few places that I have found useful: Web Page Design: Implications of Memory, Structure and Scent for Information Retrieval http://www.microsoft.com/usability/UEPostings/p25-larson.pdf IBM Design ... Keep It Simple http://www-3.ibm.com/ibm/easy/eou_ext.nsf/Publish/561 Usability Professional's Association http://www.upassoc.org/ WebWorld Usability Weblog http://www.webword.com/ Usable Web http://www.usableweb.com/ Evangelize with Usability http://www.uidesign.net/2000/papers/evangelize.html Usability.gov - powered by National Cancer Institute http://www.usability.gov/ User Interface Engineering http://world.std.com/~uieweb/ -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:47 AM To: CF-Talk Subject: OT: Sites on site architecture? if you have any good links to sites that explain good site architecture planning i would appreciate it. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq:47658358 ~~ 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: Shopping carts
authorize.net or if your business has a Bank of America account or can get one, their CC processing is a SNAP. -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:45 AM To: CF-Talk Subject: OT: Shopping carts OK, now i have this splendiferous CF powered shopping cart superscript, anyone have a suggestion for a host/service to complete the transaction? specifically process the credit card? ~~ 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
Mastering ColdFusion 4.5
Hello again! Since we are in the beginning of a revision to the Mastering book, I thought it might be good to ask this list for suggestions regarding improvements. One poster mentioned it is slower. I am not sure that this is the general consensus, as I have heard the opposite from many people, but if that happens to be your feeling as well, can you elaborate as to where it is slow? If you feel so inclined perhaps you can answer the following questions as well: 1. Which chapters did you find needed the most improvement? Why? For readability reasons or technical reasons? 2. Were there chapters or sections where the topic could have been more elaborate? Where? 3. Which chapters were the most useful? Did they provide knowledge you did not find elsewhere? 4. Did you find any technical problems in the book such as broken code, incorrect statements, misleading statements? Where? 5. What topics would you like to see covered that are not currently in this book? 6. Do you think this book addressed needs of the beginner developer, intermediate developer, or both? If only one or the other can you explain why? 7. Did you find typos or grammatical errors? Where? 8. Were the examples appropriate? If not, do you have suggestions for better examples? Ok, I know most of you are extremely busy, so if you do not have the time to answer all of the above questions, but would like to respond in some way, please do. But please respond off this list to my personal account: mailto:[EMAIL PROTECTED]. If the comments pertain to my chapters I will seriously consider them while updating, and if not I will forward them to either Arman or Raymond. Thanks for your time! -- Kristin Aileen Motlagh http://www.falkondesign.com Co-Author, Mastering ColdFusion 4.5 Allaire Certified ColdFusion Developer mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Locale
I wasn't aware CF server has a Locale? u mean the box or the actual software? N ~~ 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: Mastering ColdFusion 4.5
If your prepared to send me a free copy, I'll happilly answer all your questions :) -Original Message- From: Kristin Aileen Motlagh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 14:07 To: CF-Talk Subject: Mastering ColdFusion 4.5 Hello again! Since we are in the beginning of a revision to the Mastering book, I thought it might be good to ask this list for suggestions regarding improvements. One poster mentioned it is slower. I am not sure that this is the general consensus, as I have heard the opposite from many people, but if that happens to be your feeling as well, can you elaborate as to where it is slow? If you feel so inclined perhaps you can answer the following questions as well: 1. Which chapters did you find needed the most improvement? Why? For readability reasons or technical reasons? 2. Were there chapters or sections where the topic could have been more elaborate? Where? 3. Which chapters were the most useful? Did they provide knowledge you did not find elsewhere? 4. Did you find any technical problems in the book such as broken code, incorrect statements, misleading statements? Where? 5. What topics would you like to see covered that are not currently in this book? 6. Do you think this book addressed needs of the beginner developer, intermediate developer, or both? If only one or the other can you explain why? 7. Did you find typos or grammatical errors? Where? 8. Were the examples appropriate? If not, do you have suggestions for better examples? Ok, I know most of you are extremely busy, so if you do not have the time to answer all of the above questions, but would like to respond in some way, please do. But please respond off this list to my personal account: mailto:[EMAIL PROTECTED]. If the comments pertain to my chapters I will seriously consider them while updating, and if not I will forward them to either Arman or Raymond. Thanks for your time! -- Kristin Aileen Motlagh http://www.falkondesign.com Co-Author, Mastering ColdFusion 4.5 Allaire Certified ColdFusion Developer mailto:[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: Shopping carts
Please tell me more about BofA best, paul At 08:02 AM 3/20/01 -0600, you wrote: authorize.net or if your business has a Bank of America account or can get one, their CC processing is a SNAP. ~~ 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
Advanced Previous/Next-Records Navigation
Hi fellows, i have the following problem. On one of my sites I have result-pages for querys where a lot of records may be outputted. Now I want to include a Previos/Next-Navigation with 25 records displayed per page. The problem is that the query is grouped by two columns before the actual record is displayed. So i don't have the ability to work with the standard approach with limiting the output via cfoutput query="foo" startrow="#start#" maxrows="25" because only the outer two grouped cfoutputs use the query-attribute. I hope someone does understand what I mean and can help me. Below is the adress of the mentioned site called Teilemax.de. There you can enter a space in the formfield "Schnellsuche" (quicksearch) and you get the result-page. For the coders out there I would also send my code off-list 'cause I think it would blow this mail. -- thanx in advance Patric Stumpe Knust Stumpe Datentechnik Abt. Webdesign mail: [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: QUERY TROUBLE
Try this: I have added an additional column which test for the value of RMOTown and outputs a 0 if it matches otherwise a 1. The same column is added to the order by. This should work in Access. cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown, T.Cllustername FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECTiif(T.RMOTown='#RMOTOWN#',0,1) as FirstSort, T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt, a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone, EMailAddress as email, a.WebSite as web FROM RMOTownName T, Attractions A cfif LEN(trim(get_cluster.Cllustername)) gt 0 WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown cfelse WHERE T.RMOTown='#RMOTOWN#' AND A.RMOTown=T.RMOTown /cfif order by iif(T.RMOTown='#RMOTOWN#',0,1), T.rmotown, A.PrimaryName /cfquery -Original Message- From: Freddy [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 6:50 PM To: CF-Talk Subject: QUERY TROUBLE I have a query that returns a list of attractions in a certain town. If the town is in a "cluster" (a group of related towns) it also needs to order by the selected town first and then list the rest of the towns alphabetically. How would I get this output from the following queries? cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown, T.Cllustername FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress as email, a.WebSite as web FROM RMOTownName T, Attractions A cfif LEN(trim(get_cluster.Cllustername)) gt 0 WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown cfelse WHERE T.RMOTown='#RMOTOWN# ' AND A.RMOTown=T.RMOTown /cfif order by T.rmotown, A.PrimaryName /cfquery Is there something I can do in the ORDER BY clause that will allow for this? I know I can use an if statement in the output to output the selected town's info first but this will probibaly mess with the way my pagination through the results works and is not the most efficient method. Thanks, Frederic. ~~ 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: Mastering ColdFusion 4.5
And me ... -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 14:13 To: CF-Talk Subject: RE: Mastering ColdFusion 4.5 If your prepared to send me a free copy, I'll happilly answer all your questions :) -Original Message- From: Kristin Aileen Motlagh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 14:07 To: CF-Talk Subject: Mastering ColdFusion 4.5 Hello again! Since we are in the beginning of a revision to the Mastering book, I thought it might be good to ask this list for suggestions regarding improvements. One poster mentioned it is slower. I am not sure that this is the general consensus, as I have heard the opposite from many people, but if that happens to be your feeling as well, can you elaborate as to where it is slow? If you feel so inclined perhaps you can answer the following questions as well: 1. Which chapters did you find needed the most improvement? Why? For readability reasons or technical reasons? 2. Were there chapters or sections where the topic could have been more elaborate? Where? 3. Which chapters were the most useful? Did they provide knowledge you did not find elsewhere? 4. Did you find any technical problems in the book such as broken code, incorrect statements, misleading statements? Where? 5. What topics would you like to see covered that are not currently in this book? 6. Do you think this book addressed needs of the beginner developer, intermediate developer, or both? If only one or the other can you explain why? 7. Did you find typos or grammatical errors? Where? 8. Were the examples appropriate? If not, do you have suggestions for better examples? Ok, I know most of you are extremely busy, so if you do not have the time to answer all of the above questions, but would like to respond in some way, please do. But please respond off this list to my personal account: mailto:[EMAIL PROTECTED]. If the comments pertain to my chapters I will seriously consider them while updating, and if not I will forward them to either Arman or Raymond. Thanks for your time! -- Kristin Aileen Motlagh http://www.falkondesign.com Co-Author, Mastering ColdFusion 4.5 Allaire Certified ColdFusion Developer mailto:[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
OT: Image library categories
I'm building an image library application and need to lay my hands on a ready-made directory to categorise the images that we're storing. Does anyone know where such an animal can be found? A database would be ideal, but I could always populate one via a template, if the source format made it easy. TIA -- 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: Shopping carts
Paul if you go to http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_set tle.cfm (B of A uses CF, not exclusively however) you will notice the option for "settle up". (They also offer another version called "branded", but it doesn't allow seamless integration with your current site design.) The requirements for "Settle Up" are: $200 application processing fee $19.95 minimum monthly (if you don't meet your minimum charge amount, which is standard on most Merchant Accounts.) Business Background/Credit Check SSL on your site The Discount rate will vary (sounds like something a bank would say). The process works like most CC processors: 1. Gather payor info. 2. Submit payor info to central server of processor (B of A). 3. processor returns transaction information for your pay app to parse. Most jr. level CFers could do this in less than a day (no offense to others, and especially to those sensitive jr. CFers). I also give B of A high marks for customer service, but you should know that I've been using this for only 3 months. NO problems yet! HTH Greg -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 8:21 AM To: CF-Talk Subject: RE: Shopping carts Please tell me more about BofA best, paul At 08:02 AM 3/20/01 -0600, you wrote: authorize.net or if your business has a Bank of America account or can get one, their CC processing is a SNAP. ~~ 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
MS Access and SQL
Hello! I've inherited an Access database where someone used the query designer to create a table based on the following query: SELECT Field5, First(Field1), First(Field2), First(Field3),... FROM Datatable GROUP BY Field5 As near as I can tell, the "First()" function is not standard SQL. I think that what they were trying to accomplish could be done by saying: SELECT DISTINCT Field5, Field1, Field2, Field3,... FROM Datatable GROUP BY Field5 (although I think this accomplishes nothing). Any ideas? Thx ~~ 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
SQL Cross-Tab / TRANSFORM
Hey everyone - I have a question about Cold Fusion and trying to read the Column name off of a Cross-Tab (MS SQL Server 7). I can generate the cross-tab without a problem, and if you look at the query output in Access, it correctly identifies the 11th and 12th Columns as Fax and Phone. But I cannot seem to name them, and Cold Fusion will not recognize the names of the columns. IE: Error resolving parameter CLIENTSEARCH.PHONE The column PHONE is not present in the query named CLIENTSEARCH. It is likely that you have misspelled the name of the column. It asctually is there, dynamically being named on the fly. Is there a way for Cold Fusion to recognize the columns? TRANSFORM First(A.Phone) AS Phone SELECT A.ClientID, A.ClientName, A.FullName, A.City, A.State, A.Zip, A.Email, A.Title, A.CreateDate, A.UpdateDate, A.contactStatus FROM (SELECT Clients.ClientID, Clients.ClientName, [ClientContacts].[FirstName]+' '+[ClientContacts].[LastName] AS FullName, ClientContacts.City, ClientContacts.State, ClientContacts.Email, ClientContacts.Title, ClientContacts.CreateDate, ClientContacts.UpdateDate, ClientContacts.StatusID AS contactStatus, ContactPhones.Phone, PhoneTypes.Type FROM (ClientContacts INNER JOIN Clients ON ClientContacts.ClientID = Clients.ClientID) INNER JOIN (PhoneTypes INNER JOIN ContactPhones ON PhoneTypes.TypeID = ContactPhones.TypeID) ON ClientContacts.ContactID = ContactPhones.ContactID) AS A WHERE (blah blah stuff goes here etc.) Thanks for your time, Stephen R. Cassady [EMAIL PROTECTED] http://www.tallylist.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QUERY TROUBLE
Thanks that did the trick. "Howarth, Craig (IBK-NY)" wrote: Try this: I have added an additional column which test for the value of RMOTown and outputs a 0 if it matches otherwise a 1. The same column is added to the order by. This should work in Access. cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown, T.Cllustername FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECTiif(T.RMOTown='#RMOTOWN#',0,1) as FirstSort, T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt, a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone, EMailAddress as email, a.WebSite as web FROM RMOTownName T, Attractions A cfif LEN(trim(get_cluster.Cllustername)) gt 0 WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown cfelse WHERE T.RMOTown='#RMOTOWN#' AND A.RMOTown=T.RMOTown /cfif order by iif(T.RMOTown='#RMOTOWN#',0,1), T.rmotown, A.PrimaryName /cfquery -Original Message- From: Freddy [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 6:50 PM To: CF-Talk Subject: QUERY TROUBLE I have a query that returns a list of attractions in a certain town. If the town is in a "cluster" (a group of related towns) it also needs to order by the selected town first and then list the rest of the towns alphabetically. How would I get this output from the following queries? cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown, T.Cllustername FROM RMOTownName T WHERE T.RMOTown='#RMOTOWN#' /cfquery cfquery name="get_1" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown as town, T.Chamberwebaddress as webad, T.Cllustername, A.PrimaryName as pname, A.Description as descipt ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress as email, a.WebSite as web FROM RMOTownName T, Attractions A cfif LEN(trim(get_cluster.Cllustername)) gt 0 WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown cfelse WHERE T.RMOTown='#RMOTOWN# ' AND A.RMOTown=T.RMOTown /cfif order by T.rmotown, A.PrimaryName /cfquery Is there something I can do in the ORDER BY clause that will allow for this? I know I can use an if statement in the output to output the selected town's info first but this will probibaly mess with the way my pagination through the results works and is not the most efficient method. Thanks, Frederic. ~~ 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 Cross-Tab / TRANSFORM
Hey everyone - I have a question about Cold Fusion and trying to read the Column name off of a Cross-Tab (MS SQL Server 7). I can generate the cross-tab without a problem, and if you look at the query output in Access, it correctly identifies the 11th and 12th Columns as Fax and Phone. My guess is that you're running this query through Access itself, right? To the best of my knowledge, SQL Server 7 doesn't support the use of TRANSFORM. When you query the database from CF, are you using CF to talk to the SQL server through an Access linked table? 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 Authorware
Does anyone have any experience using Cold Fusion with Macromedia's Authorware product to build an online training course with Cold Fusion handling the ODBC storing and reporting of data from training sessions? Terry Troxel ~~ 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: Read part of a string
Look at the list functions (your values can be thought of as lists, delimited by "/") as well as the GetToken function. -Original Message- From: Michael Gribbin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 1:13 AM To: CF-Talk Subject: Read part of a string Hi, I need to compare the first 4 characters of a product code "BA01/ABC" with the first 4 characters of the next product code in sequence "BA01/DEF" to see if they belong to the same group. How do I "read" only those first 4 characters of each product code? Thanks in advance, Michael Gribbin Digital Marketing Alliance ~~ 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 Cross-Tab / TRANSFORM
Well ;-) We're using SQL 7 for all the database work, but we want to combine some tables (doing mods on a 3rd party program). We thought to use Transform/Pivot. That avoids running hundered of queries on a page (or even an additional 50) because of a funny table structure. We approched the problem by building the Transform Query in ACCESS (their little wizards!) and then utilizing it in the CF code to access the SQL7 server. So, that's how I can see the columns being properly named, but me hair is falling out at being inable to utilize the information. If it's a MS SQL 7 situation - then at least I know it's time to take a different approach! Stephen [EMAIL PROTECTED] http://www.tallylist.com -- Original Message -- From: Dave Watts [EMAIL PROTECTED] Date: Tue, 20 Mar 2001 10:49:06 -0500 Hey everyone - I have a question about Cold Fusion and trying to read the Column name off of a Cross-Tab (MS SQL Server 7). I can generate the cross-tab without a problem, and if you look at the query output in Access, it correctly identifies the 11th and 12th Columns as Fax and Phone. My guess is that you're running this query through Access itself, right? To the best of my knowledge, SQL Server 7 doesn't support the use of TRANSFORM. When you query the database from CF, are you using CF to talk to the SQL server through an Access linked table? 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
Authorize.net
Is there any way to test an app I built with the Authorize.net tag without actually having an account with them? Rich ~~ 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: White space
Recently I debugged a site search application that was crashing IE 5 when the results set returned. This search worked in Netscape but took a long time for the browser to render the page, even though the page did not exceed 150-200k. Looking at the generated source code I found that there were large blocks of white space. When I cleaned up the code to cut down on the white space using CFSILENT around CF Code, IE stopped crashing and the rendering time in netscrape noticeably improved. my two cents - Paul ~~ 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
server setup
Does anyone have or know of references for setting up a webserver with CF? I have be using CF for 3 years, but have never been solely responsible for the server setup and management. A checklist/greatest hits would suffice, but as many KB articles, other articles, tips, tricks, etc. would be greatly appreciated. TIA Greg ~~ 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: @@identity
There is an issue with @@identity in MS-SQL. From MS-SQL help:
@@IDENTITY returns the last identity value generated in "any table" in the
current session. (Quotations mine).
If you have any INSERT triggers on your table that perform INSERTS on other
tables, @@identity will return the identity of the last insert in your
triggers, rather than the one you want.
MS-SQL 2000 has a new function to deal with the issue called SCOPE_IDENTITY,
which "Returns the last IDENTITY value inserted into an IDENTITY column in
the same scope."
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 6:06 AM
To: CF-Talk
Subject: RE: @@identity
You need to use SET NOCOUNT ON / SET NOCOUNT OFF round your query to be able
to access the info in cfquery
e.g.
cfquery datasource="#request.dsn#"
name="qAddEntry"
SET NOCOUNT ON
INSERT INTO tblUsers(name, jobtitle,
company, address, town, postcode, countryID, email, website, password, hint,
maillist, brieflist, foundsiteID)
VALUES ('#form.name#', '#form.jobtitle#',
'#form.company#', '#form.address#',
'#form.town#','#form.postcode#',#form.countryID#, '#form.email#',
'#form.website#', '#form.password#', '#form.hint#', #maillist#, #brieflist#,
#form.foundsiteID#)
SELECT newID = @@IDENTITY
SET NOCOUNT OFF
/cfquery --
cfoutput#qAddEntry.newID#/cfoutput
this works.
HTH
Dan
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 20 March 2001 05:07
To: CF-Talk
Subject: RE: @@identity
When I do that CF says not a valid query specified.
-Original Message-
From: CF [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:04 AM
To: CF-Talk
Subject: Re: @@identity
You need to give your query a name. Instead cfquery name="", use cfquery
name="queryName". Then you just access that variable as:
queryName.identity
Also, I don't know it it matters to your database or not, but you might want
to put a ; at the end of your first query to differentiate it from the next
.. just to avoid confusion.
Todd Ashworth
Web Application Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)
- Original Message -
From: "Joshua Tipton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:32 PM
Subject: @@identity
I know how to use @@identity to select the last inserted record right
under
an insert but how do I display that id of that record?
cfquery name="" datasource="gunledger" dbtype="ODBC"
INSERT INTO dbo.distrib(compname, phonenum, address, address2, city,
state,
zip, fflid, expires)
VALUES('#compname#', '#phonenum#', '#address#', '#address2#', '#city#',
'#state#', '#zip#', '#fflid#', '#expires#')
select @@identity as 'identity'
/cfquery
How do I output the identity
Josh
~~
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 and Authorware
I haven't yet but I do use Authorware. I believe there are examples around. I think it's a matter of using the posturl function in AW to a CF page. Let me look around. Have you posted to the AWARE list? Doug Kronenberger Department of Veterans Affairs [EMAIL PROTECTED] -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: CF-Talk Subject: CF and Authorware Does anyone have any experience using Cold Fusion with Macromedia's Authorware product to build an online training course with Cold Fusion handling the ODBC storing and reporting of data from training sessions? Terry Troxel ~~ 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
Browser is caching files even when I use META tags to prevent cac hing.
Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" META http-equiv="pragma" content="nocache" META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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
incrementer
seems like a gimme but...is where id is integer and the primary key insert into mytable (id,col1,col2) values ((select max(id) from mytable+1),col1val,col2val) can you do that and is it a legit way to get a primary key? ~~ 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: Browser is caching files even when I use META tags to prevent cac hing.
pragma="no-cache" Kevin Gilchrist [EMAIL PROTECTED] on 03/20/2001 10:26:21 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc:(bcc: Savan Thongvanh/DSM/Seabury) Subject: Browser is caching files even when I use META tags to prevent cac hing. Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" META http-equiv="pragma" content="nocache" META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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: Browser is caching files even when I use META tags to prevent cac hing.
I've herd of problems like this when using IE 5.0. What browser are you testing this app on? ---=@ greg @=-- - Original Message - From: "Kevin Gilchrist" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 11:26 AM Subject: Browser is caching files even when I use META tags to prevent cac hing. Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" META http-equiv="pragma" content="nocache" META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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
no-cache
woopsie, http-equiv="pragma" content="no-cache" ~~ 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: incrementer
It depends on the database you are using. The best way is to let the database do your incrementing for you. Clint ~~ 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 Cross-Tab / TRANSFORM
We're using SQL 7 for all the database work, but we want to combine some tables (doing mods on a 3rd party program). We thought to use Transform/Pivot. That avoids running hundered of queries on a page (or even an additional 50) because of a funny table structure. We approched the problem by building the Transform Query in ACCESS (their little wizards!) and then utilizing it in the CF code to access the SQL7 server. So, that's how I can see the columns being properly named, but me hair is falling out at being inable to utilize the information. If it's a MS SQL 7 situation - then at least I know it's time to take a different approach! You might try building a cross-tab query using T-SQL, instead. You can use the CASE function for this. There's an example in SQL Server Books Online, which you probably have installed on your SQL Server, or can get in Windows HTML Help format here: http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe 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
RE: incrementer
It would depend on what database you are writing to: for example if access then use autonumber and make the id the primary key - this will increment automatically for you - if using MS Squirrel then when creating the table choose integer as datatype, untick allow nulls and tick identity - identity seed and identity increment should then both have 1 in - etc. etc. Also, I don't think that your code will work as you should not be able to read and insert simultaneously from a table (?) - but the idea is good - if you can't get your datasource to increment for you (which you should let it do if it can) then query the table first with your select max stuff - create a cfset which increments the maxid by one and stuff that variable into your code at "id" instead - though I'm sure others will tell you a neater way of doing it without using two queries!!! ;) James "The Force is strong in this one..." - Darth Vader -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 16:25 To: CF-Talk Subject: incrementer seems like a gimme but...is where id is integer and the primary key insert into mytable (id,col1,col2) values ((select max(id) from mytable+1),col1val,col2val) can you do that and is it a legit way to get a primary key? ~~ 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: Browser is caching files even when I use META tags to prevent cac hing.
Meat tags do not always clear the cache. It is best if this is sent as an HTTP header. cfheader name="Expires" value="#now()#" I believe is the correct syntax Also in some web servers you can add HTTP headers to all requests. If you like everything including images to not be cached this would be the way to go. At 11:26 AM 3/20/2001 -0500, you wrote: Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" DEFANGED_OnClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: DEFANGED_META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" DEFANGED_META http-equiv="pragma" content="nocache" DEFANGED_META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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
(new) URL strings keep appending to the previous request's string s (Was) Browser is caching files even when I use META tags to prevent cac hing.
Did some debugging with the cf_debug tag and have found some weird goings on. I found out that when I click on a second table row it appends it's query strings to the previous query string. What I end up with is this: CGI.QUERY_STRING: unique_no=112945Edit_ID=40?unique_no=112945Edit_ID=39? or if I click on four rows, the forth click requests sends a query string where evrything is repeated four times? CGI.QUERY_STRING: unique_no=112945Edit_ID=40?unique_no=112945Edit_ID=39?unique_no=112945Edi t_ID=38?unique_no=112945Edit_ID=37 How does this happen? I did a view source of the table and it doesn't these repetitions in it's code.It still reads: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:26 AM To: CF-Talk Subject: Browser is caching files even when I use META tags to prevent cac hing. Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" META http-equiv="pragma" content="nocache" META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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: Browser is caching files even when I use META tags to prevent caching.
I'm using IE 5.5 -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: Re: Browser is caching files even when I use META tags to prevent cac hing. I've heard of problems like this when using IE 5.0. What browser are you testing this app on? ~~ 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 ORACLE
This is a multi-part message in MIME format. --5487AC23954301E34319E9FB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all - I am a senior in the Bachelor of Information Systems program at St. Francis Xavier University [http://www.stfx.ca] in Antigonish, NS. For a course project (Info 475 - Databases), my project team (myself, Melanie MacCulloch [[EMAIL PROTECTED]], Nadine Benoit [[EMAIL PROTECTED]] and Jason Hatfield [[EMAIL PROTECTED]]) is to create a database in Oracle and collect survey data through CF forms. I have used CF before for data collection with an Access database; however have no experience in setting up an Oracle datasource. We're concerned about setting up our database and how to go about logging into our database to insert data through CF... can anyone point us to an info source (FAQ), etc.? Thanks!! -Jamie http://www.stfx.ca/people/x97/x97gfq --5487AC23954301E34319E9FB Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Symonds, Jamie Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Jamie Symonds n: Symonds;Jamie adr:Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada email;internet: [EMAIL PROTECTED] title: Bachelor of Information Systems, Major (student) x-mozilla-cpt: ;0 x-mozilla-html: TRUE version:2.1 end:vcard --5487AC23954301E34319E9FB-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Authorware
There is some good information on the MacroMedia site: http://www.macromedia.com/support/authorware/tracking/AW5DATA/ http://www.macromedia.com/support/authorware/ts/documents/post_url.htm Doug Kronenberger Department of Veterans Affairs [EMAIL PROTECTED] -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: CF-Talk Subject: CF and Authorware Does anyone have any experience using Cold Fusion with Macromedia's Authorware product to build an online training course with Cold Fusion handling the ODBC storing and reporting of data from training sessions? Terry Troxel ~~ 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
DB structure advice
This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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: Read part of a string
Another option is to use the Mid() function cfset temp = Mid(productcode, 1, 4) This grabs the first 4 characters of the varaible produdcode and sets them to a temporary variable. You could then, theoretically use that temp variable in a comparison. |-Original Message- |From: Hayes, David [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 20, 2001 10:58 AM |To: CF-Talk |Subject: RE: Read part of a string | | |Look at the list functions (your values can be thought of as lists, |delimited by "/") as well as the GetToken function. | |-Original Message- |From: Michael Gribbin [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 20, 2001 1:13 AM |To: CF-Talk |Subject: Read part of a string | | |Hi, I need to compare the first 4 characters of a product code |"BA01/ABC" |with the first 4 characters of the next product code in |sequence "BA01/DEF" |to see if they belong to the same group. How do I "read" only |those first 4 |characters of each product code? | |Thanks in advance, | |Michael Gribbin |Digital Marketing Alliance | ~~ 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: no-cache
Changed it and it didn't seem to make a difference -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: no-cache woopsie, http-equiv="pragma" content="no-cache" ~~ 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: Shopping carts
Thanks! best, paul At 08:46 AM 3/20/01 -0600, you wrote: if you go to http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_set tle.cfm (B of A uses CF, not exclusively however) you will notice the option for "settle up". (They also offer another version called "branded", but it doesn't allow seamless integration with your current site design.) ~~ 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 Content (help)
So now the surfcam image's src points to image.cfm instead of the actual
image.
Anyway, it seems to work great except for one small problem.
I guess since the site is under heavy traffic, it doesn't work all
the time, we've been getting strange errors and inetinfo.exe on the
server is maxing out at 100%. This is starting to happen like every 10
minutes or so.
We experimented with using CFCONTENT to deliver multiple images dynamically,
and had similarly depressing results under load. In our tests, a single page
containing 10 images (15k each) was hit appx. once every three seconds. This
was enough to max out the available threads on our server.
It may be by tuning your server (upping the max thread count, etc) you could
get better performance. The issue *seems* to be more one of thread life and
volume than processor load. And I would be interested to hear more about
best practices with CFCONTENT (Dave Watts, are you listening?) In the
meantime, however, I would suggest going to one of the following setups:
If you update your image every 15 seconds or so, why not name it a random
name each time that you generate it? Generate it in a secure portion of your
site, then copy it using a random name into your web root. Store the random
name in application or server scope, then have your pages use that variable
in their src attributes. Make sure to clear the directory each time of your
previous images.
You could also put it in a protected directory and manage access through CF
Advanced Security.
Michael Caulfield
-Original Message-
From: Cody Estes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:23 AM
To: CF-Talk
Subject: CF Content (help)
I hope you guys can help me figure this one out. I'm trying to prevent
people from linking to our surfcam that we have pointed at the beach. So I
made an image.cfm file that contains code that will prevent them from
getting the 'correct' image if they aren't viewing it from our site (it
checks the referer, see code below). So now the surfcam image's src points
to image.cfm instead of the actual image.
Anyway, it seems to work great except for one small problem. I guess since
the site is under heavy traffic, it doesn't work all the time, we've been
getting strange errors and inetinfo.exe on the server is maxing out at 100%.
This is starting to happen like every 10 minutes or so. I can't figure out
the problem since the code works on my development machine and it seems like
it 'should' work no matter what.
Have you guys experienced anything like this? Is there something I'm not
setting right in the CF Header or CF Content? I've attatched the code from
my image.cfm tag below. Thanks for any help in advance!!
___ Code Below for image.cfm
cfsetting enablecfoutputonly="yes"
cfif CGI.HTTP_Referer contains "mydomain.com"
cfheader name="Content-Disposition"
value="inline;filename=""beachcam.jpg"""
cfif fileexists("c:\inetpub\wwwroot\www\beachcam.jpg")
cfcontent type="image/jpeg" file="c:\inetpub\wwwroot\www\beachcam.jpg"
/cfif
cfelse
cfheader name="Content-Disposition" value="inline;filename=""bad.jpg"""
cfcontent type="image/jpeg" file="c:\inetpub\wwwroot\www\bad.jpg"
/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
RE: CF and ORACLE
http://technet.oracle.com ** 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: (new) URL strings keep appending to the previous request's st rings
So the pages aren't being cached but it looks like the receiving page in the bottom pane is passed a query string that remembers the previous query string and appends the latest to it. For click one the string becomes: unique_no=112945Edit_ID=39 For click two: unique_no=112945Edit_ID=40?unique_no=112945Edit_ID=39 For click three : unique_no=112945Edit_ID=41?unique_no=112945Edit_ID=40?unique_no=112945Edi t_ID=39 and so on. The receiving page only processes the Edit_ID url variable at the very end of the query string and so never changes when I click on a new row. Anyone know how this might happen? I'm using IIS 5.0., IE 5.5. Thanks, Kevin ~~ 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: incrementer
I've always heard bad things about auto-number fields, but I use them anyway... But one thing I've seen is to make a table in your database, call it nextid or something and put two columns, tablename and id. Store the next id for each table in the id column...Update it within a transaction after any insert. So when you go to insert: insert into mytable (id,col1,col2) values ((select id from nextid where tablename = mytable),col1val,col2val) then: update nextid setup id = id + 1 where tablename = mytable depend on what database you are writing to: for example if access then use autonumber and make the id the primary key - this will increment automatically for you - if using MS Squirrel then when creating the table choose integer as datatype, untick allow nulls and tick identity - identity seed and identity increment should then both have 1 in - etc. etc. Also, I don't think that your code will work as you should not be able to read and insert simultaneously from a table (?) - but the idea is good - if you can't get your datasource to increment for you (which you should let it do if it can) then query the table first with your select max stuff - create a cfset which increments the maxid by one and stuff that variable into your code at "id" instead - though I'm sure others will tell you a neater way of doing it without using two queries!!! ;) James "The Force is strong in this one..." - Darth Vader -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 16:25 To: CF-Talk Subject: incrementer seems like a gimme but...is where id is integer and the primary key insert into mytable (id,col1,col2) values ((select max(id) from mytable+1),col1val,col2val) can you do that and is it a legit way to get a primary key? ~~ 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 and Authorware
Douglas, I am pretty well versed in Cold Fusion, but just looking at purchasing Authorware for a project I have had thrown at me if I can connect the two. I would appreciate any examples of any type of interactivity between the two products you could share with me. I need to do this one of two ways. Distribute test cds to a facility that upload the test data to a website to warehouse the data for grading etc. or having the whole application online. I like the looks of the Authorware product so far, but have not seen any examples of database connectivity. I plan on going out tonite and purchase a book called Authorware 5 Authorized w/CD Rom that comes with an evaluation version of authorware and instructions, and get my feet wet so to speak. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 8:32 AM Subject: RE: CF and Authorware I haven't yet but I do use Authorware. I believe there are examples around. I think it's a matter of using the posturl function in AW to a CF page. Let me look around. Have you posted to the AWARE list? Doug Kronenberger Department of Veterans Affairs [EMAIL PROTECTED] -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:40 AM To: CF-Talk Subject: CF and Authorware Does anyone have any experience using Cold Fusion with Macromedia's Authorware product to build an online training course with Cold Fusion handling the ODBC storing and reporting of data from training sessions? Terry Troxel ~~ 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 structure advice
Personally i would make a series of tables to deal with this type of information that ties back to each user via Primary Key identifier like this Table Name : People Primary Key : PersonID Table Name : Education Primary Key : EducationID Tied with People Table via PersonID Field Table Name : JobStatus Primary Key : JobStatusID Tied with People Table via PersonID Field etc, etc, etc it will make it a lot eaiser in the long run for scalability when adding even more fields to databases as well as multiple records over time, what if the person has 2 degrees from different institutions? Or what if you want to keep track of that persons Job history? Multiple records in a seperate table will be much eaiser to track and query than running into comma delimited fields in one column of a table just my .02 kevin -- Original Message -- From: "Jason Lotz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 20 Mar 2001 09:52:01 -0700 This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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 structure advice
I would break it into smaller tables. One issue is size - you don't want to store a lot of empty fields. Create each table, and use a primary key ID field to link them. Just remember that when you want a record set with all the data, you will need to use LEFT JOIN in order for the result set to include the members who don't have records in the optional tables. -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:52 AM To: CF-Talk Subject: DB structure advice This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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: Browser is caching files even when I use META tags to prevent cac hing.
Some of our clients had this problem and we found out it was there proxy server. Ric Smith -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: Re: Browser is caching files even when I use META tags to prevent cac hing. I've herd of problems like this when using IE 5.0. What browser are you testing this app on? ---=@ greg @=-- - Original Message - From: "Kevin Gilchrist" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 11:26 AM Subject: Browser is caching files even when I use META tags to prevent cac hing. Hi all, I'm developing a small intranet app where I have two panes, a top-half and bottom-half. The top frame contains a table where a user can click on a cell and it triggers an update to the bottom frame. This only works for the first time a user clicks on a cell. Each row has a unique primary key field that I insert into the URL as Edit_ID. The table cell code looks like this: td class="text" onClick="top.data_pane.location.pathname='/maintenance/add_project-form.cfm? Edit_ID=42';"nbsp;Test6 /TD I also have the following meta tags at the top of each page: META http-equiv="expires" content="Thu, 1 October 1998 00:00:00 PST" META http-equiv="pragma" content="nocache" META http-equiv="cache-control" content="no-cache" Is there something I'm missing? Thanks, Kevin ~~ 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 structure advice
This is what's referred to as an entity type hierarchy in data modelling terms. The "proper" way to model these is to create a supertype table that contains attributes that are common to all members, and then to create multiple subtype tables that contain information that is specific to a particular type of member (e.g., college graduates). Each of these tables will have the same primary key (e.g., MemberId), so you can join as many of them as you like. If it turns out that you have a lot of common attributes (that apply to all members), and only a few specific attributes, it is not uncommon to just create one big table to hold everything. From a programming perspective there is very little difference to the two approaches (except that you avoid joins with the latter approach), so it's really an issue that a DBA should decide. Hope that helps, Bob -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: March 20, 2001 11:52 AM To: CF-Talk Subject: DB structure advice This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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 and ORACLE
Has a little Oracle info but a fair bit of generic DB information. http://www.thenetprofits.co.uk/coldfusion/faq/ ~~ 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 Cross-Tab / TRANSFORM
In case you haven't found an example yet, in SQL Sever Books Online, select the Index tab and enter 'rotated data'. Double-click on the highlighted selection, and select Cross-tab Reports. That's the best example I've seen anywhere. Marianne Daye Programmer/Analyst Information Delivery Systems (IDS) http://ids.rti.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:39 AM To: CF-Talk Subject: RE: SQL Cross-Tab / TRANSFORM We're using SQL 7 for all the database work, but we want to combine some tables (doing mods on a 3rd party program). We thought to use Transform/Pivot. That avoids running hundered of queries on a page (or even an additional 50) because of a funny table structure. We approched the problem by building the Transform Query in ACCESS (their little wizards!) and then utilizing it in the CF code to access the SQL7 server. So, that's how I can see the columns being properly named, but me hair is falling out at being inable to utilize the information. If it's a MS SQL 7 situation - then at least I know it's time to take a different approach! You might try building a cross-tab query using T-SQL, instead. You can use the CASE function for this. There's an example in SQL Server Books Online, which you probably have installed on your SQL Server, or can get in Windows HTML Help format here: http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe 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
Ultradev and CFML
If I use CFML code in Ultradev, do I need to install CF Server? Also, is there a mailing list for Dreamweaver/Ultradev/Fireworks/Flash products? Thanks. AB ~~ 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: no-cache
I use CFHEADER name="Expires" VALUE="0" has worked for me so far... At 11:55 AM 3/20/01 -0500, Kevin Gilchrist wrote: Changed it and it didn't seem to make a difference -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: no-cache woopsie, http-equiv="pragma" content="no-cache" ~~ 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 structure advice
I think you'll get better performance on your queries when you query the sub-groups from a separate table because you'll have fewer records to sort through. Personally, I don't like to work with tables that have a gazillion fields that don't apply to the particular task at hand. Marianne Daye Programmer/Analyst Information Delivery Systems (IDS) http://ids.rti.org -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:52 AM To: CF-Talk Subject: DB structure advice This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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: incrementer
Or you can SELECT MAX(id) FROM mytable before you run the query to INSERT INTO mytable. Marianne Daye Programmer/Analyst Information Delivery Systems (IDS) http://ids.rti.org -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:11 PM To: CF-Talk Subject: RE: incrementer I've always heard bad things about auto-number fields, but I use them anyway... But one thing I've seen is to make a table in your database, call it nextid or something and put two columns, tablename and id. Store the next id for each table in the id column...Update it within a transaction after any insert. So when you go to insert: insert into mytable (id,col1,col2) values ((select id from nextid where tablename = mytable),col1val,col2val) then: update nextid setup id = id + 1 where tablename = mytable depend on what database you are writing to: for example if access then use autonumber and make the id the primary key - this will increment automatically for you - if using MS Squirrel then when creating the table choose integer as datatype, untick allow nulls and tick identity - identity seed and identity increment should then both have 1 in - etc. etc. Also, I don't think that your code will work as you should not be able to read and insert simultaneously from a table (?) - but the idea is good - if you can't get your datasource to increment for you (which you should let it do if it can) then query the table first with your select max stuff - create a cfset which increments the maxid by one and stuff that variable into your code at "id" instead - though I'm sure others will tell you a neater way of doing it without using two queries!!! ;) James "The Force is strong in this one..." - Darth Vader -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 16:25 To: CF-Talk Subject: incrementer seems like a gimme but...is where id is integer and the primary key insert into mytable (id,col1,col2) values ((select max(id) from mytable+1),col1val,col2val) can you do that and is it a legit way to get a primary key? ~~ 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 and ORACLE
Hi Jamie and all, I assume you are NOT going to be using the more expensive CF Server Enterprise version which supports native Oracle drivers; therefore, you will be connecting from ColdFusion to Oracle via ODBC. I am also assuming that you can set up (or have a DBA set up) your Oracle database. In particular, you will need to know the Oracle SQL*Net Connect String for the database (SID). (See the Oracle file TNSNAMES.ORA) Since you mention Access, I also assume you are using Windows. Verify that you can get to the Oracle database using Oracle SQL*PLUS (or by attaching via MS Access). On your CF server, set up an ODBC System Data Source using the Oracle driver. Enter a name for the datasource, a description, and the connect string (e.g., blah.world). I then used the CF Administrator page (on my system, it's at http://root/cfide/administrator/login.cfm Data Sources tab to put in the userid and password to be used by ColdFusion. You can Verify the ODBC data source from CF Admin. Note that we're running an older version of CF but I believe this still would work. HTH. Ben -Original Message- From: Jamie Symonds [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 8:42 AM To: CF-Talk Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: CF and ORACLE This is a multi-part message in MIME format. --5487AC23954301E34319E9FB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all - I am a senior in the Bachelor of Information Systems program at St. Francis Xavier University [http://www.stfx.ca] in Antigonish, NS. For a course project (Info 475 - Databases), my project team (myself, Melanie MacCulloch [[EMAIL PROTECTED]], Nadine Benoit [[EMAIL PROTECTED]] and Jason Hatfield [[EMAIL PROTECTED]]) is to create a database in Oracle and collect survey data through CF forms. I have used CF before for data collection with an Access database; however have no experience in setting up an Oracle datasource. We're concerned about setting up our database and how to go about logging into our database to insert data through CF... can anyone point us to an info source (FAQ), etc.? Thanks!! -Jamie http://www.stfx.ca/people/x97/x97gfq --5487AC23954301E34319E9FB Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Symonds, Jamie Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Jamie Symonds n: Symonds;Jamie adr:Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada email;internet: [EMAIL PROTECTED] title: Bachelor of Information Systems, Major (student) x-mozilla-cpt: ;0 x-mozilla-html: TRUE version:2.1 end:vcard --5487AC23954301E34319E9FB-- 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: DB structure advice
Yeah, I completely agree. I didn't want to put my personal opinion in my original post because I wanted untainted answers. However, from a maintenance standpoint, I thought the many smaller, specific tables is much cleaner and easier to deal with. Thanks, Jason - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 10:16 AM Subject: RE: DB structure advice I would break it into smaller tables. One issue is size - you don't want to store a lot of empty fields. Create each table, and use a primary key ID field to link them. Just remember that when you want a record set with all the data, you will need to use LEFT JOIN in order for the result set to include the members who don't have records in the optional tables. -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:52 AM To: CF-Talk Subject: DB structure advice This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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 structure advice
Jason If you think about it, in real life, a person can have: many degrees Germans even list them all on their business cards, e.g., Herr Doktar, Doctar, Doctar More than one company These logically belong in a one-to-many relationship HTH Dick At 9:52 AM -0700 3/20/01, Jason Lotz wrote: This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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 structure advice
Personnally, and this is probabaly just my psychosis talking ;), but I would
make a structure like this:
Members:
(basic info, firstname, lastname, etc.)
Address:
(all address info, who knows you might want to give more than one address
someday, ie mailing address, work address, home address)
Email:
(most people have more than one of these)
Phone:
(see email)
Fax:
{see Phone)
Education Info
(Maybe you want to build a history someday, or just a good idea to keep it
all in one place)
Mimic Educations for any other types of grouped information.
This will help to keep your tables smaller and more managable... also you
wont waste a ton of space if say very few people have education info.
Hope this helps.
Scott Cavanaugh
Software Developer
Online Operations
Salem Communications Corporation
-Original Message-
From: Jason Lotz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:52 AM
To: CF-Talk
Subject: DB structure advice
This is more of a theory question than an actualy request for help. Let's
say you are building a database of members with lots of information that
applies to every member (name, address, phone, etc.) This could be about 40
seperate fields. Then, on top of that, each member can have lots of
optional information that can easily be grouped together. For example, if
they graduated from college, you want to store their degree information or
if they own a company, you want to store their company info. Each of these
"optional groups" are one-to-one (each member can only have one chunk of
this data but doesn't have to have it at all.) Now here's the question -
When you are building this database, you could easily put it into one huge
table because all the information is one-to-one. However, it's a pain when
you only want to get the "degree" information or the "company" information.
From a programming standpoint, is it best to break these into smaller tables
for ease of use or to keep it into one table?
Thanks,
Jason
~~
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: no-cache
OK, tried that, this is just developing on my own box so no proxy involved either -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:25 PM To: CF-Talk Subject: RE: no-cache I use CFHEADER name="Expires" VALUE="0" has worked for me so far... ~~ 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: Ultradev and CFML
you need at least a local version of CF server. there should be a copy that comes with the ultra dev cd. you can get on a ultra dev news group at forums.macromedia.com macromedia.ultradev -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:27 PM To: CF-Talk Subject: Ultradev and CFML If I use CFML code in Ultradev, do I need to install CF Server? Also, is there a mailing list for Dreamweaver/Ultradev/Fireworks/Flash products? Thanks. AB ~~ 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: Ultradev and CFML
Yes. coldFusion server is what interprets the CFML code, returning HTML to the client side. Try www.macromedia.com for developer lists and tips tricks. Erika -Original Message- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:27 PM To: CF-Talk Subject: Ultradev and CFML If I use CFML code in Ultradev, do I need to install CF Server? Also, is there a mailing list for Dreamweaver/Ultradev/Fireworks/Flash products? Thanks. AB ~~ 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: (new) URL strings keep appending to the previous request's st rings
Thanks for all you answers folks! Just tried it out on Netscape there now (don't usually as this is an IE only intranet app) and it works fine ! So it must be something to do with how IE processes an onClick event from a TD tag as opposed to how Netscpae treats it. Is there another way to do the following? TD class="text" onClick="top.data_pane.location.pathname='/path/filename.cfm?Edit_ID=42';" nbsp;Test6 /TD Thanks, Kevin ~~ 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: Ultradev and CFML
I believe that the UltraDev Product comes with the Cold Fusion Single User Enterprise Server to use in Development. That was on the 1.0 version though. And more specifically, yes, you do need to install it to get your .cfm templates to work. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 10:27 AM To: CF-Talk Subject: Ultradev and CFML If I use CFML code in Ultradev, do I need to install CF Server? Also, is there a mailing list for Dreamweaver/Ultradev/Fireworks/Flash products? Thanks. AB ~~ 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: Pros and Cons on using MS Visual SourceSafe for managing CF projects?
It's a bit off topic, but I'd like to get a feedback on the use of Microsoft Visual SourceSafe for managing CF projects. I've been asking people and most of them say they use the software to manage web projects. Now with CF projects what would be the pros and cons of using the software?? ~~ 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 structure advice
Completely agreed. However, I was trying to make up a scenario were you would specifically want one-to-one relationships. I gave a bad example but I think I got my point across. And the definite concensus is that people break often break up complex one-to-one relationships into several tables...which is what I wanted to hear. Jason - Original Message - From: "Dick Applebaum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 10:43 AM Subject: Re: DB structure advice Jason If you think about it, in real life, a person can have: many degrees Germans even list them all on their business cards, e.g., Herr Doktar, Doctar, Doctar More than one company These logically belong in a one-to-many relationship HTH Dick At 9:52 AM -0700 3/20/01, Jason Lotz wrote: This is more of a theory question than an actualy request for help. Let's say you are building a database of members with lots of information that applies to every member (name, address, phone, etc.) This could be about 40 seperate fields. Then, on top of that, each member can have lots of optional information that can easily be grouped together. For example, if they graduated from college, you want to store their degree information or if they own a company, you want to store their company info. Each of these "optional groups" are one-to-one (each member can only have one chunk of this data but doesn't have to have it at all.) Now here's the question - When you are building this database, you could easily put it into one huge table because all the information is one-to-one. However, it's a pain when you only want to get the "degree" information or the "company" information. From a programming standpoint, is it best to break these into smaller tables for ease of use or to keep it into one table? Thanks, Jason ~~ 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 Cybercash
Greetings, We're having trouble using ColdFusion and Cybercash and we can't pinpoint the problem. We have a custom shopping script (this is the second one built from scratch, so we're pretty sure the script isn't the problem) that is doing two things wrong: - Dropping records that are processed by Cybercash correctly. We've received a payment, but nothing shows up in the database. We were thinking this was because the Cybercash was processed before the database insertion. Maybe the script timed out before Cybercash gave a response? Has this ever been a problem with anyone else? - The database and Cybercash are getting out of sync and are bouncing error messages (ID 'XX' is already in Cybercash's records). Not sure what is causing this but I'm thinking it's related to the first problem. A few other notes about the situation: - The database is Access (we know, we know), but it's probably not the problem. The app is rarely used (maybe one or two orders in a good week). - The hoster is Interland (again, we know, we know), but it's almost impossible to determine if they're the problem (in this case) short of transferring, which is probably out of the question at the present. - We're using the CFX_CYBERCASH custom tag. Is there a better custom tag choice in this case? And an overall question...is Cybercash even the best choice for this? Interland offers support for Verisign as well, is their's any better? We're also kicking around moving the site to Rackspace. So, that opens up other possibilities. Who has the best real-time credit card authorization system that integrates with ColdFusion? Is Authorize.net good? Any help with any of this: recommendations, solutions, ideas, whatever, would be most helpful. Thanks! --Ben -=-=-=-=-=-=-=-=-=-=-=-=- Ben Dyer Senior Internet Developer Imaginuity Interactive http://www.imaginuity.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: I guess i was unclear...try this..
try this.
myquery.firstname[2]
or it's this
myquery[2].firstname.
Basically something to that effect. with cf queries you can access each row
using array syntax, but you still need to access each column by name.
HTH,
---Mike
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 4:38 AM
To: CF-Talk
Subject: RE: I guess i was unclear...try this..
There is no such thing as a specific row, the order the records are returned
to you (the rows) is random and undefined, it makes very little sense to ask
'what is the value of 'firstname' in the 2nd row.
If you really wanted to (for debugging I guess), you could
cfscript
lookfor=2;
for(i=0;iqQuery.recordcount;i=i+1){
if (i eq lookfor){ output row }
}
-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 2:42 AM
To: CF-Talk
Subject: I guess i was unclear...try this..
I guess I was unclear. Let's suppose I have no interest in a specific value
like ID=3 but just want to know what is in a particular row and column. Am I
always stuck using a where statement having to look for a particular value?
I understand that a where statement can locate an instance of some
particular. I would just like to do a search on a row and a column in
general.
greg
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:20 PM
To: CF-Talk
Subject: RE: Thanks everyone but one last question
You can create whatever WHERE statement you wish to select whatever rows you
need from the DB
to get row 2, column 2:
SELECT password
FROM table
WHERE ID = 3
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:02 PM
To: CF-Talk
Subject: Thanks everyone but one last question
Thanks for the help on my newbie question. I learned a great deal believe it
or not. You were all kind.
Now one last question before I go back to the books.
See the database setup below.
ID PASSWORD FIRSTNAME LASTNAME
4 sdf greg landry
3 gth tom jones
Lets say I wanted to see what is in the second record and see what's under
the column FIRSTNAME. What I am learning is that I have to print out the
entire database to see what is in it. I would just like to be able to know
how to access a particular element in a database. Like what's in row 2,
column 2?
Thank you so much for your patience and time.
Greg "the ever curious newbie"
~~
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
Tag for NTFS file permissions
Can anyone recommend a good tag to change NTFS file permissions? I found cfx_chmod in the tag gallery, but the download link doesn't lead anywhere... ~~ 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: Authorize.net????????????
Is there any way to test an app I built with the Authorize.net tag without actually having an account with them? Rich ~~ 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: Browser is caching files even when I use META tags to prevent caching.
I'm using IE 5.5 Hmmm I'm not sure. The frames are sometimes troublesome with IE5.0 and caching, but I havn't herd of 5.5 having this issue. I'm not help, sorry. - Original Message - From: "Kevin Gilchrist" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 11:44 AM Subject: RE: Browser is caching files even when I use META tags to prevent caching. I'm using IE 5.5 -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: Re: Browser is caching files even when I use META tags to prevent cac hing. I've heard of problems like this when using IE 5.0. What browser are you testing this app on? ~~ 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: Browser is caching files even when I use META tags to prevent caching.
Don't know if anybody has mentioned this yet, but you may want to add no-cache params in your HTML header. e.g. CFHEADER NAME="Expires" VALUE="Mon, 06 Jan 1990 00:00:01 GMT" CFHEADER NAME="Pragma" VALUE="no-cache" CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must-revalidate" ~~ 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: Authorize.net????????????
Not to be a smartass, but have you asked Authorize.Net? As far as I know, you need to provide a user account ID to process a transaction through there servers, including test transactions. I wouldn't be too surprised if they've got some kind of a test account you could use, or maybe they could set one up. Ask them. Jim - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 11:50 AM Subject: RE: Authorize.net Is there any way to test an app I built with the Authorize.net tag without actually having an account with them? Rich ~~ 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
Verity Search with No Results
I am having a little problem this morning (aside from the power being out). I had a verity collection which worked a few days ago. There have been no code changes or OS/physical changes. I have read an article about large collections sometimes hicupping, but I don't think that's my problem. There are about 700 items in this collection. I have updated, purged and rebuilt the collections but nothing seems to get them working again. Does any one have an y suggestions? Thanks, Jen Drechsler SFPUC, ITS ~~ 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: Pros and Cons on using MS Visual SourceSafe for managing CF projects?
In my opinion, VSS is a good tool for managing source code. However, I would never integrate it with CF Studio projects. I had done this and the result was 5 corrupt projects and the loss of 2 weeks of work. HTH. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:17 To: CF-Talk Subject: OT: Pros and Cons on using MS Visual SourceSafe for managing CF projects? It's a bit off topic, but I'd like to get a feedback on the use of Microsoft Visual SourceSafe for managing CF projects. I've been asking people and most of them say they use the software to manage web projects. Now with CF projects what would be the pros and cons of using the software?? ~~ 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: Authorize.net????????????
Rich, I don't believe there is a way. You can process test transactions, but you will still need to login with an Authorizenet merchant account ID. You might try asking AuthNet support directly, though. Good luck. Chris Montgomery, [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: Browser is caching files even when I use META tags to prevent caching.
Don't know if this will help, but it seems to work for me regarding forcing page refreshes. 1. The meta tag defaults to reloading the page specified after two seconds unless the user clicks the "Field Template Menu" button. 2. The onClick event takes the user back to the TPLT_SEL page if it is clicked before two seconds. In both cases the TPLT_SEL page is reloaded/refreshed. Seems to also work behind proxy/firewall. Using an onClick="javascript:history.go(-1)" type of event doesn't refresh the page. HEAD TITLEField Template Record Update Page/TITLE META HTTP-EQUIV="REFRESH" CONTENT="2.0;URL=TPLT_SEL.CFM" /HEAD bunch of code... CFFORM NAME="RVT2_REV" ACTION="FLDTPLT.CFM" ... bunch of code... INPUT TYPE="button" VALUE="Field Template Menu" onClick="location.href='TPLT_SEL.CFM'" /CFFORM ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Greg Wolfinger [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 1:56 PM To: CF-Talk Subject:Re: Browser is caching files even when I use META tags to prevent caching. I'm using IE 5.5 Hmmm I'm not sure. The frames are sometimes troublesome with IE5.0 and caching, but I havn't herd of 5.5 having this issue. I'm not help, sorry. - Original Message - From: "Kevin Gilchrist" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 11:44 AM Subject: RE: Browser is caching files even when I use META tags to prevent caching. I'm using IE 5.5 -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: Re: Browser is caching files even when I use META tags to prevent cac hing. I've heard of problems like this when using IE 5.0. What browser are you testing this app on? ~~ 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
