Re: CF and Spry
Thanks for the reply Dan, but if you notice in my call to the CFC when I create
the DS, I am using returnFormat=json and I'm getting the data displayed in
Region 1.
var mydata = new
Spry.Data.JSONDataSet(../product.cfc?method=getProductsreturnFormat=jsonqueryFormat=column,
{path:DATA, pathIsObjectOfArrays:true});
There is a problem with Region 2. On first loading the page, Region 2 shows
the data for the current row of the last record in the DS. When I click on a
row (either column), Region 2 does not update (it goes blank removing the
initial data from the last record of initial load).
I am using Firebug and see that there aren't any errors in the request and the
dataset appears to be returned without issues.
Issac
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295945
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF and Spry
Can someone see why the detailregion is not updating when using
Spry.Data.JSONDataSet? If I use Spry.Data.XMLDataSet, the detailregion updates
fine when I click a row. I am getting the resultset fine. Here is my code.
index.html:
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
head
titleSpry Dynamic Example 4/title
script type=text/javascript
src=/CFIDE/scripts/ajax/spry/includes/xpath.js/script
script type=text/javascript
src=/CFIDE/scripts/ajax/spry/includes/SpryData.js/script
script type=text/javascript
src=/CFIDE/scripts/ajax/spry/includes/SpryJSONDataSet.js/script
script type=text/javascript
var mydata = new
Spry.Data.JSONDataSet(product.cfc?method=getProductsreturnFormat=jsonqueryFormat=column,{path:DATA,pathIsObjectOfArrays:true});
/script
/head
body
style
..hot {
background-color: yellow;
}
..red {
background-color: red;
}
/style
div spry:region=mydata
p
table width=100% border=1
tr
th onClick=mydata.sort('prod_name','toggle'); style=cursor:
pointer;Name/th
th onClick=mydata.sort('cat_name','toggle'); style=cursor:
pointer;Category/th
/tr
tr spry:repeat=mydata spry:setrow=mydata spry:select=red
spry:hover=hot
td style=cursor: pointer;{PROD_NAME}/td
td style=cursor: pointer;{CAT_NAME}/td
/tr
/table
/p
/div
div spry:detailregion=mydata
h2{PROD_NAME}/h2
/div
/body
/html
products.cfc:
cfcomponent output=false
cffunction name=getProducts returnType=query access=remote
output=false
cfset var q =
cfquery name=q datasource=spry
select *
fromproducts_view
order by prod_name asc
/cfquery
cfreturn q
/cffunction
/cfcomponent
Thanks,
Issac
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295939
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Google Maps Mashup Question
I have a Google Map that has several locations. What is the best way to have a list of the locations that are linked on the side of the map within an iframe (similar to the results of a map search)? Thanks, Issac ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Javascript Problem
Sorry for the OT, but thought someone on here might have a quick
solution. I need to change this form to have 10 input rows. How would
I modify the JS below to handle the 10 rows of selects and linked text
input?
HTML
HEAD
TITLEParallel Array Lookup/TITLE
SCRIPT LANGUAGE=JavaScript
// the data
var UsageCsaId = new Array(ABERDEEN,AGOURA,AGUADILLA,AKRON);
var originalCompany = new Array(6410,8728,1260,6613);
// do the lookup into parallel arrays
function getData(form) {
var i = form.UsageCsaId.selectedIndex
form.OriginalCompanyCode.value = originalCompany[i]
}
/SCRIPT
/HEAD
BODY onLoad=getData(document.frmMaintenance)
H1Parallel Array Lookup/H1
HR
FORM NAME=frmMaintenance
SELECT NAME=UsageCsaId onChange=getData(this.form)
OPTIONABERDEEN
OPTIONAGOURA
OPTIONAGUADILLA
OPTIONAKRON
/SELECT
INPUT TYPE=text NAME=OriginalCompanyCode SIZE=4 readonly
/BODY
/HTML
Thanks,
Issac
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185076
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How to validate email address before sending mail
Does anyone know a good way to validate an email address prior to sending out the email?The scenario is that I have a database of customers and want to send an email, but want to capture the email addresses that will bounce prior to sending the email. TIA, Issac [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to validate email address before sending mail
Thanks, I already do this prior to saving the email in the db.I want
to test the mailbox to make sure I get a valid response to avoid bounced
messages prior to sending the actual email.
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 2:31 PM
To: CF-Talk
Subject: Re: How to validate email address before sending mail
Yes use the following
script
function checkForm(theForm) {
var emailRegex=/^\w+([\.-]?\w+)[EMAIL PROTECTED]([\.-]?\w+)*(\.\w{2,})+$/;
if(document.forms[theForm.name].contactEmail.value.length==0||emailRegex
.test(document.forms[theForm.name].contactEmail.value)==false)
{
alert('Please enter the email address!');
return false;
} else {
return true;
}
}
/script
form name=myForm action="" method=post
checkForm(this)
...
/form
Issac Rosa wrote:
Does anyone know a good way to validate an email address prior to
sending out the email?The scenario is that I have a database of
customers and want to send an email, but want to capture the email
addresses that will bounce prior to sending the email.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Recipe Application
Does anyone know of a good recipe application?No specific requirements, so open to all suggestions. TIA, Issac [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Flash Based Ticker/News App
Does anyone know of a Flash Based ticker/news application (free or $, open source) that could display content based on user login?Not so much for stocks, but user supplied content maintained through a backend web application. Any information or links would be greatly appreciated. Issac [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Storing Credit Card Info
My client has a need to store credit card. What's the best, cost effective, most secure way of doing this? Is it just better to capture the information in the db and then download to a local db, and keep off the server? I'm curious to know what others are doing in this situation. Currently, the application and db (MySQL) are on a shared server. Thanks, Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Parsing a large text file
What would be the best way to parse a large text file (5mb)? Actually,
the text file is 1 large string. I need to create either a file with
each new record on a line or enter each new record into a table (new
record = every 60 chars).
Here's what I've tried, but there must be a more efficient way.
cffile action=Read
file=C:\temp\MATCHMST\MATCHMST.txt
variable=message
cfset recordLength = 60
cfset messageLen = Len(message)
cfset messageRecords = messageLen/recordLength
cfloop index=loopCount from=1 to=#messageRecords#
cfset new_record = Left(message, recordLength)
cfoutput#new_record#br/cfoutput
cfset message = RemoveChars(message, 1, recordLength)
/cfloop
cfoutput
File is done!
/cfoutput
OR
cffile action=append
file=C:\temp\MATCHMST\NEW_MATCHMST.txt
output=#new_record#
addnewline=yes
OR
cfquery name=insertRecord datasource=db1
Insert into matchmst (matchmst)
Values ('#new_record#')
/cfquery
Thanks,
Issac
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parsing a large text file
Sorry, CF 4.5/5 and possibly MX. Also, the DB would be SQL Server
7/2000 or Oracle 8i or 9i.
Issac
-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 7:17 PM
To: CF-Talk
Subject: Re: Parsing a large text file
Which version of CF?
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, June 10, 2003, 7:13:11 PM, you wrote:
IR What would be the best way to parse a large text file (5mb)?
Actually,
IR the text file is 1 large string. I need to create either a file
with
IR each new record on a line or enter each new record into a table (new
IR record = every 60 chars).
IR Here's what I've tried, but there must be a more efficient way.
IR cffile action=Read
IR file=C:\temp\MATCHMST\MATCHMST.txt
IR variable=message
IR cfset recordLength = 60
IR cfset messageLen = Len(message)
IR cfset messageRecords = messageLen/recordLength
IR cfloop index=loopCount from=1 to=#messageRecords#
IR cfset new_record = Left(message, recordLength)
IR cfoutput#new_record#br/cfoutput
IR cfset message = RemoveChars(message, 1, recordLength)
IR /cfloop
IR cfoutput
IR File is done!
IR /cfoutput
IR OR
IR cffile action=append
IR file=C:\temp\MATCHMST\NEW_MATCHMST.txt
IR output=#new_record#
IR addnewline=yes
IR OR
IR cfquery name=insertRecord datasource=db1
IR Insert into matchmst (matchmst)
IR Values ('#new_record#')
IR /cfquery
IR Thanks,
IR Issac
IR
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parsing a large text file
Jon, Thanks for the responses. Sorry to confuse the issue. I was just listing the available options that I have, so any combination of the below versions would work. The solution does not need to work on all versions. I think I will look into DTS and see what I can come up with. Thanks, Issac -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 8:11 PM To: CF-Talk Subject: Re: Parsing a large text file The variety of databases and cf versions makes it a bit more challenging, but this cfx tag works well, and it's relatively quick at reading the text file. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn13 1viewName=ColdFusion%20ExtensionextID=1000558 However you would still need to do a zillion inserts so I it's still not the most efficient way. It may gain you enough to be comfortable though. With SQL Server you can run through the import data wizard and save the import as a DTS package, then run the DTS from a stored proc call, or via command line with cfexecute and dtsrun. The necessity for Oracle compatibility may rule this out though. I'm sure Oracle has similar bulk import capabilities, if your up to writing two different import procedures... -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: active edit alternaitves
There are a few listed here - http://www.flashvoodoo.com/weblog.php?id=P28 Issac -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 11:48 AM To: CF-Talk Subject: Re: active edit alternaitves Figleaf showed one right when MX came out...I have no idea where it might be these days though. -- jon mailto:[EMAIL PROTECTED] Friday, June 6, 2003, 11:29:30 AM, you wrote: C oi joe!! C i've seen a flash one floating around.. can't remember where from though... C here's another wizzywig: http://www.interactivetools.com/products/htmlarea/ C C Friday, June 6, 2003, 11:17:56 AM, you wrote: jh Thanks for the realObjects suggestion. That's the only one i've seen so far that's cross-platform. activEdit gives their excuse about the Mac not supporting LiveConnect while realObjects finds a jh work around for the issue. So who would you trust for maintaing excellent future development? jh But i still don't understand why there isn't a basic Flash-based WYSIWYG editor out there, which theoretically could overcome the browser and platform compatibility issues much easier. If anyone jh knows of one, please speak up. jh On a related note, does anyone use activSpell, outside of activEdit? jh C ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic anchors on CF Page
Try the anchor like this: a href=###GetKey# Issac Rosa - Original Message - From: Clark, Aimee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 29, 2003 8:28 PM Subject: RE: Dynamic anchors on CF Page Well it doesn't appear to actually jump down to a specific heading. For instance, lets say I hardcoded 3 headings to be in hyperlink #1a, #2b, and #3a, then whenever I click on the heading that has the anchor coded as #3a, it would just down right to the title and content for the 3rd heading. Well, presently it acts like it's jumping down, but it doesn't go to the specified heading. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 7:12 PM To: CF-Talk Subject: Re: Dynamic anchors on CF Page Apart from that you've missed the hashes (#), what's wrong with what you have? a name=#GetKey# Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Clark, Aimee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 12:38 PM Subject: Dynamic anchors on CF Page I have a page in which headings go across the top like (newpaper headings) that I want the user to be able to click the heading to jump down to the article. All headings and articles are on the same page. So I need to be able to create dynamic anchors. Is this possible in CF? Here's a snippet of code I have: cfquery datasource=FirmDaily name=GetBookmarks Select DailyNewsKey, Title From DailyNews Where convert(varchar, PublishDte, 101) = convert(varchar, GETDATE(), 101) AND convert(varchar, EndPublishDte, 101) = convert(varchar, GETDATE(), 101) /cfquery cfquery datasource=FirmDaily name=GetContent Select DailyNewsKey, Title, Body, Sig From DailyNews Where convert(varchar, PublishDte, 101) = convert(varchar, GETDATE(), 101) AND convert(varchar, EndPublishDte, 101) = convert(varchar, GETDATE(), 101) /cfquery cfset GetKey = #GetBookmarks.DailynewsKey# body link=CC alink=CC vlink=ac9d86 table width=100% TR td width=100% height=18 align=left valign=toph2What's Up Today/h2/td /TR tr td width=100% height=24 align=left valign=bottomh3Table of Contents/h3/td /tr tr td width=100% height=9 align=center valign=top cfoutput query=GetBookmarks font face=Trebuchet MS size=1nbsp;nbsp;a href=##GetKey##title#/anbsp;nbsp;/cfoutput /td/tr tr td width=100% height=3 align=center valign=tophr width=65% size=1 color=353535/FONT/td /tr cfoutput query=GetContent tr td height=9 align=center valign=topfont face=Trebuchet MS size=2 color=CCa name=GetKey#Title#/a/font/td /tr tr td height=9 align=center valign=topfont face=Trebuchet MS size=2#Body#/font/td /tr tr td height=9 align=center valign=topfont face=Trebuchet MS size=2#Sig#/font/td /tr tr td width=100% height=3 valign=tophr width=65% size=1 color=353535/td /tr /cfoutput /table /body /html Thank you, Aimee Clark Web Developer Stinson Morrison Hecker 816.691.3461 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WOT-Website Marketing
Does anyone know of some good resources that discuss website marketing and ranking and how to improve them through search engines? Any good programs worth looking at? Thanks, Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: input radio buttons
The name of the radio button should be the same. Issac - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:23 PM Subject: input radio buttons HI, I have the following radio buttons: input type=radio name=Yesnbsp;Yesbr input type=radio name=Nonbsp;No Currently I can click on both the yes and no and they both get selected. I don't want that to happen. The user should only be able to select one. How can I do this? I also have another list of radio buttons with 5 items but only want to allow the user to select one and NOT multiples. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Changing from HTTPS to HTTP for normal pages
What's the best way to setup the page links so that when you go to a secure page via https and then go to a non-secure page the links use http? Do I need to hard code the full url? Thanks, Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Records from Oracle SP
I understand that Oracle SPs only return 1 record. Has anyone found a workaround for this and used the SPs in ColdFusion? I found the following response from an Oracle Forum discussing how to get multiple rows from a stored procedure. Does anyone know if this would work and can this be called from CF or are there any other solutions? http://www.oracle.com/forums/message.jsp?id=483524 This is much more difficult than it ought to be, but once you get the kinks worked out, it is pretty sweet. Here's what you do: 1. Create a package and package body that will contain your stored procedure(s). 2. In the package, add this line: TYPE row_cursor is REF CURSOR; Your procedures will return row_cursors. Actually row_cursor is a type you are defining. You could use another name if you wanted to. 3. Create a FUNCTION in the package and package body that returns row_cursor: (In package) FUNCTION MY_STORED_PROCEDURE(nParam IN NUMBER) return row_cursor; (in package body) FUNCTION MY_STORED_PROCEDURE(nParam IN NUMBER) return row_cursor IS c_return row_cursor; BEGIN OPEN c_return FOR SELECT * from whatever where ID = nParam; return c_return; END; Thanks, Issac __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
