Search results for query: *

Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROM crAdInfo AND PubYear BETWEEN...

Dear All, I hope someone can assist with this issue. I have 3 tables Profile, Agent, Agency. Profile --------- profile_id profile_name company_id company_name Agent ------- agent_id agent_name Agency ------- agency_id agency name Basically profile.company_id can hold an ID from...

Hi All, I have a form that I am trying to fulfill the following scenario. Does anyone have any advise/solutions? I have a registration form. On the form are the following fields: -US State Pulldown -Country Pulldown -5 Night Hotel Pulldown -3 Night Hotel Pulldown -Arrival Date...

Hi, I am curious if anyone knows of a calendar script (free or pay) that will enable to me to configure it so that a specific day and beyond is selectable? (e.g. user cannot select a date before March 25, 2007). Thanks!!

Hi, I am not sure if I am missing the obvious, but, I am setting up a new computer and would like to move my Enterprise Manager settings to the new PC (I really would not want to have to retype all that server registration info). Is there a way to do this? Just for clarification this only to...

Hi, I have some simple code: <select name="Var#ctr#" style="width: (#Len(VarientName)# + 8)px;" class="textfield" onClick="javascript: a(this.value, #ctr#);document.frmProductDetail.SKU.value = varSKU;"> Where the "document.frmProductDetail.SKU.value = varSKU;" should change the value of a...

I am using cfform to validate and I need to use ASCII in the message. However, when the javascript opens it shows the ASCII not the characters. As there any way around this? <cfinput type="Text" name="fname" message="&##21153;&##24517;&##22635;&##20889;: &##22995;&##21517;&##65306;"...

Does anyone have a script to submit a single form to two different URLs. Any help is appreciated. Thanks!!!!

I am in a dilemna. I have a query I need to loop over and get the listlen for each iteration of the loop and then get the sum. I am stuck. Can anyone lend a pointer? Here is what I got so far: <cfloop query="images"> <cfset num = listlen(images.photo)> </cfloop> From here I need the...

I have cf7 installed ok, except for flash forms loading in odd. on IE the flash form loads in with a js error for lc_id and in Firefox the flash preload stops at 40%. i am sure it has something to do with a mapping or file, but I do not know where to target. Thanks!!

I have a page with a text field. On this page I can click a link and open a window with a series of checkboxes. What I would like to do is be able to check off the boxes and insert the values into the text field of the opener page. I would like the values to insert as a comma seperated list...

If someone could help out here I would appreciate it. I would like to use JS so that when you enter in a specific value into an input box it can instruct the 3 input boxes below it to be readonly or not. Basically what I have is a JS that auto fills in city and state based on a zip code and...

Hi All, While inserting some XML I am getting this error &quot;illegal xml &#x14;&quot;, however I can not find out what it is and I have no clue on testing for it, to replace it. Trying to replace &#x14; in a replace() does nothing. Any thoughts? HELP!!! Michael!

I am sorting XML in a SQL data base and using GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date.XmlText as my retrieval method. Everyhting is working fine however, in some cases I can not use XSLT because of some formatting limitations (actually client peculiarities)...

Hope someone can assist. I am going after a node in xml: Live=GetContent.XmlFeed[1].contentdata.XmlChildren[1].live.XmlText; Then I am testing on it: <cfif Live eq &quot;yes&quot; #attributes.Data# <cfelse> Sorry this page is currently not available. </cfif> My problem is that the node...

I have an Xpath statement where I am going after two paths: <cfset Parent = #XmlSearch(ContainersXml, &quot;/cms_containers/container[@menu='yes']|/cms_containers/container[@menu='yes']/content[@landing='yes']&quot;)# > <!--- Get Parent---> From this XPath I want to pull the info only from the...

I have an XML file that resembles: ######BEGIN####### <maincontainers> <container ID=&quot;DD364AA5-C09F-0662-D2A6372503A93F48&quot; menu=&quot;yes&quot; name=&quot;Visit&quot;> <content ID=&quot;239&quot; label=&quot;rt-239&quot; ctcd=&quot;FCT&quot;>test</content> <content...

I have an XML file that resembles: ######BEGIN####### <maincontainers> <container ID=&quot;DD364AA5-C09F-0662-D2A6372503A93F48&quot; menu=&quot;yes&quot; name=&quot;Visit&quot;> <content ID=&quot;239&quot; label=&quot;rt-239&quot; ctcd=&quot;FCT&quot;>test</content> <content...

Hope someone can help. I am dynamically creating checkboxes from a comma seperated list (i.e., sam, mary, howard, pam). I am saving the data I check off to the database as a comma seperated list (i.e., mary, pam). When I pull up the record to edit it, how do I code it to mark the checkboxes as...

How could I go about testing for the existance of a value in my XML? say: <person> <name value=&quot;Peter&quot;> <address>75 Hunts Street</address> </name> <name value=&quot;Andrew&quot;> <address></address> </name> <name> <address>45 Main</address> </name> </person> For the above how could...