HELP!!! REgEx, XML and a Qutation Mark
I am trying to export our product list to an XML feed. It works pretty well except that one of the products, has a quotation mark in it that nothing seems to like. I believe it is a cut and past issue and that the quotation mark is a special character. It is this one right here â No matter what I do I cannot get rid of this thing. And if I do search in the resulting file, I cannot search for a " because it is not the same. I am doing this, and that is not getting rid of it... â","","ALL") /> and I am wrapping the tag like this... What else can I do, besides go into the database and delete it. I would like a code solution. 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:338778 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 Install Problems
we recently purchased and installed CF9 on a windows 2003 server running CF8. The install when fine until the it tried to copy over our CF8 settings. At that point we received a big CFDUMP error message and cold not move forward. Tried an uninstall/reinstall of CF9 with same results. Found a solution on FaceBook of all places to get us past the error and into the administrator so that we could get our site back online. Now what I am wondering is, Do I uninstall CF8. It is still running in the services, so I disabled that. Would it be best to uninstall it through the Windows Software Uninstaller? - I dont know if that will make things better or worse. Any suggestions would be greatly appreciated. ~| 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:329371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFAjax not playing well with javaScript.
Here is the code.
I am still trying to figure out firebug.
I added the ajaxonload - and now it will not load the first time but does on
all clicks after that.
Before it would load the first time but not afterwards.
<--- a query is here for security check --->
init = function() {
flashembed("videowindow",
{src:'../flowplayer/FlowPlayerLight.swf',width: 512, height: 384},
{config: {
streamingServerURL: 'rtmp://foo.com/simplevideostreaming',
playList: [ { url: '#video# ', start:
#start# , end: #end# } ],
autoPlay: true,
Loop: false,
usePlayOverlay: false,
initialScale: 'scale',
protected: true,
useNativeFullScreen: true,
autoRewind: true,
menuItems: [false, false, false, false, false, false],
timeDisplayFontColor: 0xE56717,
controlBarBackgroundColor: 0
}}
);
}
~|
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:325508
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFAjax not playing well with javaScript.
I am not real good with JavaScript so that may be my problem, but I have written a page that has two separate cfdiv's with bind. One holds a video player and the other is the navigation. When you click through the navigation you have to go three levels before you select a video. When you select a video, it starts to play in the video cfdiv (the first time). The second time you press it you get a javascript error. It is like it cannot re-initialize the javascript. >From the main page I have this... When you drill through the MediCenterNav.cfm page you eventually get to a link that looks like this... The first time you click it the video starts playing in the other CFDIV as it should. But if you click on another video in the Nav panel you get a "Error processing JavaScript in markup for element MediaPlayer" Any suggestions would be greatly appreciated. ~| 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:325506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfajax with and javascript - not playing well together
I am not real good with JavaScript so that may be my problem, but I have written a page that has two seperate cfdiv's with bind. One holds a video player and the other is the navigation. When you click through the navigation you have to go three levels before you select a video. When you select a video, it starts to play in the video cfdiv (the first time). The second time you press it you get a javascript error. It is like it cannot re-initialize the javascript. >From the main page I have this... When you drill through the MediCenterNav.cfm page you eventually get to a link that looks like this... The first time you click it the video starts playing in the other CFDIV as it should. But if you click on another video in the Nav panel you get a "Error processing JavaScript in markup for element MediaPlayer" Any suggestions would be greatly appreciated. ~| 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:325505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CSV Import - Update with Commas in the Content
I am trying to figure out how to update a sql table using a CSV file that has commas in the data fields. The long and Short of it, is that we have a SEO company rewriting our keywords, meta descriptions and titles for our product database. We were able to build a simple CSV export so that they could add the new info. Now we need a way to import it back into the systm and update all of the records based on the productID, wich is in the csv file. The developer we are using says it can be done, but we cannot have commas in any of the fields. We can wrap the columns in double quotes on an export, cant we do this on the import? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Is it possible to trigger a link on a web page and trigger a download?
We use a real simple piece of code to trigger a file download. We save this in a page called download.cfm Then we call it with a simple href #foo# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Any Good Documentation on Verity Spyder CF8
Problem getting Verity Spider to work for CF8 Is there any good documentation or a .cfm or .cfc that has been written already. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Verity problems
I have three separate indexes on my server each indexing a different table in our database. For some reason the indexes keep getting messed up on a near nightly basis. One index just refuses to work giving back an error There was a problem executing the cfSearch tag with the following collections. Collection (status code): products (-1706) another one shows 48 items in the table which is what is there but when you search it show that it searched 708 items which is the amount in another table. It does also retrieve the data that it is supposed to, but with allot of bad links as well. IS there a cache issue with verity and CF8 or any known bugs. I did not have this problem until we had more than one index. Thanks for any help you can give me. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
2 Related CFDIV's
I have been at this for a while, I am trying to create 2 cfdivs. One shows a cart total and total items and the other has a link labled add to cart. Pressing the add to cart needs to activate the first div so that it ads the products and increments the numbers. Then the second div with the link needs to change or blank out. I can get the first to change no problem, but can not get the message in the link div to change. Here is my code... any help would be greatly appreciated. THIS IS THE DIV WITH THE LINK AND MESSAGE ADD TO CART THIS IS THE ONE THAT ADDS THE PRODUCT AND INCREMENTS THE CART NUMBERS ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFGRID in CF8 cannot get links with dynamic variable to work
I am trying to us a CFgrid, Format HTML using a CFC and Bind. The grid renders fine, but I want to include a few columns that either display a small image or a static X. Each of these columns should point to a specific url and pass the parameter. First off I cannot figure out for the life of me how to pull in a simple variable to pass in the href portion fo teh tag. Everytime I run this I get Variable PRODUCTID is undefined. I have tried placeing everything I can think of in front of the productid viarable but it alwasy tells me that it is undefined. ~| 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:295527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFGRID for CF8 with date mask not working?
Help... I have tried and tried to get this date mask to work with no luck what so ever. The grid works with a couple of quirks but the dates always show as 2007-05-01 00:00:00 What am I doing wrong here. Also can not get the page part to show-up. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dedicated Web Hosting - Looking For Good Service
Currently we are with CrystalTech.com web hosting. We have had a dedicated server with them since 2002 and have a number of shared hosting sites as well. The quality of our dedicated service has been dropping lately and we are wondering if there are any better services out there. The key for us is the 24/7 phone support. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFGRID Format Flash, Adding a new row with a hidden record.
Basically I am trying to figure out how you can have default data populate one of the columns when you add a new row to a CFGRID Flash format. -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 6:00 AM To: cf-talk Subject: ColdFusion Talk (CF-Talk): Digest every 8 hours ColdFusion Talk (CF-Talk) 15-Jun-07 Issue:546 In this issue: [Macromedia][Oracle JDBC Driver]Object has been closed. [Macromedia][Oracle JDBC Driver]Object has been closed. [Macromedia][Oracle JDBC Driver]Object has been closed. Ajax - beating head on wall... CF var in javascript CF var in javascript CF var in javascript CF var in javascript CF var in javascript CFC Typeof() CFC Typeof() CFC Typeof() CFCDOC Location? CFCDOC Location? CFGRID Format Flash, Adding a new row with a hidden record. CFGRID Format Flash, Adding a new row with a hidden record. cfmail error - anyone know what to do about this one? CFPRESENTATION color and mouse problems - Scorpio - General Discussions - Scorpio Discussions ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 ColdFusion MX 7.0.2 and MySQL 4.1.12 Dynamically populate a select box within a PDF form. Error converting data type varchar to int. Error Executing Database Query Error Executing Database Query Error Executing Database Query Error Executing Database Query Error Executing Database Query Invalid Parser Construct Is <noscript> the answer?? Memory leak in CF7-based app, still trying to track it down Memory leak in CF7-based app, still trying to track it down Memory leak in CF7-based app, still trying to track it down Memory leak in CF7-based app, still trying to track it down Memory leak in CF7-based app, still trying to track it down Memory leak in CF7-based app, still trying to track it down OO style - dynamic set & get methods OO style - dynamic set & get methods OO style - dynamic set & get methods Securing Datasources setting xml encoding setting xml encoding setting xml encoding setting xml encoding setting xml encoding Spry AutoSuggest Issue Translation WebService Updated Broadband Stats Updated Broadband Stats Updated Broadband Stats Updated Broadband Stats Updated Broadband Stats Updated Broadband Stats Using sessions with Flash Remoting Using sessions with Flash Remoting Using sessions with Flash Remoting Using sessions with Flash Remoting Using sessions with Flash Remoting ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFGRID Format Flash, Adding a new row with a hidden record.
Hello, I am new to the CFGRID and Flash forms. I have created a grid that the following columns from a table... mfg, itemid, onhand, avgcost, category, loc, entry(primary key) The loc and entry column should be hidden. Update and delete functions work fine. When adding the loc (location) field needs to automatically prefill with a predefined variable such as AZ. Basically when you add the new row the loc should have AZ as the default value. Is this possible. This is what I am using Any help would be appreciated. Thanks ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SLQ Injection on CF7 Site
What does this do and how do I stop it? and 1=convert(int,system_user)--sp_password I recently received an email from some one showing me my ID and Password of a site I work. They also stated that they could get our customer information. Very Very Bad. Thanks -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, June 10, 2007 6:00 AM To: cf-talk Subject: ColdFusion Talk (CF-Talk): Digest every 8 hours ColdFusion Talk (CF-Talk) 10-Jun-07 Issue:536 In this issue: AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries AJAX Libraries Finding current queries Query suppressed in flash form Simultaneous Requests/CF vs ASP.NET for Flash Remoting Simultaneous Requests/CF vs ASP.NET for Flash Remoting Simultaneous Requests/CF vs ASP.NET for Flash Remoting Simultaneous Requests/CF vs ASP.NET for Flash Remoting Simultaneous Requests/CF vs ASP.NET for Flash Remoting Subversion and Dreamweaver 8 Subversion and Dreamweaver 8 Subversion and Dreamweaver 8 What's wrong with these related selects? What's wrong with these related selects? What's wrong with these related selects? What's wrong with these related selects? What's wrong with these related selects? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Having problem with query and multiple tables.
I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using SELECT p.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM Products p, Product_Hits h, ContentPages s, ContentPages c Where p.Status = 1 AND p.product_id = h.product_id AND p.content_id = s.content_id AND s.parent = c.content_id ORDER BY #sortorder# All the data is returned fine accept that The HITS and CLICKS if there is not HIT available for a particular product in the PRODUCT_HITS table, then that product does not show up. I could break this into tow separate queries except that I need to be able to dynamically change the sort order. Basically I need to list all of the products even if there has been not HIT record created for it. Is this possible using a single query? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241150 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SLQ-Multile updates and inserts from single form
Long story short, I have a page that lists all of the products in our database. We are trying to add contract pricing. Basically each product in the system may have a different price for each contract. I have built a form that lists all of the products in the database (around 700) with a blank form field (contractprice) next to each row. in the row I also include the (product_id, hidden). I would like to be able to add pricing the rows and press a single submit button. What i am not sure about is how to loop through the database to perform, INSERT, UPDATE and/or DELETE base on what the form passes. When the data is passed their are 4 different scenerios (if) that would take place. I am thinking that a call would need to be made to the database for each row passed. 1. if the form.product_id does not and the form.contractprice IS NULL, do nothing. 2. if the form.product_id does not exists and the form.contractprice IS NOT NULL, insert the row. 3. If form.product_id exists but form.contractprice IS NULL, delete row 4. if form.product_id exists and form.contractprice NOT NULL, update row. My two major questions is one how would you right the loop to do this and two, is there a better way to do this. I do not have access to stored proc on the SQL server. Thanks for the assist... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232033 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
Re: Flash CFForm Style
I have been working on a form with custom colors.. here is the code I found and
am using. There are alot of global styles listed below. For background color
you only need one, but I figured I will give you all that I have and let you
pick out what you need.
function formOnLoad()
{
// Do anything that you need to do in the onload Event
// call the function that is in charge of applying the
styles
applyStyles();
}
function applyStyles()
{
_global.styles.CheckBox.setStyle("fillColors",
[0xa7a7a7, 0xff]);
_global.styles.RadioButton.setStyle("fillColors",
[0x006699, 0xff]);
_global.styles.Form.setStyle("color", 0x00);
_global.styles.Button.setStyle("borderThickness", 1);
_global.styles.Panel.setStyle("backgroundColor",
0xE5F0F9);
_global.styles.Panel.setStyle("color", 0xff);
_global.styles.Panel.setStyle("headerColors",
[0x277DC6,0x50ABF7]);
_global.styles.HBox.setStyle("backgroundColor",
0x757575);
_global.styles.HBox.setStyle("marginTop", 10);
_global.styles.HBox.setStyle("marginBottom", 10);
_global.styles.HBox.setStyle("marginLeft", 10);
_global.styles.Accordion.setStyle("fillColors",
[0x547000,0x739802]);
_global.styles.Accordion.setStyle("selectedFillColors",
[0x84af00,0xa3d800]);
_global.styles.Accordion.setStyle("themeColor",
0x0066cc);
_global.styles.Accordion.setStyle("color", 0x0ff);
_global.styles.TextArea.setStyle("fontSize",14);
_global.styles.TextInput.setStyle("fontSize",9);
_global.styles.DataGrid.setStyle("rollOverColor",
0xf5ffd7);
_global.styles.DataGrid.setStyle("selectionColor",
0x84af00);
_global.styles.DataGrid.setStyle("headerColors",
[0xa6a6a6,0xe2e2e2]);
}
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231304
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
FlashForms
I am currently attempting to work with flash forms and I am a first timer (as of today). I am using an according style form. The first page has a data grid pulled from my database. The second page shows the data of the selected name The third page will provide a form to create a new account. My first question is, when you click on a name in the data grid, is there anyway to make it automatically open the second accordion page to show the account details. Currently I have the grid working and the detail page working, but don't know how, if there is a way to make it open that piece automatically. My second question is, how in the heck do you make a row in the datagrid of a flash form open a new cfml page an pass an id from the selected row? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230942 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF7 Flash Forms
I am currently attempting to work with flash forms and I am a first timer (as of today). I am using an according style form. The first page has a data grid pulled from my database. The second page shows the data of the selected name The third page will provide a form to create a new account. My first question is, when you click on a name in the data grid, is there anyway to make it automatically open the second accordion page to show the account details. Currently I have the grid working and the detail page working, but don't know how, if there is a way to make it open that piece automatically. My second question is, how in the heck do you make a row in the datagrid of a flash form open a new cfml page an pass an id from the selected row? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230799 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
Multiple Row Insert Into SQL from another database
I need to insert multiple rows into a SQL database from an Access Database. Basically I have an ecommerce site with a bunch of products in it. We would like to use these products in another application. I am going to run the update nightly. After the first update the system will need to check and see if the product id from ecommerce site exists in the products table of the other system. If so it needs to skip it, if not it needs to add it. I seen somthing about a INSERT SELECT statment, but do not know if it is possible to use this since I am in two different databases and two different Data Sources. I think I can write a loop and if statment but thing that with the number of products, we have it may bog the system down. Currently we only have about 800 but this will triple in a few months. My other option is that I can and already am doing a CSV export, but how do I import this and how do I prevent duplicates? any help would be much appreciated. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224710 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
Re: CF Web Based Keyboard
This is real close to what I want but I need it to work with either some type of tab capability or have it simply fill in the field that has focus. Finally it needs to be able to be wrapped within a form tag to submit the fields that it filled out. Sample that is close: http://208.131.61.180/on-keyboard.cfm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220275 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
Re: CF Web Based Keyboard
This is real close to what I want but I need it to work with either some type of tab capability or have it simply fill in the field that has focus. Finally it needs to be able to be wrapped within a form tag to submit the fields that it filled out. Sample that is close: http://208.131.61.180/on-keyboard.cfm >Quick search found this. Probably some better ones, but this looked easy >enough to modify. I'm sure you could replace it with images over buttons. > >http://javascript.internet.com/miscellaneous/on-screen-keyboard.html > >-e > > >-Original Message- >From: Jerry Johnson [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 29, 2005 4:48 PM >To: CF-Talk >Subject: Re: CF Web Based Keyboard > >It wouldn't be ColdFusion (which is server-side), it would need to be >something client-side (flash, javascript, java) > >You are probebly talking about an image map with javascript onclick() >that insert characters into a form field. > >You might also need the ability to move between form fields using tab and >enter. > >On 9/29/05, grovem <[EMAIL PROTECTED]> wrote: >> I am developing a kiosk system that will simply use IE and a cold fusion >server. >> I will be using a touch screen and would like to eliminate the keyboard. >> >> Has anyone developed a web based keyboard that when you press the keys, >they fill in a form. >> I am assuming this can be done in flash, but can it also be done using >html and CFML. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220274 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Dynamic Links and Spacing
I have a site that generates some dynamic links. Ya know simply pulling from a database. Anyway I would like to separate each link with a "|". The problem, however is that the links list horizontally and I get a trailing "|". For example About Us | Contact Us | Advertising | Home | Is there a way using MOD or something to drop the last one? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196642 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
HELP!!! I have a SQL Call That I cannot Make work...
I have been working on this for days and can not figure it out. I think it would be somthing easy, but just cant get it. I have an auction site that I am working on. I have two tables, Auction_Item table and Auction_Bid table. The item table houses the product id, auction close date, the reserve price and the seller id. The bid table houses the product_id, bid amount and bidder id. What I want to do is show a list of auctions that have reached their close date and have a bid exceeding the reserve price. I can do this. The trickey part is, I dont want to see all of the bids exceeding the reserve. Only the highest bid. here is what I have so far SELECT ab.Bid_Amount as HighBid, ab.Member_ID as Bidder, ab.product_id, ai.reserve_price, ai.date_enddate as ENDDATE, ai.product_identifier, ai.member_ID as SELLER, ml.userid as BIDDER_NAME FROM Auction_Bids ab, Auction_Items ai, member_list ml WHERE ai.status = 'active' AND ai.date_enddate < #createODBCdate(now())# AND ab.bid_amount >= ai.reserve_price AND ai.product_ID = ab.Product_ID AND ab.Member_ID = ml.member_ID ORDER BY ai.date_enddate, ai.product_ID, ab.bid_amount DESC What am I missing? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF - post to database question
I am looking for a way to post information directly to a database from a csv, excel or text delimited file. I am looking for one of two options. Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database. Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database. Can someone point me in the right direction? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HELP - Logout (sessionDelete, StructClear)?
I have written an application that allows a user to log in. When the user logs in I run the following code... I first check to see if the user exisits. If so... Then I set some session variables
self.location ='https://foo';
return them to the home page This works fine. The problem I am having is that when they press logout. It does not really logo them out. Here is my logout code... Log Off Failed Logging Off. It does send them back to the home page, but if I log in with a different ID, I am still accessing the site with the account I just logged out with. HELP...I have tried everything I could think of and it is still not logging them out. I have an application file running with this... Not sure if that will make a difference. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
