sartis
Hello, I have a question about CFspreadsheet I'm reading a spreadsheet and inserting the data into a SQL server DBeverything works fine unless 1 of my column in the spreadsheet is blank. I'm getting the following error: Element PHONE is undefined in EXCELQUERYBYNAME. I tried the put a cfif isdefined to see if that would solve it but no lucksame error message. How can I handle this issue? My cfquery is below: INSERT into contactrecord ( contact_date, fname, lname, address, city, state, zip, county, phone, cell, fax, title, organization, email, general_comments, fname2, lname2, mailing, input_by, input_date, input_time, input_by_id, country, sh_rating ) Values( '#Trim(excelQueryByName.contact_date)#', '#Trim(excelQueryByName.fname)#', '#Trim(excelQueryByName.lname)#', '#Trim(excelQueryByName.address)#', 'Trim(excelQueryByName.city)#', '#Trim(excelQueryByName.state)#', '#Trim(excelQueryByName.zip)#', '#Trim(excelQueryByName.county)#', '#Trim(excelQueryByName.phone)#', '#Trim(excelQueryByName.cell)#', '#Trim(excelQueryByName.fax)#', '#Trim(excelQueryByName.title)#', '#Trim(excelQueryByName.organization)#', '#Trim(excelQueryByName.email)#', '#Trim(excelQueryByName.general_comments)#', '#Trim(excelQueryByName.fname2)#', '#Trim(excelQueryByName.lname2)#', '#Trim(excelQueryByName.mailing)#', '#Trim(excelQueryByName.input_by)#', '#Trim(excelQueryByName.input_date)#', '#Trim(excelQueryByName.input_time)#', '#Trim(excelQueryByName.input_by_id)#', '#Trim(excelQueryByName.country)#', '#Trim(excelQueryByName.sh_rating)#' ) Thanks in Advance. ~| 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:352117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sartis
http://cutterscrossing.com/index.cfm/jqgrid Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2012 10:01 AM, steve artis wrote: > hello, I'm wondering if someone can help me or point me to an example of the > following: > > I have an application that has a search page. If a user does a search, it can > kickback any number of records. I want to be able to display 10 records at a > time and then display a "show more" button and it would load 10 more > records(showing the 1-10 too), and the user could click the show more button > until the end of the recordset...etc. I do not want a page refresh. What is > the best way to accomplish this? Ajax? A cached coldfusion query with hidden > divs?? > > I'm using CF 9, javascript and sql server. > > Also, if you view the homepage of linkedin, there is a perfect example of > what I'm describing there. > > Thanks. > > Steve > > ~| 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:350197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sartis
1000 ways to do this. For grid-style data, I've enjoyed http://tablesorter.com/docs/example-pager.html On Fri, Mar 2, 2012 at 9:01 AM, steve artis wrote: > > hello, I'm wondering if someone can help me or point me to an example of > the following: > > I have an application that has a search page. If a user does a search, it > can kickback any number of records. I want to be able to display 10 records > at a time and then display a "show more" button and it would load 10 more > records(showing the 1-10 too), and the user could click the show more > button until the end of the recordset...etc. I do not want a page refresh. > What is the best way to accomplish this? Ajax? A cached coldfusion query > with hidden divs?? > > I'm using CF 9, javascript and sql server. > > Also, if you view the homepage of linkedin, there is a perfect example of > what I'm describing there. > > Thanks. > > Steve > > ~| 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:350195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sartis
The easiest and least obtrusive way i can think of would be to build the pagination into the page, as if you wanted it to function like it was paging without ajax. Then, use a jquery load call for the link, here is the doc for jquery load: http://api.jquery.com/load/ The key javascript call looks like this: $('#result').load('page.cfm?page=2 #result'); This basically says go get page.cfm and find the container with ID result and load it into the div with ID result on this page. Then result needs to be the wrapper around the table / content you are paginating. On Fri, Mar 2, 2012 at 8:01 AM, steve artis wrote: > > hello, I'm wondering if someone can help me or point me to an example of > the following: > > I have an application that has a search page. If a user does a search, it > can kickback any number of records. I want to be able to display 10 records > at a time and then display a "show more" button and it would load 10 more > records(showing the 1-10 too), and the user could click the show more > button until the end of the recordset...etc. I do not want a page refresh. > What is the best way to accomplish this? Ajax? A cached coldfusion query > with hidden divs?? > > I'm using CF 9, javascript and sql server. > > Also, if you view the homepage of linkedin, there is a perfect example of > what I'm describing there. > > Thanks. > > Steve > > ~| 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:350193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sartis
hello, I'm wondering if someone can help me or point me to an example of the following: I have an application that has a search page. If a user does a search, it can kickback any number of records. I want to be able to display 10 records at a time and then display a "show more" button and it would load 10 more records(showing the 1-10 too), and the user could click the show more button until the end of the recordset...etc. I do not want a page refresh. What is the best way to accomplish this? Ajax? A cached coldfusion query with hidden divs?? I'm using CF 9, javascript and sql server. Also, if you view the homepage of linkedin, there is a perfect example of what I'm describing there. Thanks. Steve ~| 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:350192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm