Re: Rick Colman...
I am not doing anything ... so there may be a virus problem on my end. will fix. apologies. On 8/1/2011 2:39 PM, Bobby Hartsfield wrote: Anyone else getting tons of empty emails from rick colman? Not to the list but directly to my email address... If you sit next to rick pinch his nipple for that, then twist it for whatever he may be planning to do with my email address .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form Field Validation - codon boundaries
I should have provided more detail.
This has to do with nucleotide strings in DNA.
for example, consider the follow string:
123 456 789
act gta ccc ... (spaces not in string, just for clarity)
Any start position must begin at position 1,4,7, etc.
Any end position must conclude at position 3,6,9 etc.
So, I am not sure the function below would do exactly what I need??
On 5/7/2011 4:40 AM, Jason Fisher wrote:
If startVal, endVal, and lengthVal represent your values in JS [like var
startVal = parseInt(myForm.start.value); ], then the following should work:
if (startVal % 3 != 0) {
alert(Start must be a multiple of 3.);
return false;
} else if (endVal % 3 != 0) {
alert(End must be a multiple of 3.);
return false;
} else if (endVal startVal) {
alert(End must be larger than Start.);
return false;
} else if (endVal lengthVal) {
alert(End cannot be larger than Length.);
return false;
}
return true;
You could put that into a function and call the function on the form
onsubmit(return myFunction()).
On 5/6/2011 5:51 PM, Rick Colman wrote:
I have the following:
length: xxxstart [ ] end [ ]
I would like to test for the following conditions:
* must be an integer
* start and end must be evenly divisible by 3
* end cannot exceed length
CFINPUT works for type test, but not sure how to generate the javascript
validation that would be required.
Rick.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Form Field Validation
I have the following: length: xxxstart [ ] end [ ] I would like to test for the following conditions: * must be an integer * start and end must be evenly divisible by 3 * end cannot exceed length CFINPUT works for type test, but not sure how to generate the javascript validation that would be required. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
converting sed to rereplace ...
I am trying to convert strings:
(A XXX)(B YYY)(C ZZZ) etc.
to
XXXYYYZZZ etc.
This works in sed:
echo (A XXX)(B YYY)(C ZZZ) | \
sed -n '
{
s/([A-Z]* \([A-Z]*\))/\1/g
p
}
'
but when I put it into rereplace, like:
cfset construct[LoopCount] = rereplace(#construct[LoopCount]#,
[A-Z]*, \([A-Z]*\))/\1/gp, all)
I am getting:
\([A-Z]*\))//gp(\([A-Z]*\))//gp
\([A-Z]*\))//gp)\([A-Z]*\))//gp(\([A-Z]*\))//gp
\([A-Z]*\))//gp)\([A-Z]*\))//gp(\( etc.
so I am doing something really wrong.
Please help.
TNX.
Rick.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344283
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: converting sed to rereplace ...
Eureka! TNX.
On 5/5/2011 3:13 PM, Bobby Hartsfield wrote:
cfset str = (A XXX)(B YYY)(C ZZZ) /
cfset newstr = rereplace(str, \([A-Z] ([A-Z]{3})\), \1, all) /
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Rick Colman [mailto:rcol...@cox.net]
Sent: Thursday, May 05, 2011 5:43 PM
To: cf-talk
Subject: converting sed to rereplace ...
I am trying to convert strings:
(A XXX)(B YYY)(C ZZZ) etc.
to
XXXYYYZZZ etc.
This works in sed:
echo (A XXX)(B YYY)(C ZZZ) | \
sed -n '
{
s/([A-Z]* \([A-Z]*\))/\1/g
p
}
'
but when I put it into rereplace, like:
cfset construct[LoopCount] = rereplace(#construct[LoopCount]#,
[A-Z]*, \([A-Z]*\))/\1/gp, all)
I am getting:
\([A-Z]*\))//gp(\([A-Z]*\))//gp
\([A-Z]*\))//gp)\([A-Z]*\))//gp(\([A-Z]*\))//gp
\([A-Z]*\))//gp)\([A-Z]*\))//gp(\( etc.
so I am doing something really wrong.
Please help.
TNX.
Rick.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344286
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex Question
input looks like: (A XXX)(B YYY)(C ZZZ) I need to pull out: XXXYYYZZZ ... Can somebody help? TNX. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Regex Question
would it ignore the parens and space? will try shortly. TNX!
On 4/28/2011 1:17 PM, Andy Matthews wrote:
That seems like it might do the trick:
http://regexr.com?2tl99
Could be as simple as \w{3}
Would that do it (searching for 3 consecutive word characters)?
--
Charlie Griefer
http://charlie.griefer.com
I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.
On Thursday, April 28, 2011 at 10:10 AM, Rick Colman wrote:
input looks like:
(A XXX)(B YYY)(C ZZZ)
I need to pull out:
XXXYYYZZZ ...
Can somebody help?
TNX.
Rick.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344032
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
will not export excel to excel
I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: will not export query to excel
this works: cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- !--- cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; #url.id#-export.csv --- cfset thefile=Location#chr(delim)#Score#chr(delim)# cfset thefile= #thefile# #chr(13)#!--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettemp cfset thefile= #thefile# #location##chr(delim)##score##chr(13)# /cfloop cfset exportallfile=#GetDirectoryFromPath(GetBaseTemplatePath())##url.id#-export.csv CFFILE ACTION=write FILE=#exportallfile# OUTPUT=#thefile# cfoutputcfset savefilename=#url.id#-export.csv/cfoutput !--- Push file to Client Browser --- CFHEADER NAME=Content-disposition VALUE=attachment; filename=#savefilename# cfcontent file=#exportallfile# type=application/ms-excel deletefile=no On 4/20/2011 2:50 PM, Rick Colman wrote: I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: will not export query to excel
this works: cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- !--- cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; #url.id#-export.csv --- cfset thefile=Location#chr(delim)#Score#chr(delim)# cfset thefile= #thefile# #chr(13)#!--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettemp cfset thefile= #thefile# #location##chr(delim)##score##chr(13)# /cfloop cfset exportallfile=#GetDirectoryFromPath(GetBaseTemplatePath())##url.id#-export.csv CFFILE ACTION=write FILE=#exportallfile# OUTPUT=#thefile# cfoutputcfset savefilename=#url.id#-export.csv/cfoutput !--- Push file to Client Browser --- CFHEADER NAME=Content-disposition VALUE=attachment; filename=#savefilename# cfcontent file=#exportallfile# type=application/ms-excel deletefile=no On 4/20/2011 2:50 PM, Rick Colman wrote: I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Open source - No Mortgage
I guess I am old school but I have car payments, a mortgage, etc. etc. All of this open source/freeware stuff leaves me a little mystified. I suppose that it is possible to make some money around the edges of these technologies, but, I have this vision of an army of geeks working on these open source projects while they live in the garage of their parents house ... Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Exporting a Spreadsheet file
This works fine in IE, etc. : cfheader name=Content-Disposition value=buylist_job_#session.projectid#.xls However, in Google Chrome, it writes a file with a .CFM extension instead of a .XLS extension, causing problems for users. Anyone else seen this problem? Is the a CF workaround? Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Exporting a Spreadsheet file
This worked! TNX. On 12/20/2010 10:46 AM, Ian Skinner wrote: On 12/20/2010 10:41 AM, Rick Colman wrote: This works fine in IE, etc. : cfheader name=Content-Disposition value=buylist_job_#session.projectid#.xls This is the way I usually see and use that tag. cfheader name=Content-Disposition value=filename=Result.xls NOTE the *filename=* part of the value parameter. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Passing a Variable from within a loop to CFWINDOW
I am looping to populate a form with a variable number of form fields,
as needed.
I am also trying to call a CFWINDOW from within a loop as follows:
onClick=ColdFusion.Window.show('SelectConstruct')
How do I pass a variable that shows the current loopcount to the CFWINDOW?
I don't even know if I am explaining this right ...
TNX.
Rick.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340074
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Monster Regex
Been whacking at this one for a while, and it eludes me. ((T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) ;0-9 (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ;1210-1218) remove only single leading paren ( remove only trailing single paren ) leave all others remove ;xxx-yyy at the end of each line (unix line) where xxx is a number and yyy is a number so that the result looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) You will advance the state of genomic science !!! (yuck ... I hate RE ...) Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Monster Regex
this mostly worked, but did not remove one of the last trailing double )) results like: (T ACT) (N AAC) (D GAT) (T ACT) (A GCT) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ) On 12/6/2010 11:26 AM, Jason Fisher wrote: clean = replaceList(reReplace(x, \s*;\d+-\d+, , all), ((,)), (,)) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Monster Regex
this removed the leading parent, but did not remove the ;xxx-yyy numbers at the end of each line or the final trailing paren ) like (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ;1210-1218 ) On 12/6/2010 11:16 AM, Jacob Munson wrote: cfset str = reReplace(str,^\(,) cfset str = reReplace(str,;\d+-\d+\),) On Mon, Dec 6, 2010 at 12:03 PM, Rick Colmanrcol...@cox.net wrote: Been whacking at this one for a while, and it eludes me. ((T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) ;0-9 (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ;1210-1218) remove only single leading paren ( remove only trailing single paren ) leave all others remove ;xxx-yyy at the end of each line (unix line) where xxx is a number and yyy is a number so that the result looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) You will advance the state of genomic science !!! (yuck ... I hate RE ...) Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Monster Regex
getting malformed regular expression )\s*) thank you ! On 12/6/2010 12:41 PM, Jason Fisher wrote: Just add a space checker inside the '))', then, something like this: clean = reReplace(replace(reReplace(x, \s*;\d+-\d+, , all), ((, (, all), )\s*), ), all) From: Rick Colmanrcol...@cox.net Sent: Monday, December 06, 2010 3:28 PM To: cf-talkcf-talk@houseoffusion.com Subject: Re: Monster Regex this mostly worked, but did not remove one of the last trailing double )) results like: (T ACT) (N AAC) (D GAT) (T ACT) (A GCT) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ) On 12/6/2010 11:26 AM, Jason Fisher wrote: clean = replaceList(reReplace(x, \s*;\d+-\d+, , all), ((,)), (,)) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Monster Regex
worked!! thank you. On 12/6/2010 1:24 PM, Jason Fisher wrote: Ah, yep, forgot to escape the ) when I changed the outer function to REReplace: clean = reReplace(replace(reReplace(x, \s*;\d+-\d+, , all), ((, (, all), \)\s*\), ), all) From: Rick Colmanrcol...@cox.net Sent: Monday, December 06, 2010 3:55 PM To: cf-talkcf-talk@houseoffusion.com Subject: Re: Monster Regex getting malformed regular expression )\s*) thank you ! On 12/6/2010 12:41 PM, Jason Fisher wrote: Just add a space checker inside the '))', then, something like this: clean = reReplace(replace(reReplace(x, \s*;\d+-\d+, , all), ((, (, all), )\s*), ), all) From: Rick Colmanrcol...@cox.net Sent: Monday, December 06, 2010 3:28 PM To: cf-talkcf-talk@houseoffusion.com Subject: Re: Monster Regex this mostly worked, but did not remove one of the last trailing double )) results like: (T ACT) (N AAC) (D GAT) (T ACT) (A GCT) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ) On 12/6/2010 11:26 AM, Jason Fisher wrote: clean = replaceList(reReplace(x, \s*;\d+-\d+, , all), ((,)), (,)) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
splitting a string into multiple sections
If I have a long text string, and want to chop it up into sections and extract each section, like: (1 537 825) first section is position 1-536 second section is position 537 to 824 third section is 825-end can someone suggest a CF approach to do it? have not done it before. tnx if you can help ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to make a CFSELECT Required
I want to force the user to select a country code when submitting a form. The select box looks like: cfselect name=countrycode required=Yes size=5 message=Please select a country code. option value= CFIF get04.CountryCode IS ''selected/cfifPlease select/option option value=AU CFIF get04.CountryCode IS 'AU'selected/cfif Australia/option etc. I do not want them to be able to select the value= option. How to do this? Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to Display lined up Output
I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. I want to display it in lines and columns like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) etc. so users can actually make some sense out of it. I may just put it into a table, or may need to display it within a form in a textarea. Any idea on how to process the text string to get a nice, lined up display? (I am sorry about constantly bothering the list about these kinds of things, but I am not much of a programmer and you guys are really great about helping out.) Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
The display in my original message below is not correct. It looks like one long text string and when displayed, it is a jumble because it just seems to wrap whereever. I want it to look like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. On 11/23/2010 10:18 AM, Rick Colman wrote: I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. I want to display it in lines and columns like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) etc. so users can actually make some sense out of it. I may just put it into a table, or may need to display it within a form in a textarea. Any idea on how to process the text string to get a nice, lined up display? (I am sorry about constantly bothering the list about these kinds of things, but I am not much of a programmer and you guys are really great about helping out.) Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
I may need to copy and paste the text string into another form field. Putting in extra ascii characters (like a line break) may screw things up because of the way the text is later processed. apparently, pre does not work with textarea ... On 11/23/2010 10:29 AM, Justin Scott wrote: It looks like one long text string and when displayed, it is a jumble because it just seems to wrap whereever. You could use the pre HTML tag and ensure that the output has the proper spacing and line breaks (ASCII character 10) in the right places and the browser will output it as it appears in the code in a mono-space font such as Times New Roman. You can use CSS to adjust the output as needed. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
pre by itself works great, but then I get one giant long 500 character text line ... On 11/23/2010 10:29 AM, Ian Skinner wrote: If you don't want to use a table or grid, you may also want to try then under utilizedpre.../pre tags that gives you old fashioned character alignment, over riding the HTML default to ignore spaces and character in output. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
moving data from sub-window into a form
Here is what I am trying to do: a) open a form - several form fields will have an IMPORT button b) IMPORT button opens a sub-window (cfwindow) which runs a query and displays the query results in a table c) select one of the rows in the sub-window with another button. Take the data from the sub-window row and punch it into the correct form field in the main window. close the sub-window d) maybe do this several times for different form fields. e) submit the main form WHEW! I have a) and b) working OK with CFWindow. c) d) and e) are a little mysterious. Can someone point out a resource that might provide some insights? TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: moving data from sub-window into a form
To answer my own question, I did find this link for using Ajax in CF8: http://www.coldfusionjedi.com/index.cfm/2008/12/25/Using-CF8-Ajax-features-to-solve-the-pick-one-of-thousands-issue however, I need to be able to EITHER select from a sub-window OR type in some data directly into the form field. On 11/23/2010 5:41 PM, Rick Colman wrote: Here is what I am trying to do: a) open a form - several form fields will have an IMPORT button b) IMPORT button opens a sub-window (cfwindow) which runs a query and displays the query results in a table c) select one of the rows in the sub-window with another button. Take the data from the sub-window row and punch it into the correct form field in the main window. close the sub-window d) maybe do this several times for different form fields. e) submit the main form WHEW! I have a) and b) working OK with CFWindow. c) d) and e) are a little mysterious. Can someone point out a resource that might provide some insights? TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
REGEX hell
I am trying to replace two trailing parens )) with a single paren. here is a sample string: (K AAA) (N AAC) (E GAA) ) looks like there is a space in between the two )), so I tried: cfset cleandata2 = #REReplaceNoCase( cleandata1,'\)\ \)',')','all')# but this is not working. Any ideas as two what is wrong greatly appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: REGEX hell
This worked!! TNX. On 11/22/2010 6:04 PM, Michael Dinowitz wrote: Are you sure it's a space and not 2 spaces? Or a tab? Try using \s* to indicate that there may be one or more space characters. \)\s*\) cfset cleandata2 = REReplaceNoCase(cleandata1, '\)\s*\)', ')', 'all') On Mon, Nov 22, 2010 at 8:48 PM, Rick Colmanrcol...@cox.net wrote: I am trying to replace two trailing parens )) with a single paren. here is a sample string: (K AAA) (N AAC) (E GAA) ) looks like there is a space in between the two )), so I tried: cfset cleandata2 = #REReplaceNoCase( cleandata1,'\)\ \)',')','all')# but this is not working. Any ideas as two what is wrong greatly appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Homesite on Windows 7
I am having the same problem trying to save as on my web directories on a remote server (CrystalTech). Could it be another dumb Vista/Windows 7 security hack? On 11/16/2010 8:04 AM, Michael Grant wrote: This is how I have mine set up and I still can't create a new file (CTRL+N) and then save it to an FTP folder (CTRL+S). I get an error. I don't get the error saving locally though. On Tue, Nov 16, 2010 at 10:58 AM, Robert Harrison rob...@austin-williams.com wrote: Anyways, did anyone ever solve the problem where HomeSite will not do a save as in Windows 7? Yes, I have it working. Two things to note on set-up to get Homesite to run correctly on Windows 7. Go to the setting and change them to: 1) Run in XP compatability mode, and 2) Run as Administrator (this is only necessary if you are saving files to the WWW root directories). It's a protected directory on Windows 7. Hope that helps... Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be. Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Homesite on Windows 7
I STILL like homesite because it is file based - NOT projects. I don't do projects ... Anyways, did anyone ever solve the problem where HomeSite will not do a save as in Windows 7? I know there is a work around (file - create here - copy paste - save) but it is still a pain. TNX. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Countries Select Box
I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
that worked. write me if you want a copy ... On 11/11/2010 10:15 AM, John M Bliss wrote: Little find-and-replace on this and you should be good to go: http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/ On Thu, Nov 11, 2010 at 12:06 PM, Rick Colmanrcol...@cox.net wrote: I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Best Way to Trap SQL Error
What is the best way to gracefully trap this sort of error ... Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred on line 3. TNX for any suggestions. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best Way to Trap SQL Error
This was a really good idea, and solved the problem. I validated for an integer, and the error went away. TNX. On 11/8/2010 7:49 AM, Michael Grant wrote: The best way would be to validate the data before getting your database involved. On Mon, Nov 8, 2010 at 10:07 AM, Rick Colmanrcol...@cox.net wrote: What is the best way to gracefully trap this sort of error ... Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred on line 3. TNX for any suggestions. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What is wrong with this loop update?
I am trying to update multiple rows by looping through: cfloop query=GetExpOrg (diagnostics) cfoutputrow: #GetExpOrg.currentrow# id: #GetExpOrg.ExpOrg_ID#/cfoutputbr cfquery datasource=#application.datasource# name=UpdateExpOrg update Project_ExpOrg set OrgValue=(select org_value from expressionorganism3 where exporg_id = #GetExpOrg.ExpOrg_ID#) where project_id = #url.ProjectId# /cfquery /cfloop my diagnostics give me: row: 1 id: 2 row: 2 id: 693 so that is ok. but both rows are updated with the last value (693) instead of being individually updated? What's wrong with this? TNX if you can help. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting Record Number within a Looping Query
If I am looping over a query, how do I get the current record number for the loop? e.g. If I am looping for a fixed number of iterations, I can use an index=loopcount and get the current loop number. How do I do this for a query? TNX. rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
looping through an insert statement
Is this the correct syntax for looping through an insert: Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form['ProteinSequence' LoopCount]#', '#form['genename' LoopCount]#', '#form['NoAminoAcids' LoopCount]#' ) I am getting an error when I know the form field name is correct: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence' LoopCount]#', 76 : '#form['genename' LoopCount]#', *77 : '#form['NoAminoAcids' LoopCount]#'* 78 : ) 79 :/cfquery Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: Maybe try this instead: Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
It seems to die on the first loop because nothing gets inserted. Cfdump shows the proper form variables being passed. cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) /cfquery /cfloop On 10/26/2010 10:51 AM, Michael Grant wrote: Could you post your code? If you only loop a single time do you still get the error? On Tue, Oct 26, 2010 at 1:47 PM, Rick Colmanrcol...@cox.net wrote: that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: Maybe try this instead: Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence' LoopCount]#', 76 : '#form['genename' LoopCount]#', *77 : #form['NoAminoAcids' LoopCount]#* 78 : ) 79 :/cfquery VENDORERRORCODE 208 SQLSTATE 42S02 SQLInsert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) DATASOURCEsttr2 code: cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( #thisprojectid#, '#form['ProteinSequence' LoopCount]#', '#form['genename' LoopCount]#', #form['NoAminoAcids' LoopCount]# ) /cfquery /cfloop cfdump: PROTEINSEQUENCE1sdalifsdaifasifsadi PROTEINSEQUENCE2sdafklfsaklfsdklaf On 10/26/2010 11:00 AM, Michael Grant wrote: And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? On Tue, Oct 26, 2010 at 1:58 PM, Rick Colmanrcol...@cox.net wrote: It seems to die on the first loop because nothing gets inserted. Cfdump shows the proper form variables being passed. cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) /cfquery /cfloop On 10/26/2010 10:51 AM, Michael Grant wrote: Could you post your code? If you only loop a single time do you still get the error? On Tue, Oct 26, 2010 at 1:47 PM, Rick Colmanrcol...@cox.net wrote: that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: Maybe try this instead: Values( '#thisprojectid#', '#form[ProteinSequenceLoopCount]#', '#form[genenameLoopCount]#', '#form[NoAminoAcidsLoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
yes, thank you, the form variables are actually there. On 10/26/2010 11:05 AM, Greg Morphis wrote: Those are all coming from a form so have you tried dumping the form scope? Make sure proteinsequence exists in the form On Oct 26, 2010 12:59 PM, Rick Colmanrcol...@cox.net wrote: It seems to die on the first loop because nothing gets inserted. Cfdump shows the proper form variables being passed. cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) /cfquery /cfloop On 10/26/2010 10:51 AM, Michael Grant wrote: Could you post your code? If you only loop a single time do you still get the error? On Tue, Oct 26, 2010 at 1:47 PM, Rick Colmanrcol...@cox.net wrote: that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: Maybe try this instead: Values( '#thisprojectid#', '#form[ProteinSequence LoopCount]#', '#form[genename LoopCount]#', '#form[NoAminoAcids LoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1sdalifsdaifasifsadi equals '#form['ProteinSequence' LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to match up. ***Looping through an insert is certainly a very basic programming operation. Seems like it should not be so painful ... On 10/26/2010 11:15 AM, Bryan Stevenson wrote: Well I know you said in another post that the form elements are all there, but this error disagrees with you ;-) So it's time to check variable spellingpossibly caseother obvious yet silly things ...and of course you want to make sure that the complete set of form elements exist for ALL values of the loop (if any of these come from checkboxes, an unchecked on would cause some chaos for sure (as it would be undefined) HTH Cheers On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence' LoopCount]#', 76 : '#form['genename' LoopCount]#', *77 : #form['NoAminoAcids' LoopCount]#* 78 : ) 79 :/cfquery VENDORERRORCODE208 SQLSTATE 42S02 SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) DATASOURCE sttr2 code: cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( #thisprojectid#, '#form['ProteinSequence' LoopCount]#', '#form['genename' LoopCount]#', #form['NoAminoAcids' LoopCount]# ) /cfquery /cfloop cfdump: PROTEINSEQUENCE1 sdalifsdaifasifsadi PROTEINSEQUENCE2 sdafklfsaklfsdklaf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
here it is: struct COMMONNAME1 Bacillus subtilis EXPORG_ID1 314 FIELDNAMES NUM_GENES,PROJECTNAME,PURPOSE,GENENAME1,PROTEINSEQUENCE1,NOAMINOACIDS1,GENENAME2,PROTEINSEQUENCE2,NOAMINOACIDS2,EXPORG_ID1,COMMONNAME1,NOTES GENENAME1 g1 GENENAME2 g2 NOAMINOACIDS1 15 NOAMINOACIDS2 15 NOTES [empty string] NUM_GENES 2 PROJECTNAME t esting PROTEINSEQUENCE1sdalifsdaifasifsadi PROTEINSEQUENCE2sdafklfsaklfsdklaf PURPOSE testing On 10/26/2010 11:30 AM, Carl Von Stetten wrote: Rick, Can you provide a dump of the FORM scope? Thanks, Carl ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1 sdalifsdaifasifsadi equals '#form['ProteinSequence'LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to match up. ***Looping through an insert is certainly a very basic programming operation. Seems like it should not be so painful ... On 10/26/2010 11:15 AM, Bryan Stevenson wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
sdalifsdaifasifsadi which is what it should be ... On 10/26/2010 11:55 AM, Michael Grant wrote: cfoutput#form['ProteinSequence'1]#/cfoutput ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
yes , yes (arghhh!!) On 10/26/2010 12:35 PM, Bryan Stevenson wrote: ...and you have verified that the table name is in fact ProteinSequence? and that your datasource is pointing at the correct DB? an invalid object error does seem to point to the DB/table On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1 sdalifsdaifasifsadi equals '#form['ProteinSequence'LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to match up. ***Looping through an insert is certainly a very basic programming operation. Seems like it should not be so painful ... Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
It is more than possible, it is likely ... typo ... SORRY On 10/26/2010 12:38 PM, Michael Grant wrote: Is it at all possible you've got the table name incorrect? On Tue, Oct 26, 2010 at 2:24 PM, Rick Colmanrcol...@cox.net wrote: ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1sdalifsdaifasifsadi equals '#form['ProteinSequence'LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to match up. ***Looping through an insert is certainly a very basic programming operation. Seems like it should not be so painful ... On 10/26/2010 11:15 AM, Bryan Stevenson wrote: Well I know you said in another post that the form elements are all there, but this error disagrees with you ;-) So it's time to check variable spellingpossibly caseother obvious yet silly things ...and of course you want to make sure that the complete set of form elements exist for ALL values of the loop (if any of these come from checkboxes, an unchecked on would cause some chaos for sure (as it would be undefined) HTH Cheers On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence'LoopCount]#', 76 : '#form['genename'LoopCount]#', *77 : #form['NoAminoAcids'LoopCount]#* 78 : ) 79 :/cfquery VENDORERRORCODE208 SQLSTATE 42S02 SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) DATASOURCE sttr2 code: cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfquery datasource=#application.datasource# name=AddProject username=#request.dsn_username# password=#request.dsn_password# Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( #thisprojectid#, '#form['ProteinSequence' LoopCount]#', '#form['genename' LoopCount]#', #form['NoAminoAcids' LoopCount]# ) /cfquery /cfloop cfdump: PROTEINSEQUENCE1 sdalifsdaifasifsadi PROTEINSEQUENCE2 sdafklfsaklfsdklaf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: arrays and looping around
so, do I need to declare an array in advance, or is this implicit. so, I guess this does not work either: cfset LegalProteinSequence_#LoopCount# = ... On 9/27/2010 10:10 PM, Ian Skinner wrote: On 9/27/2010 7:37 PM, Michael Grant wrote: #form['ExpOrg_ID_' loopCount]# A.K.A. Array Notation and can be applied to any variable scope, not just the form scope, though that is probably the most common. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
looping syntax inside a function?
Do anyone know what the proper syntax is for adding a loop variable to a variable name, like the following, which is not working: cfloop index = LoopCount from=1 to=#form.num_genes# step=1 cfset LegalProteinSequence_#loopcount# = #REReplaceNoCase(form.ProteinSequence_#loopcount#,'[^()1acdefghiklmnpqrstvwyz ]','','all')# ... etc. Invalid CFML construct found on line 47 at column 29. ColdFusion was looking at the following text: # The CFML compiler was processing: A cfset tag beginning on line 47, column 2. A cfset tag beginning on line 47, column 2. The error occurred in C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm.cfm: line 47 45 : cfoutput 46 : #loopcount# cfabort 47 : cfset LegalProteinSequence_#loopcount# = #REReplaceNoCase(form.ProteinSequence_loopcount,'[^()1acdefghiklmnpqrstvwyz ]','','all')# 48 : 49 : ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
arrays and looping around
I can't seem to get this working, and it should not be that tough? Here what I am trying to do: * get the number of form variables coming in * loop through the number of variables coming in, and as each form variable comes in, do a query * store the results of the query in an another variable I can't seem to figure out how to attach a subscript to a form variable name. Here is what is the kind of thing that is NOT working: cfloop index = LoopCount from=1 to=#form.num_vars# step=1 cfquery name=GetOrg_#LoopCount# ... select * from table where ID = #form.ExpOrg_ID_#LoopCount## /cfquery i have tried several variations, and they generate interesting errors. if someone would be so kind as to map this out for me, I can get over the hump. TNX if you can help. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting a trial version to standard
I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to do it, who does not want me to get their credit-card info (bye-bye Las Vegas). What is the easiest way to buy and install the license? Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting a trial version to standard
easiest way to buy the license key ...??? On 6/30/2010 1:18 PM, Dorioo wrote: I think you just enter the license key in the administrator. And voila, trial becomes standard. - Gabriel On Wed, Jun 30, 2010 at 4:16 PM, Rick Colmanrcol...@cox.net wrote: I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to do it, who does not want me to get their credit-card info (bye-bye Las Vegas). What is the easiest way to buy and install the license? Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting a trial version to standard
This seems to be another example of brain-dead design. Why doesn't the trial version have a BIG button that says buy a license right up front on the administrator page. No one ever got rich making it difficult for a customer to make a purchase... On 6/30/2010 1:18 PM, Dorioo wrote: I think you just enter the license key in the administrator. And voila, trial becomes standard. - Gabriel On Wed, Jun 30, 2010 at 4:16 PM, Rick Colmanrcol...@cox.net wrote: I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to do it, who does not want me to get their credit-card info (bye-bye Las Vegas). What is the easiest way to buy and install the license? Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problems with CF9 Web Server Install
Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. What gives? Please advise. TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
Actually, I was using the wrong login, which was causing the problem. However, here is another one. Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... rick. On 6/8/2010 3:43 PM, Dave Watts wrote: Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. Is the machine running a 64-bit version of Windows? If so, are you using a 64-bit CF installer? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
It was a compatibility layer, and the video was very helpful. Why can't adobe do something like that ??? too simple, I guess. On 6/8/2010 4:48 PM, Dave Watts wrote: Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... Did you install the IIS 6 compatibility layer? http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18a15-7ffb.html http://www.codecurry.com/2009/09/installing-coldfusion-on-iis-7.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Builder Install Problem
The trial version of CF Builder thinks I already have Eclipse installed, and is asking for the relevant directory. I can't recall such an install, but who knows. Any ideas appreciated. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to protect PDF documents from direct access
I am on a shared host, so moving outside the web directories is not practical. On 5/3/2010 4:09 PM, Dave Watts wrote: Is there some easy way to protect PDF (and perhaps other kinds of documents) from sideaways access? In other words, after building login pages, protecting html/cfm pages from direct access, etc.; someone can still directly access a document with a direct URL, like www.xxx.com/.pdf You can remove them from web-accessible directories and (a) serve them with CFCONTENT, or (b) create a temporary symlink of some sort using CFEXECUTE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:11 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to display LARGE amounts of Data in a Timely Fashion
I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 spreadsheet-style grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
