[KCFusion] OT VB.net
Are there any vb.net gurus here? I have a conceptual question that I need some help with. You can contact me off list. [EMAIL PROTECTED] A.
Re: [KCFusion] CFLOOP Issue
Umm..maybe im not quite getting something in your questionbut..your cfoutput is outside the loop tags. Since that is the case then headlinePerSection keeps getting reassigned a new value each loop 4 then 5 then 6. Why not put an array in the loop so you could store the value each interation? A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 6:48 PM Subject: [KCFusion] CFLOOP Issue I have a list (valuelist) that I get from a query. Looks like this: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4-1s, 5-2s, and 6-3s. I understand that ListValueCount(list, value) does that. It is supposed to report how many instances of a value there are in a list. So I am trying to loop through it. But I dont think my loop is looping. When I cfoutput the index value for the loop, I get 4. Its like it skips over 1,2, and outputs only 3. Heres the code which if you copy and paste into Dreamweaver or whatever you use to code, you can run. I hard coded the variables: cfset maxSection = 3 cfset countSections = "1,1,1,1,2,2,2,2,2,3,3,3,3,3,3" cfloop index="i" from="1" to="3" cfset headlinePerSection = ListValueCount(countSections, i) cfset columnOneCount = Int(headlinePerSection/2) cfset columnTwoCount = Ceiling(headlinePerSection - columnOneCount) /cfloop cfoutput i: #i#br / maxSection: #maxSection#br / countSections: #countSections#br / headlinePerSection:#headlinePerSection#br / columnOneCount: #columnOneCount#br / columnTwoCount: #columnTwoCount#br /br / /cfoutput The test output looks like this: i: 4maxSection: 3countSections: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3headlinePerSection:6columnOneCount: 3columnTwoCount: 3 Again, I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4 -1s, 5-2s, and 6-3s. Got any ideas? Jim T. Pickering 913/269-3339
Re: [KCFusion] web server trouble shooting (OT)
Did you by chance ping your server or do a tracert to it? Yes that is usually the first thing I do when faced with a page that does not load. Its really silly but I think the packets get lost and need to be reminded where to go. Thats how I think of it anyway and in this case no such luck. What did you do to "coax" the KState's site into loading? We hit refresh about a million times over the course of an hour. Despite engaging in what could be defined as insane behavior (doing the same thing over and over expecting different results) it seemed to do the trick after a while. Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? Actually no. We were under a time crunch and had no need to have all the laptops going to the site. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like a DNS problem or a localized internet routing problem. Did you by chance ping your server or do a tracert to it? What did you do to "coax" the KState's site into loading? Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? If so, how did that go? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, September 16, 2003 1:04 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] web server trouble shooting (OT) I had a bizarre experience over the weekend. We hosted a conference out in BFE (Valley Falls) and took 10 laptops, networked them and connected them to the buildings internet connection which was an ISDN line. While there was noticible slow down in people surfing the web, what was really fustrating was you could not go to our organizations website. It flat refused to load. It would say web site found and the progress bar would get started but then it would just sit there. We could go pretty much everywhere else (KStates was not loading for a while but we coaxed that one into action with much waiting) but our site. One of the presentations focused on how to use our site so I finally got around it by remote desktoping into our server and looking at the site from there but once i had done that the site would load fast as anything looking at it just on the laptop (as opposed to looking at the laptop looking at the server). But it only worked on THATlaptop. All the others were still refusing to load. I had no clue what that was all about and all three of us were scratching our head. Anybody have any ideas on how I could have gone about "fixing" that? A.
Re: [KCFusion] web server trouble shooting (OT)
Cont'd (a little too fast on the send) We actually run a pretty uncomplicated site. We were loading crappily designed sites (www.bvmjets.com) and really good ones (www.accenture.com and www.msnbc.com) to see if it was something we had done wrong. In all three cases the pages came up without a problem. Adaryl WakefieldAviator by passionProgrammer by sheer force of will - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like a DNS problem or a localized internet routing problem. Did you by chance ping your server or do a tracert to it? What did you do to "coax" the KState's site into loading? Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? If so, how did that go? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, September 16, 2003 1:04 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] web server trouble shooting (OT) I had a bizarre experience over the weekend. We hosted a conference out in BFE (Valley Falls) and took 10 laptops, networked them and connected them to the buildings internet connection which was an ISDN line. While there was noticible slow down in people surfing the web, what was really fustrating was you could not go to our organizations website. It flat refused to load. It would say web site found and the progress bar would get started but then it would just sit there. We could go pretty much everywhere else (KStates was not loading for a while but we coaxed that one into action with much waiting) but our site. One of the presentations focused on how to use our site so I finally got around it by remote desktoping into our server and looking at the site from there but once i had done that the site would load fast as anything looking at it just on the laptop (as opposed to looking at the laptop looking at the server). But it only worked on THATlaptop. All the others were still refusing to load. I had no clue what that was all about and all three of us were scratching our head. Anybody have any ideas on how I could have gone about "fixing" that? A.
[KCFusion] friends of ed
http://www.friendsofed.com/ I remember a while back there was big discussion about these guys going out of business. Anybody know what happened or even knew that they were back? A.
[KCFusion] mail archive
The mail archive does not appear to be working. A.
Re: [KCFusion] security question
Ok wait. I have not thought this all the way though I think. The kind of attack was thinking of was where a hostile user taped the stream mid flow. Somehow between the end user and the server. Since the pages are encrypted with https then they (the hostile) should not be able to do anything yes? An if the bandit has the users authentication information then there really is not much you can do no? You know for a meeting idea I'd really like to hear what the big boys are doing security wise. All the books I have the security is pretty lame and basic. A. - Original Message - From: Luke Templin To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:05 AM Subject: RE: [KCFusion] security question You may want to do everything through a stored procedure(s). As part of that stored procedure you could create multiple sql queries one of which can be an audit trail. Another way is to present the material to be deleted as a table with a checkbox for each row.Then have the user select each individual record. Pass the information to a cftag that does the delete. this reduces the opportunity for a user to randomly type anything in and allows you to implement a validation routine. Another item to explore is to use the https if security is a concern. Can't say I have experience with it but given your description that might be a method to investigate. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:54 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
[KCFusion] security question
Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Thats what I thought. Manually deleteing them does not exactly bring a smile to my face but it is feasable for us. But what about larger companies with like a gazillion records. Unless your telling me that they just have tons of minimum wage people that all they do all day is delete records. A. - Original Message - From: Kory Bakken To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:54 AM Subject: RE: [KCFusion] security question Adaryl: Yes,if a person has IEBoster (http://www.paessler.com/IEB)running on their machine, hidden form fields are just a right-click away. You'd be better off putting a "ACTIVE" field in any table that you are going to allow users to delete from. That could inactivate the record, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:48 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Thats where I started. I was doing it via java script so I could ask the
user if they really wanted to delete. But when I passed the function the
encrypted value it did not like it for some reason. It was rendered all
funny. The function looks like this
script language=JavaScript
function check(entry){
if (confirm(This will delete this entry. Proceed?)){
document.location = foo.cfm?entry= + entry;
}
else{}
}
/script
Then I would call it with
a href=javascript:check(#Encrypt(primaryKey, 'notTheRealKey')#Delete/a
Which in turn comes out as
a href=javascript:check((%WEDelete/a
Totally breaks my code.
A.
- Original Message -
From: Bruce Dunwiddie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 11:57 AM
Subject: RE: [KCFusion] security question
Well the checking in the database to make sure that the user is allowed to
delete that record is a good step to leave in. As for the rest, I'd
probably
recommend passing an encrypted value of the record to delete along with
the
record id itself, so you can verify that they haven't just changed the id,
and it won't matter if they can get access to the hidden encrypted value
because they won't be able to submit the proper encrypted version to pass
the validation.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Kory Bakken
Sent: Tuesday, August 12, 2003 9:54 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] security question
Adaryl:
Yes, if a person has IEBoster (http:// www.paessler.com/IEB
http://www.paessler.com/IEB ) running on their machine, hidden form
fields are just a right-click away. You'd be better off putting a
ACTIVE
field in any table that you are going to allow users to delete from. That
could inactivate the record, then you could manually review the deletes
before committing any of them. That's my 2 cents.
Kory
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] security question
Im sorry I was in a hurry and should have explained this better. For the
first time I am faced with allowing users to delete info from a database.
I
am trying to come up with a save method for doing that. In other words I
don't want people to just type random numbers in a query string and start
erasing stuff. Most of the measures I have come up with so far are easily
defeated. I had considered putting the primary key of the tuple to be
deleted in a hidden form field but if you can alter the info sent in a
post
request (and I think I read somewhere that you could) then that measure is
kinda lame too. the best I've got so far is that the user can only delete
those tuples that are related to their login.
A.
- Original Message -
From: Bruce Dunwiddie mailto:[EMAIL PROTECTED]
To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 11:33 AM
Subject: RE: [KCFusion] security question
I don't know of a way to say make IE send different request headers, but
if
you're trying to test something, wouldn't cfpost work?
-Original Message-
From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]On
Behalf Of Adaryl Wakefield
Sent: Monday, August 11, 2003 1:44 PM
To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Subject: [KCFusion] security question
Is is possible to alter the information that is sent in the headers of a
POST request?
A.
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] DateDiff in SQL Query
Well all my reference books are at work and
as it is firday night and im on my way out the door to go party just taking a
quick glance at it but (and I may just be missing a piece of the puzzle here)
but since you are selecting out CustomerEnrollementDate in the query don't you
have to assign it a value before you use it in the DateDiff function, or did you
already do that and it does not show up in your snippet?A.
- Original Message -
From:
Robert
To: [EMAIL PROTECTED]
Sent: Friday, August 01, 2003 11:02
PM
Subject: [KCFusion] DateDiff in SQL
Query
I am running into a problem and I can't figure
out why. I know i've had this problem before with using CF functions
inside of SQL queries, but I can never remember what it was the last time that
fixed it, so I wanted to post this query:
CFQUERY name="getcustomers"
DATASOURCE="x"SELECT CustomerName, CustomerPin,
CustomerRefer,CustomerEnrollmentDateFROM
CustomersWHERE CustomerRefer =
#Affiliate_ID#AND
#DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')#
= 0/CFQUERY
I'm needing to run stats for affiliate programs
and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't
seem to be able to do anything other than generic day, month, etc.
Anyhow, I get the following error:
Error
resolving parameter CUSTOMERENROLLMENTDATE
Obviously I
have the right name, but it bombs right there...if I change around my quotes
and my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected
2. Anyone easily point out what i've got in the wrong place or what I am
messing up because i'm at a loss. BTW, Affiliate_ID is from another
CFOUTPUT from a query that this is all running inside of.
Thanks,
Robert
[KCFusion]
I have need to update a table and set a value to NULL like UPDATE blah SET thisAttribute = nullValueHere WHERE someStuff = someOtherStuff so far I've tried cfset var = "" and cfset var = "NULL" and some other things but so far nothing. Anybody know right off the bat where I'm going wrong? A.
Re: [KCFusion]
Yeah I actually tried
cfset var = NULL
first with no quotes
cause I figured it would read it as the string NULL but it choked on that
too.
I was trying to make things as elegant as possible.
My next attempt was to just write an if with two separate SQL statements
like
cfif var is ""
run this statement
cfelse
run this statement
/cfif
but i had no clue you could embed ifs in query
tags. Which is better from a speed standpoint? Choose a statement or embed the
if?A.
- Original Message -
From:
Kory Bakken
To: [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 10:49
AM
Subject: RE: [KCFusion]
If you do not use
stored procedures, you could do this:
UPDATE blah
SET thisAttribute =cfif
isdefined('var')#var#cfelseNULL/cfif
WHERE
someStuff = someOtherStuff
The problem you
had is that it reads:
cfset var =
"" as and empty string
and
cfset var =
"NULL" as the actual string "NULL"
-Original Message-From: Adaryl Wakefield
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40
AMTo: [EMAIL PROTECTED]Subject: [KCFusion]
I have need to update a table and set a value
to NULL like
UPDATE blah
SET thisAttribute = nullValueHere
WHERE someStuff = someOtherStuff
so far I've tried
cfset var = ""
and
cfset var = "NULL"
and some other things but so far nothing.
Anybody know right off the bat where I'm going wrong?
A.
Re: [KCFusion] ColdFusion Query Times Out
Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
[KCFusion] an easy one
Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] an easy one
Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] an easy one
Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP BY Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/23/2003 05:06 PM Please respond to CF-List To: [EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy oneThe results should have 1 of each student in a group, ex: stu1/grpA stu1/grpB stu2/grpA stu2/grpCI believe the only way to get only 1 record for each student would be: SELECT DISTINCT table1.studentID FROM table1Keep in mind that I'm no SQL guru...Tyson-Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 4:14 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy oneYes- Original Message -From: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: Monday, June 23, 2003 3:56 PMSubject: RE: [KCFusion] an easy one Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy oneIts been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]__The KCFusion.org list and website is hosted by Humankind Systems, Inc.List Archives http://www.mail-archive.com/[EMAIL PROTECTED]Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]To Subscribe mailto:[EMAIL PROTECTED]To Unsubscribe mailto:[EMAIL PROTECTED]__The KCFusion.org list and website is hosted by Humankind Systems, Inc.List Archives http://www.mail-archive.com/[EMAIL PROTECTED]Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]To Subscribe mailto:[EMAIL PROTECTED]To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] duplicate name.. (OT)
We had a power failure over the weekend that has resulted in some problems. When ever i try to start our web site I get a message that says "A duplicate name exist on the network" which makes no sense. There are no other web sites and no other computers with the same name as the webserver. Its not letting me start the site because of this. Any suggestions. IIS 5 Win 2K server A.
Re: [KCFusion] Cold Fusion
right(string, 2) A. - Original Message - From: lance To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 4:06 PM Subject: [KCFusion] Cold Fusion What is the best way to get the last 2 char. in a variable? Lance W. BoykinCentralized Showing Service(913) 754-1023 [EMAIL PROTECTED]
Re: [KCFusion] WDDX
Ok let me come at this more abstractly. If you send something via post, is there a way to identify and extract that info? A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 3:53 PM Subject: [KCFusion] WDDX This is a long shot but I can' t communication with my flash lists at the moment. I'm sending a wddx packet from Flash MX to a cfm page for processing. The problem is I don't have a clue how to deserialize it once it gets to the cfm page. All the examples I can find are inappropriate. Specifically what goes in the input attribute of the cfwddx tag? A.
[KCFusion] Messenger Ads (OT)
A while back there was something on the list about these stupid Messenger Service pop up ads. I looked in the archive but found nothing on them. Did anybody find a free way to stop them? They are coming in on the web server and I have put up with them for a while, now they are just making me angry... A.
Re: [KCFusion] Messenger Ads (OT)
Its behind a firewall. That's one of the things that had me grinding my teeth.A. - Original Message - From: Greenhagen, Robin To: [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:14 PM Subject: RE: [KCFusion] Messenger Ads (OT) Three words to stop these ads: FIREWALL, firewall, FireWall If you repect your site's content and your databases, get any kind of firewall and get it out there in front of your web servers. Robin Greenhagen President GSIhttp://www.gsi-kc.com/ -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 01, 2003 10:26 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] Messenger Ads (OT) A while back there was something on the list about these stupid Messenger Service pop up ads. I looked in the archive but found nothing on them. Did anybody find a free way to stop them? They are coming in on the web server and I have put up with them for a while, now they are just making me angry... A.
[KCFusion] query output (OT)
Is this even possible? I need to display data from a query thusly: Category1 Person1 Person2 Person3 Category2 Person1 Person2 Person3 I used the group attribute of the output tag but that only spit out 1 record. Without the group attribute I get Category1 Person1 Category1 Person2 ... Which is what I expect, just not what I need. A.
Re: [KCFusion] query output (OT)
SWEET! Thanks all three of you. Justin finally nailed it. A. - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 1:35 PM Subject: RE: [KCFusion] query output (OT) Krisi almost had it... this will do the trick. cfquery name=category_person ... select id, category, person from theTable order by category, person /cfquery cfoutput query=category_person group=category #Category#br cfoutput group=Person - #Person#br /cfoutput /cfoutput The other suggestion is going to produce bunch of un-necessary queries. -Original Message- From: Kory Bakken [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 12:59 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] query output (OT) Sorry, you need to make sure that the qry_categories specifies a DISTINCT category. -Original Message- From: Kory Bakken Sent: Friday, March 28, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] query output (OT) Try this... cfquery datasource=dsn name=qry_categories SELECT Category FROMTable WHERE... /cfquery cfset listCategories = QuotedValueList(qry_categories.Category) cfloop list=listCategories index=i cfoutput #i#br /cfoutput cfquery datasource=dsn name=qry_people SELECTPerson FROMTable WHERECategory = #i# /cfquery cfoutput query=qry_people #qry_people.Person# /cfoutput /cfloop -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] query output (OT) Is this even possible? I need to display data from a query thusly: Category1 Person1 Person2 Person3 Category2 Person1 Person2 Person3 I used the group attribute of the output tag but that only spit out 1 record. Without the group attribute I get Category1 Person1 Category1 Person2 ... Which is what I expect, just not what I need. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Hello
Id actually like to see a presentation on how you make really cool pictures
with nothing but punctuation.
A.
- Original Message -
From: Keith Purtell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 3:44 PM
Subject: RE: [KCFusion] Hello
Welcome, Katsuey. Can you come to one of our meetings and do a
presentation on how you got the
nickname?
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email: [EMAIL PROTECTED]
CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Katsuey
Sent: Thursday, March 20, 2003 3:35 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Hello
Hello everyone. I feel rather guilty listening to your
conversations without making myself known. So if
I may, an introduction:
My name is Peggie Brown (often known around the
Internet as Katsuey - the name is a long story).
I run KatsueyDesignWorks http://www.katsueydesignworks.com
Katsuey's Legal Gateway http://www.katsuey.com
Leavenworth Directory http://www.leavenworthdirectory.com
and BusinessSights.com http://www.businesssights.com
I'm located in Lansing, KS and one of your members recently
told me about the KCfusion list. I am just learning CF, having
only scratched the surface but have promised Massimo the
Guru of CF that I will know more by TODCON http://www.todcon.org
Vegas.
Anyway, happy to learn about the group and hopefully I can learn
CF!
Peggie Brown
((( ¸.-···- ^~~ ^
( {ªYª}
\ )_ `~-~/´
\,,/,,/ \,,,Í,,Í
Brown Holdings LLC Group
KatsueyDesignWorks, Custom Web Design
http://www.katsueydesignworks.com
ContentXperts http://www.contentxperts.com
913.727.1794
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
--- [This E-mail scanned for viruses by Declude Virus]
---
[This E-mail scanned for viruses by Declude Virus]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] session vars
Thanks Ryan (and you too Bruce). I'm trained as an analyst not a computer scientist so the details of memory usage sometimes escapes me. Most of the questions I ask are generated from my trusty (albeit rather thick and thus hard to haul around) WROX CF 5 book and they will say stuff like use session variables sparingly with no real detail as to gauge sparingly. We get a blazing up 5000 visitors a month so I never really worried about my session vars till now but I'm working on a project that is likely to quantum jump the site traffic. But it looks like I still have nothing to worry about. I have not gotten struct delete or struct clear to work. I keep getting a cannot resolve to structure message. Code looks like cfscriptStructClear(session.email);/cfscript That's straight from the book and I have no clue how I could screw that up. I also used Mr. Prices suggestion and no joy there either. And while I'm in a prattling mood...did everybody know that Friends of Ed bit the dust along with some other publishers? I saw it in another list I'm on. A. - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 1:54 PM Subject: RE: [KCFusion] session vars Heck if I know, I have yet to actually build a website that had any significant loading on it :-) You might want to check your server settings (or your setup in the application.cfm) to see how long the session variables are good for before they expire. If its only 20-60 minutes, then how likely is it that you will have enough loading in 1 hour to cause a problem...Probably slim. I read a long time ago somewhere how to calculate variable ram usage, I might be wrong, but it was something like X number of bytes per letter of a string, etc. you could just as easily open up MS SQL, create a fake table with each variable name you are going to make into a session variable. Use nChar instead of Char (n tells it to use unicode, which uses twice the space as a normal character), etc. That way your estimates are worst case scenarios. If you add in a bit more space for the pointers and variable names, you might get a fair representation for variable size. For instance, if you have a string being saved as 20-40 characters, guess 40 characters of nChar, which takes 80 bytes. Add in say, 20? for the variable name and its pointer. 100B. Say you have 5 of these for a user (500). Now assume you have 15 variables with floating point values (4 bytes each I think, say, 16 for the name) 15*20=300. Add in a few integers, etc. You are probably at 1K for the user. Even if we double this to 2K for the user, that means 500 users in 1MB of ram. Say you have a server with 512mb of RAM, 170 for Windows, 40 for CFMX, 40 for SQL Server = 250. Leaving 250MB for session variables, coldfusion caching of queries, pages, source code, database queries, etc. Lets just say you have 50MB of memory for session variables, at 500 users per meg, that is 25 thousand users saving their variables in ram. I doubt seriously that most sites will get 25k+ users in 1 hour.I wouldn't worry about it. Sure, I can just hear the more anal of you questioning my very crude estimates :-), but for the average user, if they aren't saving queries, large record sets, and complex structures inside of session variables, my estimate is probably right on track. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Session variable memory
K I took the quotes out still not good. cfset session.test = foo cfoutput#session.test#/cfoutput cfscriptStructClear(session.test);/cfscript gives me Cannot convert given value to a struct. Please check the validity of the expression Most of the book and Studio examples create structures before they get rid of them. But it says clearly that this is how you get rid of session variables. What am I missing? A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Session variable memory
Didn't work before but it did this time ..thanks! A. - Original Message - From: Benjamin Price [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:49 PM Subject: RE: [KCFusion] Session variable memory Since the variable test is a string, try StructDelete(session,test). StructClear is for clearing the entire session structure. A string, or any other simple variable type, won't work with StructClear. -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:44 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Session variable memory K I took the quotes out still not good. cfset session.test = foo cfoutput#session.test#/cfoutput cfscriptStructClear(session.test);/cfscript gives me Cannot convert given value to a struct. Please check the validity of the expression Most of the book and Studio examples create structures before they get rid of them. But it says clearly that this is how you get rid of session variables. What am I missing? A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] storing files
Thanks Messrs. Greenhagen and Dunwiddie. cffile is
not something that I use very often (if ever)so I had forgotten about
that. Makes things tons easier.
A.
- Original Message -
From:
Dunwiddie, Bruce
To: '[EMAIL PROTECTED]'
Sent: Monday, March 10, 2003 11:11
AM
Subject: RE: [KCFusion] storing
files
I'm
pretty sure there's a file size limit as to how much you can store in the
database. You will obviously cause some overhead when loading these files from
the server as compared to loading natively through just iis. You will also
ramp your database file size. In general I find it a very bad idea. Other than
it being the easy solution as you put it, I'm not really seeing the rough part
of the tradeoff of just saving the path to the images. I don't see it as being
a complex algorithm to make all the files unique when cffile already has the
nice feature of makeunique for naming conflicts, unless you are wanting to
save it with a relatively similar name as the makeunique likes to make up it's
own, but then you'd just have to get cffile.serverfile and save it in the
database. The only other problem I could possibly forsee is if the whole app
or file server picks up and moves, then the paths in the database will have to
be updated. Here's the code to upload it to a unique name that's similar to
the original if that helps. Also, MX by default uses very similar logic to
uniquely name uploaded files by default so you don't even have to worry about
it.
cffile action="" filefield="someformfield"
destination="#path#"
nameconflict="MAKEUNIQUE"cfset wanted =
cffile.clientfilenamecfset ext =
cffile.clientfileextcfset attempt =
wantedcfif cffile.serverfilename is not
wantedcfset try =
1cfset saved =
cffile.serverfilecfloop
condition="fileexists('#path##attempt#.#ext#')"cfset
attempt="#wanted##try#"cfset try =
try +
1/cfloopcffile
action="" source="#path##saved#"
destination="#path##attempt#.#ext#"/cfifcfset
form.someformfield= "#attempt#.#ext#"
-Original Message-From: Adaryl Wakefield
[mailto:[EMAIL PROTECTED]Sent: Monday, March 10, 2003 10:36
AMTo: [EMAIL PROTECTED]Subject: [KCFusion] storing
files
I have a project where people can track their
progress though a training program. One of the things they need to do is
view images that they uploaded to our server and there are a couple of other
files that relate to them and them only.
The thing I'm agonizing about is rather to
store the files (gifs and pdfs) in directories and store the path to the
files in a database and comingup with some sort of
elaboratealgorithm to make sure all the files had uniquenames OR
just storing the gifs and pdfs in the database itself. I'venever
actually done the latter but I have seen it donewith images never with
pdfs. The latter method seemseasier to me but I read that actually
putting the files in the DB creates a performance hit.
Opinions? Wisdom anyone care to
share?
Win 2k Server
CF5
SQL Server 2k
A.
Re: [KCFusion] include vs custom tag
Title: include vs custom tag Curious. If you have time, can you explain what you mean exactly when you say you are going to use custom tags for the framework? A. - Original Message - From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Thursday, March 06, 2003 10:29 AM Subject: [KCFusion] include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
Re: [KCFusion] March Meeting questionnaire - Contribute demo
Am coming. Either day. Any location. A. - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:08 PM Subject: [KCFusion] March Meeting questionnaire - Contribute demo March Meeting - Contribute I am working on putting together our March meeting. It will be presented by Brad Miller of Accesszone Design and will be an introduction/demo on using Macromedia Contribute, including how to install/configure it from the administrator/server point of view, basic features and the benefits of using it. We are looking at 2 dates to hold this, Tuesday, March 17th or Wednesday the 18th. Likewise, we have 4 possible locations that have been volunteered in the past. Please let me know at [EMAIL PROTECTED] if you are interested and available in coming. Do you prefer the 17th or 18th? Which location works better for you? UMKC Administration building, 50th Oak, just east of the Plaza - (8 small room, 50 large) College Antioch (10 for fancy room, 20 for regular conference room) College Metcalf (unknown capacity) 130th Metcalf (max capacity 10) Thanks, Ryan [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] uuid
Is there still a pretty high degree of uniqueness if I only used the first 12 characters of a UUID as a primary key? A.
Re: [KCFusion] Select in Date Range
What are you getting when you run this? An error or an empty record set? A. - Original Message - From: Chris Holdman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 10, 2003 11:34 AM Subject: [KCFusion] Select in Date Range Okay I know this should be easy but I am not having any success. I want to select betwee two dates. Here is my query, what am I doing wrong. cfquery datasource=date name=name select * from request where closed between '2002-10-01 00:00:00' AND '2002-12-15 00:00:00' order by closed /cfquery Christopher V. Holdman [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Macs..bleh (for the archive)
Ok. After many weeks and a phone call to FileMaker I finally solved the whole FileMaker issue by dropping ODBC all together and used FileMaker's XML capabilities and the MS XML parser. Way easier to deal with. A. - Original Message - From: Ramsey Abu-Absi To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 4:52 PM Subject: Re: [KCFusion] Macs..bleh I would get on the phone with Filemaker tech support then. If it's a mission critical database, the company should have some kind of support contract with them. If they don't you should push them to purchase one. If you don't mind, post back if you can get them to help resolve it.Good Luck,RamseyAt 02:33 PM 1/10/2003, you wrote: Now see thats the way its supposed to work i thought but the connection always fails.A. - Original Message - From: Ramsey Abu-Absi To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 1:01 PM Subject: Re: [KCFusion] Macs..bleh Hi Adaryl, Check out this link: http://www.macromedia.com/support/dreamweaver/ts/documents/filemakerdw.htm It explains how to set up an odbc connection to filemaker for use with ASP pages, but if you follow the directions to set up the data source on your CF server, the administrator should recognize the datasource. Hope that helps, Ramsey At 12:04 AM 1/10/2003, you wrote: Get them to upgrade? Sure, but it involves flying pigs and a backwards rotating earth. No seriously, this thing is the heart of the organziation. If i were to replicate it it would have to be updated every minute. But it is something I can look into, at this point Im not tossing any idea out. FM is pretty low powered im not even certain it has something akin to replication services. A. - Original Message - From: Ryan Hartwich To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 8:46 PM Subject: RE: [KCFusion] Macs..bleh Adaryl, A few thoughts, try tricking CF Filemaker. Maybe you can use an MS SQL odbc driver/connector. Or, maybe you can setup some form of replication or linking between say, Access or MS SQL and the FileMaker. Then, use CF to access the new DB. Can you just force them to upgrade to a different database? Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Thursday, January 09, 2003 4:43 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Macs..bleh Greetings all, I work in a primarily Mac environment (yes i know..pray for me). The organization has a database in FileMaker Pro 5 (on Mac of course) that is mission critical (I bet you already know what Im going to ask). The first time I tried to access it 2 summers ago from CF which sits on Win2k server it was not possible. I was wondering if in the year and a half since someone has created a working ODBC driver or is there anybody else that has some sort of workaround? I'm all over the internet without much luck. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion]
If any of you wonder why I ask so many questions its because there are only two of us here and were both fresh out of college. This is my only lifeline to other web professionals. We are currently working on a project where we are delivering educational material over the web using a Flash front end and SQL Server back end. There are portions to the app where we are delivering streaming media and here is where we run into problems. We have been doing a lot of research over the past week but are having trouble getting straight answers. Wetested some stuff last night and it looks relatively ok. Nothing special just a .wmv file on the web and a link to it. Everything we look at says we need some sort of serverfor the stuff we stream but we can't find out why. I looked at flash communication server but I need to be able tojustify the purchase. Are any of youstreaming video over the web, and what components are youusing to do it with? A.
Re: [KCFusion] Upcoming meeting - ideas
Title: RE: [KCFusion] Upcoming meeting - ideas If anybody is doing anything useful with XML you would have my rapt attention. yes either either A. - Original Message - From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Tuesday, February 04, 2003 1:42 PM Subject: RE: [KCFusion] Upcoming meeting - ideas I'd like to see some working examples or example code of flash remoting if possible. I think the discussion about cf certification is a little dull. yes tuesday umkc -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 1:28 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Upcoming meeting - ideas I am hoping to put together an informal meeting early next week. Here are some ideas for what we can discuss: General experiences with Flash Remoting (developing Flash/CF websites) Current projects people are working on Flash learning curve for CF developers Upcoming meeting ideas Pros/cons of CF certification Will you attend? Which day would be better for you? Tuesday or Wednesday? Which location? Overland Park (somewhere between College Boulevard 130th Metcalf) or UMKC? Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] same field names
It does not happen too often but every blue moon or so I have a field that is named the same in two related tables. Usually I just rename a field and go about my day. Nobody but me here really knows what I'm up to anyway. Today I was making some tables and wound up with this: parentTable.state childTable.state In the parent table the state is stored in full. In the child table the state is stored as the two letter abbreviation for addresses. The problem that I usually go right around is the fact that to reference a result in a query you say: queryName.state but you can't specify which state you want. I preparation for the day when I may have to answer to someone and can't just rename a field, I was wondering if there was a way to actually reference a field in cfoutput querythat I was not privy to. A.
[KCFusion] way off topic
If I wanted to set an environment variable in UNIX called JAVA_HOME to jakarta-tomcat-4.0 what would that look like. I keep getting told that im not using the setenv command correctly. A.
[KCFusion] cfhttp vs soap
Title: Message OK so what would be the difference if any if I used SOAP to get at information on another serveror just using cfhttpand ascripting language on the remote server to do the processing. Speed im guessing but anything else? A.
Re: [KCFusion] Macs..bleh
Now see thats the way its supposed to work i thought but the connection always fails. A. - Original Message - From: Ramsey Abu-Absi To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 1:01 PM Subject: Re: [KCFusion] Macs..bleh Hi Adaryl,Check out this link:http://www.macromedia.com/support/dreamweaver/ts/documents/filemakerdw.htmIt explains how to set up an odbc connection to filemaker for use with ASP pages, but if you follow the directions to set up the data source on your CF server, the administrator should recognize the datasource.Hope that helps,RamseyAt 12:04 AM 1/10/2003, you wrote: Get them to upgrade? Sure, but it involves flying pigs and a backwards rotating earth. No seriously, this thing is the heart of the organziation. If i were to replicate it it would have to be updated every minute. But it is something I can look into, at this point Im not tossing any idea out. FM is pretty low powered im not even certain it has something akin to replication services.A. - Original Message - From: Ryan Hartwich To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 8:46 PM Subject: RE: [KCFusion] Macs..bleh Adaryl, A few thoughts, try tricking CF Filemaker. Maybe you can use an MS SQL odbc driver/connector. Or, maybe you can setup some form of replication or linking between say, Access or MS SQL and the FileMaker. Then, use CF to access the new DB. Can you just force them to upgrade to a different database? Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Thursday, January 09, 2003 4:43 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Macs..bleh Greetings all, I work in a primarily Mac environment (yes i know..pray for me). The organization has a database in FileMaker Pro 5 (on Mac of course) that is mission critical (I bet you already know what Im going to ask). The first time I tried to access it 2 summers ago from CF which sits on Win2k server it was not possible. I was wondering if in the year and a half since someone has created a working ODBC driver or is there anybody else that has some sort of workaround? I'm all over the internet without much luck. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Macs..bleh
I wonder if its just a CF thing which is to say if I wrote a Java app would I get the same problem? A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 1:33 PM Subject: Re: [KCFusion] Macs..bleh Now see thats the way its supposed to work i thought but the connection always fails. A. - Original Message - From: Ramsey Abu-Absi To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 1:01 PM Subject: Re: [KCFusion] Macs..bleh Hi Adaryl,Check out this link:http://www.macromedia.com/support/dreamweaver/ts/documents/filemakerdw.htmIt explains how to set up an odbc connection to filemaker for use with ASP pages, but if you follow the directions to set up the data source on your CF server, the administrator should recognize the datasource.Hope that helps,RamseyAt 12:04 AM 1/10/2003, you wrote: Get them to upgrade? Sure, but it involves flying pigs and a backwards rotating earth. No seriously, this thing is the heart of the organziation. If i were to replicate it it would have to be updated every minute. But it is something I can look into, at this point Im not tossing any idea out. FM is pretty low powered im not even certain it has something akin to replication services.A. - Original Message - From: Ryan Hartwich To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 8:46 PM Subject: RE: [KCFusion] Macs..bleh Adaryl, A few thoughts, try tricking CF Filemaker. Maybe you can use an MS SQL odbc driver/connector. Or, maybe you can setup some form of replication or linking between say, Access or MS SQL and the FileMaker. Then, use CF to access the new DB. Can you just force them to upgrade to a different database? Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Thursday, January 09, 2003 4:43 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Macs..bleh Greetings all, I work in a primarily Mac environment (yes i know..pray for me). The organization has a database in FileMaker Pro 5 (on Mac of course) that is mission critical (I bet you already know what Im going to ask). The first time I tried to access it 2 summers ago from CF which sits on Win2k server it was not possible. I was wondering if in the year and a half since someone has created a working ODBC driver or is there anybody else that has some sort of workaround? I'm all over the internet without much luck. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Macs..bleh
Greetings all, I work in a primarily Mac environment (yes i know..pray for me). The organization has a database in FileMaker Pro 5(on Mac of course) that is mission critical (I bet you already know what Im going to ask). The firsttime I tried to access it 2 summers ago from CF which sits onWin2k server it was not possible. I waswondering if in the year and a half since someone has created a workingODBC driver or is there anybody else that has some sort of workaround? I'm all over the internet without much luck. A.
Re: [KCFusion] a design question (off topic)
Thanks Daryl. I usually submit the form in the function with the js submit() method. If having it return true/false is better I will go that route in the future. A. - Original Message - From: Daryl Banttari To: [EMAIL PROTECTED] Sent: Saturday, December 07, 2002 2:07 PM Subject: Re: [KCFusion] a design question (off topic) Adaryl, The onClick handler for submit buttons requires that you return a "true" or "false" value from the handler, which determines whether or not the form submission actually happens. If you wanted the form to actually submit after the "goEmail()" function completes, you'd do this: Conversely, if you did not want the form to submit, you'd return false. If you want goEmail() to decide whether the form submits, have the functionreturn a true or false value, and codethe submit button's onClick handlerthis way: n.b. The use of "javascript:" is only requred in HREF attributes of links; and onClick handlers work similarly for links (they should also return "true" or "false" toindicate whether the link should actually followed.) If you don't return a true/false for an onClick handler in these cases, the behavior is undefined/unpredictable. HTH --Daryl - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:12 PM Subject: [KCFusion] a design question (off topic) I've hit an odd issue. I have a simple submit button that calls a js function when clicked. The problem is it does not work in Netscape6 (go figure). The buttons don't even respond to mouse clicks or anything its all very odd. This is not normally part of my job (graphics, yik)and I know some of you do this full time. The tag looks like this: input type="Submit" name="email" value="Go" Anybody see anything glaringly wrong with it? A.
[KCFusion] a design question (off topic)
I've hit an odd issue. I have a simple submit button that calls a js function when clicked. The problem is it does not work in Netscape6 (go figure). The buttons don't even respond to mouse clicks or anything its all very odd. This is not normally part of my job (graphics, yik)and I know some of you do this full time. The tag looks like this: input type="Submit" name="email" value="Go" Anybody see anything glaringly wrong with it? A.
[KCFusion] error var
I set it up so I get an email when ever one of my apps tosses an error. Except it seems that #error.template# is not working. I got that variable from a WROX professional book . Before I go digging around the discussion boards anybody know off the top of their head what the right variable is supposed to be? Im using CF 5. A.
Re: [KCFusion] error var
No I get an error. Here is the output of the email: An error has occurred. Date and Time of Error: 11/26/02 14:31:43 IP Address of Client: 129.130.205.159 Query String Parameters were: Template that caused error: Client Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; YComp 5.0.0.0; .NET CLR 1.0.3705) Error Diagnostics: Just in time compilation error Invalid parser construct found on line 15 at position 23. ColdFusion was looking at the following text: Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (12:61) to (15:15). The specific sequence of files included or processed is: C:\Inetpub\wwwroot\\\doGoEmail.cfm I can pretty much glean what went wrong where from the last line but it still kinda bothers me that that variable does not appear to be right. You can see up where it says Template that caused error is empty. A. - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 2:59 PM Subject: Re: [KCFusion] error var Are you getting an error of some sort? Or is it just not sending? -- Original Message -- From: Adaryl Wakefield [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 26 Nov 2002 14:40:32 -0600 I set it up so I get an email when ever one of my apps tosses an error. Except it seems that #error.template# is not working. I got that variable from a WROX professional book . Before I go digging around the discussion boards anybody know off the top of their head what the right variable is supposed to be? Im using CF 5. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] ghost in the machine?
I started to do some work this afternoon only to disturbingly find all the system DSNs had magically vanished. When ever it happened it happened over night so I can rule out my boss doing something strange. We are running Win 2K server. Anybody encounter this before? A.
[KCFusion] on top of that
IP debug settings are gone and so are all the directory security settings. A.
[KCFusion] actual space
I had designed a table by where one attribute was going to be occasionly set to null. One of the people in my work group said "No thats bad. It takes up too much space" (ie memory) and proceeded to make a whole other table to handle situations where that one attibute was going to be set to null. I looked at him funny but went along with it.My question is how much space does a nullvalue actually take up as compared to creating another table. A.
[KCFusion] sorry can't resist
Hey guys look! Reasonable job requirements!!! A. - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 8:49 AM Subject: [KCFusion] ColdFusion Opening (Contract) in KC Contract CF Position, please contact recruiter below: --- Contract opening in KC: Required skills: Cold Fusion Studio 5, CF Script, SQL for Microsoft SQL Server, and HTML Desirable Skills: Dreamweaver Ultradev 4, JSP, ASP, Java Script, and VB Script Project Description: Finalizing three project designs for new applications. A contractor will be required to help develop and implement these projects utilizing Cold Fusion and SQL Server. Dave Nelson J. M. Neil Associates, Inc. [EMAIL PROTECTED] 816-941-4997 x.218 816-941-4531 fax __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion]
Huge ruckus broke out in one of my project groups yesterday. It was over the definition of Boyce-Codd normal form.Iknow the definition is every every determinate is a candidate key. We were going round and round about what constitutes a determinate.I said if the table looked like this masterList(masterID, fName, LName, userName, password) we would be ok. Another guy said we need to break up the table because userName and masterID uniquely identify the tuple. I said that it only uniqly identifies the tuple if we say so. This went on for about half an hour withmanyvalid points on both sidesand wound up a jump ball. Anybody care to settle this bar fight? A.
Re: [KCFusion] changes between cold fusion server 4.5 and 5.0
Out of curiosity why did you go to 5.0 insted of MX? A. - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: CF-List (E-mail) [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:09 PM Subject: [KCFusion] changes between cold fusion server 4.5 and 5.0 can anyone tell me of any know problems found when upgrading from cold fusion server 4.5 to 5.0? we've currently upgrade from 4.5 to 5.0. i have'nt seen any thing as of yet. but i need to test the application running under the newer server upgrade. or does anyone know of a white paper on the issues of upgrading from cold fusion server 4.5 to 5.0? thanx. Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] changes between cold fusion server 4.5 and 5.0
Well that does not make much sense. I could have sworn MX was cheaper, no? A. - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:22 PM Subject: RE: [KCFusion] changes between cold fusion server 4.5 and 5.0 funding i guess... i'm a gov't contractor. -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] changes between cold fusion server 4.5 and 5.0 Out of curiosity why did you go to 5.0 insted of MX? A. - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: CF-List (E-mail) [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:09 PM Subject: [KCFusion] changes between cold fusion server 4.5 and 5.0 can anyone tell me of any know problems found when upgrading from cold fusion server 4.5 to 5.0? we've currently upgrade from 4.5 to 5.0. i have'nt seen any thing as of yet. but i need to test the application running under the newer server upgrade. or does anyone know of a white paper on the issues of upgrading from cold fusion server 4.5 to 5.0? thanx. Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] KC CF employment opportunity
Wow, I'm glad I'm not the first person to notice that job requirements were a little outrageous. All this time I just thought it was my college prospective. A. - Original Message - From: Keith Purtell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:58 PM Subject: RE: [KCFusion] KC CF employment opportunity It's not you. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daryl Banttari Sent: Wednesday, September 18, 2002 1:47 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] KC CF employment opportunity Candidate should also: - Be able to do high-level management, yet retain a current, practical knowledge of 80386 machine language and have memorized the complete Win32 API; - Have a Zodiac sign of Pisces, Virgo, or Leo. Aquarius will not be considered; - Have between 18 and 24 months' practical experience in quantum mechanics; - Have studied golf at a university in Scotland; - Served between 2 and 6 months in jail for a gross misdemeanor, but not felony, offense; And of course, - This ten year IT vet should be willing to work for under $25/hr, with the employer's option to convert to a salaried position at half that rate. Is it me, or are these job orders getting a bit ridiculous these days? --Daryl - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:24 PM Subject: [KCFusion] KC CF employment opportunity -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Subject: employment opportunity Skills Set: Candidate must have at least ten years of progressive IT software development and software management experience using structured system development methodologies as well as systems life cycle management methodology. Must have Four years of experience in designing Web sites, integrating Web and Database applications, managing and controlling system development projects using system life cycle management, system development methodologies and structured analysis and design techniques. Project experience must include client-server, web-enabled. and standalone applications. Detailed knowledge of Cold Fusion, Visual Basic and C++. Contract for hire position, must be willing to convert. Position is located in Kansas City. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] deletes on database?
Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds significant complexity. However, I would love to hear from those who have used this method in large, formal design groups. It may be the way to go. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Wednesday, September 11, 2002 10:10 PM To: [EMAIL PROTECTED] Subject: [KCFusion] deletes on database? I once saw a job announcement that said something to the effect. ..no deletes on the database will be allowed. All deletes are done via XML... At the time I just raised my eyebrow and went on but now I'm kinda curious if anybody can shed some light on what exactly they meant. I only have an academic understanding of XML and a small one at that. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] deletes on database?
See that i knew. I have been diving though my libary all day for a better explantion though. Care to elaborate if you have time? The only security issue that i am aware of is the url attack which can be defended with cfqueryparam. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:55 PM Subject: Re: [KCFusion] deletes on database? Folks, One of the chief reasons for using stored procedures is to make applications more secure. Girish Daryl Banttari [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 01:33 PM Please respond to CF-List I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds
[KCFusion] deletes on database?
I once saw a job announcement that said something to the effect. "..no deletes on the database will be allowed. All deletes are done via XML..." At the time I just raised my eyebrow and went on but now I'm kinda curious if anybody can shed some light on what exactly they meant. I only have an academic understanding of XML and a small one at that. A.
[KCFusion] off topic
Does anyone know if there is a Microsoft equivalent of Macromedia's Developer Exchange for ASP.net. A.
Re: [KCFusion] Affordable Co-location in Kansas City?
Would somebody be cool enough to explain what co-location is off list? Sorry guys I spend all day with social workers. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] creating an RDS
Is the RDS you are creating for a local machine? What are the settings you are using? Or have you solved this by now? A. P.S. I have your same set up and I can create an RDS but I sometimes have trouble if it is for localhost. - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: CF-List (E-mail) [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 10:12 AM Subject: [KCFusion] creating an RDS i'm using cf studio 4.5a and cf server administor 5.0 ... but i can't create an (RDS) RemoteDevelopment Server with server administrator 5.0. it works with server administrator 4.5... is this something that is'nt support using administrator 5.0? Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] help reading a text file...
The only method i'm aware of is to use cfhttp then you can execute a query off that. Looks like: cfhttp method=get url=http://www.yoursite.net/foo.txt (--should be quotes around that) name=grabTextFile delimiter=, Then you can output it just like a cfquery like so: cfouput query=grabTextFile#grabTextFile.columnName#/cfoutput Thats straight from the text book. I have not had opportunity to try this in real life so I can't comment reliably on performance. A. - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 12:55 PM Subject: [KCFusion] help reading a text file... what's the best way to read a very large tab delimeted text file? does cf.. read the whole file into one variable... how does this get effected if you're reading a large file? Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] Johnson, Michael.vcf __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] SQL brain teaser
(is this thing on?) So I ran accross a problem the other day, solved it, but it is not the most elegant solution I think. If anybody sees something cleaner right off I'd much apprciate a reply. If not I would not attempt this while you are at work. The problem: We have knowlege base that is organized such that questions will be grouped under categories. I needed to yank back all categories that start with a certain letter, count the questions in those categories and display the categories, the the count of the questions and one and only one question from each category. The last part was the tough one. Long story short, I stumbled accross the group attribute of the cfoutput tag which is great but im still getting far more tuples then I actually need (every single question comes back but only one gets displayed). Here is the query i developed: SELECT table1.Cat_num, table1.Category, table2.question, (SELECT Count(table2.question_ID) as theNumQuestions FROM table2 WHERE table1.Cat_num = table2.Cat_num) as numQuestions, FROM table1, table2 WHERE table1.Category LIKE 'A' AND table1.Cat_num *= table2.Cat_num ORDER BY table1.Category Adaryl __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] SQL brain teaser
Hmmm! There are some things in there I have never seen before. Whats with the # sign before the table names? Is that something DBMS specific? A. - Original Message - From: Chris Stallo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 19, 2002 7:44 AM Subject: Re: [KCFusion] SQL brain teaser I set up two tables. #tmp_cat contains a cat_number and category description. #tmp_question contains a cat_number and the question. cat_number is the relationship between the two. The thing that helps is the TOP command in SQL. It returns the TOP N rows back. select category, count(q.question), 'question' = (select top 1 question from #tmp_question Q2 where Q2.cat_num = T.cat_num AND left( Q2.question, 1) = 'A') from #tmp_cat T join #tmp_question Q on Q.cat_num = T.cat_num where left( question, 1) = 'A' group by T.cat_num, category With the combination of the TOP and the Group By it will return the data like this. category num_quessample question Advice 2 Always do this General 3 All people are not cool Specific1 Apples are red Chris --- Adaryl Wakefield [EMAIL PROTECTED] wrote: (is this thing on?) So I ran accross a problem the other day, solved it, but it is not the most elegant solution I think. If anybody sees something cleaner right off I'd much apprciate a reply. If not I would not attempt this while you are at work. The problem: We have knowlege base that is organized such that questions will be grouped under categories. I needed to yank back all categories that start with a certain letter, count the questions in those categories and display the categories, the the count of the questions and one and only one question from each category. The last part was the tough one. Long story short, I stumbled accross the group attribute of the cfoutput tag which is great but im still getting far more tuples then I actually need (every single question comes back but only one gets displayed). Here is the query i developed: SELECT table1.Cat_num, table1.Category, table2.question, (SELECT Count(table2.question_ID) as theNumQuestions FROM table2 WHERE table1.Cat_num = table2.Cat_num) as numQuestions, FROM table1, table2 WHERE table1.Category LIKE 'A' AND table1.Cat_num *= table2.Cat_num ORDER BY table1.Category Adaryl __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] at a loss
Ok a while back I was looking at implementing advanced security for our intranet. Some one suggested that I get the book Professional CF 5.0 which I did (and is a great resource btw) but it did not cover what I really need to know about advanced security. I think I have everything down as far as policies and what not but defining user directories from an ODBC data source is really very fuzzy every time I try to read about it (this is from the Advanced CF Administrator book by Macromedia). It says there is an .ini filenamed SmDSQuery.ini in the cfusion/bin directory that is supposed to be used but it is missing off my server. On top of that I am not too certain what I am looking at in the book. Its on page 94 if any of you have the book I speak of. The edit user directory page in the administrator is not well explained either. Can anybody explain how all this works clearer? A.
Re: [KCFusion] Parsing two lists
Would you be willing to send us a code snippit? I am not quite sure i have a handle on the problem. A. - Original Message - From: Keith Purtell [EMAIL PROTECTED] To: KCFusion (E-mail) [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:44 AM Subject: [KCFusion] Parsing two lists This should be simple but my code keeps failing. I have a form that sends multiple values for the same form field. They arrive at my processing template as two lists; one for the item being ordered and another for quantity. Field name Value -- -- Item Servers,Modems,Printers ItemQty8,6,5 The output I seek is: 8 Servers 6 Modems 5 Printers I can't change the sending form; it's a mixture of CF, HTML and JavaScript that has been declared final. However I'd like assistance with the processing end. Any tips on the easiest way to approach this? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] OT: browser type
A I was wondering what that /cgi-bin/formmail.pl thing was that kept showing up. What is that exactly and what are they after, and should I be overly worried? A. - Original Message - From: Daryl Banttari [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 10:36 AM Subject: Re: [KCFusion] OT: browser type Probably a Java-based vulnerability scanner. If your site is linked a lot, expect /many/ of these sorts of attempts every day. Things like: (a sample of the most popular vulnerability scans from my logs) /_vti_bin/_vti_aut/author.exe /cgi-bin/formmail.pl /msoffice/cltreq.asp /_vti_bin/owssvr.dll /cgi-bin/formmail.cgi /cgi-local/formmail.pl /cgi-local/formmail.cgi /cgibin/formmail.cgi /cgibin/formmail.pl And, of course, all of the usual CodeRed and CRII scans. (Which are blocked by my firewall software and never make it into my logs.) --Daryl - Original Message - From: Keith Purtell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 9:03 AM Subject: RE: [KCFusion] OT: browser type Well, the page request came from an overseas IP address, and they were trying to access a page that might contain information about administrators, so I was suspicious. Thanks for the info. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Monday, April 15, 2002 8:55 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: browser type Java 1.3.0 is one of the current standard versions of the java virtual machine. I believe the numbers are the same as what is installed by Netscape 6/6.2 and is or was one of the versions that Jrun and the betas of CF MX uses. You might be seeing another server trying to pull a page versus a browser, or just a funky Unix browser like Mozilla that is highly dependent on Java. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Query of query not working
or how bout
INSERT INTO DetailTable
(Id, SeqId, Qty, InvId)
SELECT Id, SeqId, Qty, InvId
FROM WorkingTable
WHERE Id = '#form.Id#
- Original Message -
From: Keith Purtell [EMAIL PROTECTED]
To: KCFusion (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:20 PM
Subject: [KCFusion] Query of query not working
Since we run CF5, I occasionally use the query-a-query feature. However
the
following code is not working. The first query runs just fine, but the
query
that follows either never runs or generates an error message Insert not
supported. As long as valid data is in the structure (query object)
returned by the first query, shouldn't I be able to loop through that and
insert the data into another table?
CFQUERY NAME=GetRecs DATASOURCE=Database1
SELECT Id, SeqId, Qty, InvId
FROM WorkingTable
WHERE Id = '#form.Id#'
/CFQUERY
CFLOOP FROM=1 TO=#GetRecs.RecordCount# INDEX=i
CFQUERY DBTYPE=query NAME=AddRecords
INSERT INTO DetailTable
(Id, SeqId, Qty, InvId)
VALUES
('#GetRecs.Id[i]#','#GetRecs.SeqId[i]#','#GetRecs.Qty[i]#','#GetRecs.InvId[i
]#')
/CFQUERY
/CFLOOP
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email: [EMAIL PROTECTED]
CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Advanced security
Greetings all! I am busy setting up advanced security on the CF server. The Advanced server administration book by Macromedia is woefully inadequate in this area. Anybody have better ideas for a resource? A.
Re: [KCFusion] Searching for Links
Well you have some missing cfoutput tags and some single quotes where there
should be double quotes and a missing closing cfif tag. I don't know if that
all matters but the biggest thing is that you were misusing the Mid()
function. The count argument is the number of chars to return. You had it
getting more chars than you needed. This seems to work:
cfset body = This is a test http://www.ksu.edu and some stuff at the
end.
Cfif body CONTAINS http://;
CFSET Start = FindNoCase(http://;, Body) !--Find the start of the
URL--
CFSET End = Find( , Body, Start) !-- from the start of the URL look
for the space--
!--- Now find the lenght of the string. ---
cfset length = end - start
CFSET TLink = Mid(Body, Start , length) !--Set Tlink to be from the Start
to
the end--
cfoutputcfset Link = a href='#TLink#'#Tlink#/a/cfoutput
cfoutput#Link#/cfoutput
/cfif
Adaryl
- Original Message -
From: cfhelp [EMAIL PROTECTED]
To: 'KCFusion' [EMAIL PROTECTED]
Sent: Sunday, February 24, 2002 11:20 AM
Subject: [KCFusion] Searching for Links
I need to make text URL's in messages a link on a web page.
The message will contain http:// in the body somewhere and may have more
than one. I need to search that message and replace it with the HTML code
to
make it a Hyperlink.
Cfif #Body# CONTAINS ' http://'
CFSET Start = FindNoCase(' http://', Body) !--Find the start of the
URL--
CFSET End = Find(' ', Body, Start) !-- from the start of the URL look
for the space--
CFSET TLink = Mid(Body, Start , End) !--Set Tlink to be from the Start
to
the end--
cfset Link = a href=#TLink##Tlink#/a
cfoutput#Link#/cfoutput
The above is not working and I don't think if it did it would work if
there
are more than one link in the message.
Is there another solution or Custom Tag that will output URLs as
hyperlinks?
Thanks in advance
Rick
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] passwords
I wish to be able to give people their passwords that they select for their accounts back to them so that they may print them out and have them for reference in case they forget their password. I thought about justoutputting it back to them when they created their account butthatdidnot sound like a bright idea. ThenI thought mabey sending their password in an email might be a better idea. Anybody have any thoughts or pros and cons to this? Adaryl
[KCFusion] reinstall
RDS has suddenly decided to stop working. When ever I try to log in I get a remote server error message. I'm inclined to just reinstall the server to try to fix the problem. Anybody care to advise against this course of action (i.e. anybody got a better idea)? Adaryl __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] off topic - classpath, xml and java
As some of you might have noticed I am not a computer programmer by academic training. Its something I did for fun that happened to pay really well. As a result some of the newer web technologies fly right over my head. I have read about XML but the only definition I can gleen is it describes data which is absolutly undescriptive and meaningless. Can someone explain briefly what XML is supposed to help me do better? Adaryl __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] arrays and querys
Ok so after a bit of guess work this is what I came up with: CFQUERY NAME="test" DATASOURCE="ReservationSystem"SELECT date_numFROM dbo.DatesTimes Where class_num = 4;/CFQUERY cfset date_nums = ArrayNew(1)cfloop query="test"cfset date_nums[test.currentRow] = date_num /cfloop Is it possible to make this more efficient or elegant (i.e. professional)? Adaryl
Re: [KCFusion] adding databases
So then is it common practice to have like a whole bunch of datasources? A. - Original Message - From: Daryl Banttari To: [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 6:52 PM Subject: Re: [KCFusion] adding databases Not without adding more datasources. --sorry-- Daryl - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Monday, September 24, 2001 7:16 PM Subject: [KCFusion] adding databases It used to be that everytime I made a new database I would create a new datasource. Someone showed me how to have one datasource and then specify which database I wanted to use in my CFQuery tag. The problem with that is in the database tab of the resource window (is that what it is called?) does not show any tables besides the ones from the database I have listed as the default in the ODBC datasources wizard in Win2K. Is there any way to have other tables added to the database tab? A.
[KCFusion] adding databases
It used to be that everytime I made a new database I would create a new datasource. Someone showed me how to have one datasource and then specify which database I wanted to use in my CFQuery tag. The problem with that is in the database tab of the resource window (is that what it is called?) does not show any tables besides the ones from the database I have listed as the default in the ODBC datasources wizard in Win2K. Is there any way to have other tables added to the database tab? A.
Re: [KCFusion]
ok so sounds like we have some scratchy ideas, anybody willing to take point if not I'd love the challenge. Adaryl - Original Message - From: Keith Purtell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 11:25 AM Subject: RE: [KCFusion] Maybe to get things started we could circulate a round-robin tip sheet? Names of companies that use ColdFusion and might be hiring? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marshall Anderson Sent: Tuesday, August 21, 2001 11:23 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] I would be very interested in this service as well. I have been searching for a CFJob in KC for a couple months now. At 11:16 AM 08/21/2001 -0500, you wrote: KCFusion doesn't maintain any kind of a job bank or job-hunting tip sheet that I know of. Considering the difficulty of finding CF projects in KC, maybe we should. I would suggest that it could be a feature on the Web site, but if I do that, Bryan will brand me as a volunteer. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Cloutier Sent: Tuesday, August 21, 2001 10:39 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Anyone have any idea where to look for ColdFusion work in KC? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] Marshall Anderson [EMAIL PROTECTED] Web Page Design Professional Mentoring, LLC PH: 1-888-233-8469 FAX: 1-800-669-1132 http://www.pro-mentoring.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] now what?
No it really does say 12:20 AM underneath received. Having a little early morning fight with RDS. As far as I know I have my server development mappings are set right Studio Path: RDS://the_server_url/C:Inetpub/wwwroot Server Path: C:\Inetpub\wwwroot Browser/URL Path: http://the_server_url I can see the files but when ever I go to browse it tells me to add a development mapping? Huh? What piece of arcane knowledge am I missing? A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] debugging
Anybody have a clue what is wrong with this,I
keep geting told that there is a semicolon missing.
CFQUERY NAME="2"
DATASOURCE="perspectives"INSERT INTO
questiontest(question)VALUES('#Form.question#')UNIONINSERT INTO
questiontest(Cat_num)Select Cat_NumFrom CategoriesWhere
Categories.Category = '#Form.Category#'; /cfquery
A.
Re: [KCFusion] debugging
No good. I should have explained better. I need to
throw information collected from a form into fourrelated tables. I cannot
find anykind of example to do this.The problem I am running into is
I have four statements wrapped in cftransaction tags but each
insertstatement is creating its own row instead of onecell
ofexported data and onecell of collected form data all inone
row.
Inpseudo code
Insert into tableAtwo
columns
one column is form
data
the second column is collected
from a previous table (the foreign key for table
A)
- Original Message -
From:
Don Buck
To: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 10:06
AM
Subject: RE: [KCFusion] debugging
Take
the UNION out of your query. Union is a function for combing the results
of two or more queries. It has no practical purpose for inserting data
into a database. Your query should run fine without the UNION
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl
WakefieldSent: Tuesday, July 31, 2001 9:56 AMTo:
[EMAIL PROTECTED]Subject: [KCFusion]
debugging
Anybody have a clue what is wrong with
this,I keep geting told that there is a semicolon
missing.
CFQUERY NAME="2"
DATASOURCE="perspectives"INSERT INTO
questiontest(question)VALUES('#Form.question#')UNIONINSERT
INTO questiontest(Cat_num)Select Cat_NumFrom CategoriesWhere
Categories.Category = '#Form.Category#'; /cfquery
A.
Re: [KCFusion] debugging
Thats the easy part. How you get form data for the second column to go with it? A. - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 4:43 PM Subject: RE: [KCFusion] debugging Try doing a select on the column you need and using the result when you insert into the 2nd table. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl Wakefield Sent: Tuesday, July 31, 2001 4:38 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] debugging No good. I should have explained better. I need to throw information collected from a form into four related tables. I cannot find any kind of example to do this. The problem I am running into is I have four statements wrapped in cftransaction tags but each insert statement is creating its own row instead of one cell of exported data and one cell of collected form data all in one row. In pseudo code Insert into table A two columns one column is form data the second column is collected from a previous table (the foreign key for table A) __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] DOMO ARIGOTO!
It struck me like lightning what Ryan was trying to say 15 seconds before
Ryan emailed me, but I did not know the use of cftry and cfcatch so you both
helped. It works now. That has been bothering me for 3 days. You guys are an
awsome resource! Thanks for the input.
A.
- Original Message -
From: Matthew W Jones [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 4:47 PM
Subject: RE: [KCFusion] debugging
cfset commitit = true
cftry
cftransaction action=begin
cfquery name=getCatNums datasource=perspectives
Select Cat_Num
From Categories
Where Categories.Category = '#trim(Form.Category)#';
/cfquery
cfoutput query=getCatNums
CFQUERY NAME=two DATASOURCE=perspectives
INSERT INTO questiontest(question,Cat_num)
VALUES
('#Form.question#',#val(cat_num)#)
/cfquery
/cfoutput
cfcatch type=database
cftransaction action=rollback/
cfset commitIt = False
/cfcatch
cfif commitIt
cftransaction action=commit/
cfelse
cfset commitIt = True
/cfif
/cftransaction
/cftry
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 4:53 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] debugging
Thats the easy part. How you get form data for the second column to go
with
it?
A.
- Original Message -
From: Ryan Hartwich [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 4:43 PM
Subject: RE: [KCFusion] debugging
Try doing a select on the column you need and using the result when you
insert into the 2nd table.
Ryan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Adaryl Wakefield
Sent: Tuesday, July 31, 2001 4:38 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] debugging
No good. I should have explained better. I need to throw information
collected from a form into four related tables. I cannot find any kind
of
example to do this. The problem I am running into is I have four
statements
wrapped in cftransaction tags but each insert statement is creating its
own
row instead of one cell of exported data and one cell of collected form
data
all in one row.
In pseudo code
Insert into table A two columns
one column is form data
the second column is collected from a previous table (the foreign
key
for table A)
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] a SQL question
I need to insert data into multiple tables that are related. Every example of an insert statement I have seen only inserts info into one table. Do I need to write 4 different INSERT statements? A.
[KCFusion] SQL server data source fail
I am having a problem connecting to a SQL server DB on Win2K using the merant drivers on a Linux server. I have already patched the server and am still getting problems. I am digging through the CF forums but would any of you happen to have trouble shooting suggestions? A.
