Adobe Community : All Content - All Communities

jquery validation engine and CF issue.

forums_noreply@adobe.com — Sun, 05 Aug 2012 12:54:54 GMT

Hello;

I'm working on a simple coldfusion contact form. I am trying to use a jquery plug - in with it, I have the plug in working with no problem, but it won't reload the page to allow the coldfusion to execute if all fields are valid. I'm posting my code.. can anyone help me? I think I need to add a call for the page to reload with the variables to my script.. not sure how I do that.

function beforeCall(form, options){

if (window.console)

console.log("Right before the AJAX form validation call");

return true;

}

// Called once the server replies to the ajax form validation request

function ajaxValidationCallback(status, form, json, options){

if (window.console)

console.log(status);

if (status === true) {

alert("the form is valid!");

// uncomment these lines to submit the form to form.action

form.validationEngine('detach');

form.submit();

// or you may use AJAX again to submit the data

}

jQuery(document).ready(function(){

jQuery("#formID").validationEngine({

ajaxFormValidation: true,

onAjaxFormComplete: ajaxValidationCallback,

});

</script

and here is what sets off the coldfusion, it's all on the same page, one page mailing it and so on..

<cfmail............

</cfform>

thank you bla bla bla
</cfif>

that's it without getting into the form and all of that. I have the validation working, not able to send the message. I know it's because ajax/jquery aren't reloading the page, how do I make it do that?

Thank you!

jquery validation engine and CF issue.

forums_noreply@adobe.com — Mon, 06 Aug 2012 15:38:15 GMT

Hello;

function beforeCall(form, options){

if (window.console)

console.log("Right before the AJAX form validation call");

return true;

}

// Called once the server replies to the ajax form validation request

function ajaxValidationCallback(status, form, json, options){

if (window.console)

console.log(status);

if (status === true) {

alert("the form is valid!");

// uncomment these lines to submit the form to form.action

form.validationEngine('detach');

form.submit();

// or you may use AJAX again to submit the data

}

jQuery(document).ready(function(){

jQuery("#formID").validationEngine({

ajaxFormValidation: true,

onAjaxFormComplete: ajaxValidationCallback,

});

</script

and here is what sets off the coldfusion, it's all on the same page, one page mailing it and so on..

<cfmail............

</cfform>

thank you bla bla bla
</cfif>

Thank you!

YouTube fileupload api error.

forums_noreply@adobe.com — Mon, 19 Dec 2011 17:35:40 GMT

Hello;

I'm building a small site using YouTubes API system. I downloaded a YouTube.cfc from Ray Camden, and it works excellent. I am having an issue with a fileupload and the content I'm sending. It's outside the cfc function, it's the information I'm sending off to youtube. I've changed it around and I know it's my key words that is making it error. I am attaching the piece of code and the error

Error:

YouTubeCFC Upload Error: Domain=yt:validation, Code=invalid_value

my code:

The way this works is as follows:
this form uploads the video to the server, then youtube takes it to their server so the uploaded file is the actual file that is being sent

Converting a small php mail app to a cf mail app, is it possible?

forums_noreply@adobe.com — Thu, 23 Feb 2012 14:37:29 GMT

Hello;

I am trying to use a small app I picked up and it uses a php email tag in a java scrip / jquery based email applet for a web site. The php tag sends a callback to the jquery when the message is sent, if it doesn't, the jquery throws an error and tells the user nothing was sent. I know how to use a cfmail tag, but I am looking for help with sending the callback to the jquery.

I'm posting both sets of code, the php code, and then the cf code:

PHP version

<?php

//declare our assets

$name = stripcslashes($_POST['name']);

$emailAddr = stripcslashes($_POST['email']);

$comment = stripcslashes($_POST['comment']);

$subject = stripcslashes($_POST['subject']);

$contactMessage = "Message: $comment \r \n From: $name \r \n Reply to: $emailAddr";

//validate the email address on the server side

if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $emailAddr) ) {

//if successful lets send the message

mail('/*RECIPIENT EMAIL ADDRESS*/', $subject, $contactMessage);

echo('success'); //return success callback

} else {

echo('An invalid email address was entered'); //email was not valid

}

This is the cf version I'm working on:

<cfmail to="info@astie.com"

from="#form.emailAddr#"

subject="Feedback"

type="html"

server="mail.asite.com"

port="25">

<b>Feedback Form!!</b><br>

<br>

<b>Customer Name:</b> #form.name#<br>

<b>Customer Email:</b> #form.emailAddr#<br>

<br />

<b>Feedback:</b><br>

#form.comment#</font><br>

<br>

</cfmail>

Is this possible? I was thinking a cfif statement.. but am a little unclear how to approach it. I can make the jquery available as well if needed, but If I mirror the code in the phpo it should work without having to mess with the java.
Thanks for any help.

using a cfinput checkbox with a MySQL db issue

forums_noreply@adobe.com — Thu, 08 Dec 2011 19:46:29 GMT

Hello;

I'm trying to use a checkbox to enable a person as a user in an admin section for a site. I am posting the code I am using, it works in SQL and access, but I am unsure of what the setting is for a field using yes/no - on/off type of input. Can anyone help me with what the setting is for mySQL?

My code:

<form>

</form>

</cfif>

INSERT INTO adminUser

(Fname, Lname, userName, password, email, _phone, isAdminstrator)

VALUES (<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Fname#">,

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Lname#">,

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.userName#">,

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.txtPassword#">,

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.email#">,

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.phone#">,

<cfqueryparam value="#IsAdmin#" CFSQLType="CF_SQL_INTEGER">)

</cfquery>

I know it's how i have this cell set in my DB. Can anyone help me out?

Thanks

jquery / cfmail app issues

forums_noreply@adobe.com — Thu, 03 Nov 2011 17:07:16 GMT

Hello;

I am trying to create a small contact form made from jquery, and using a cfmail page when the form is properly populated. Right now, this form will work with a php email form, called mail.php. I'm trying to now make this work with a mail.cfm form and as of right now, it's not sending it.

I can't do a dump, it is written in java and ajax so it just executes that code and isn't sending the message. I think I am missing some operators here... can anyone help me?

This is the code:

jquery page:

(function($){

//define the new for the plugin ans how to call it

$.fn.contactable = function(options) {

//set default options

var defaults = {

email: 'Email',

message : 'Message',

subject : 'A contactable message',

recievedMsg : 'Thankyou for your message',

notRecievedMsg : 'Sorry but your message could not be sent, try again later',

disclaimer: '',

hideOnSubmit: true

};

//call in the default otions

var options = $.extend(defaults, options);

//act upon the element that is passed into the design

return this.each(function(options) {

//construct the form

$(this).html('<div id="contactable"></div><form id="contactForm" method="" action=""><div id="loading"></div><div id="callback"></div><div class="holder"><p><label for="name">Name <span class="red"> * </span></label><br /><input id="name" class="contact" name="name" /></p><p><label for="email">E-Mail <span class="red"> * </span></label><br /><input id="email" class="contact" name="email" /></p><p><label for="comment">Your Feedback <span class="red"> * </span></label><br /><textarea id="comment" name="comment" class="comment" rows="4" cols="30" ></textarea></p><p><input class="submit" type="submit" value="Send"/></p><p class="disclaimer">'+defaults.disclaimer+'</p></div></form>');

//show / hide function

$('div#contactable').toggle(function() {

$('#overlay').css({display: 'block'});

$(this).animate({"marginLeft": "-=5px"}, "fast");

$('#contactForm').animate({"marginLeft": "-=0px"}, "fast");

$(this).animate({"marginLeft": "+=387px"}, "slow");

$('#contactForm').animate({"marginLeft": "+=390px"}, "slow");

function() {

$('#contactForm').animate({"marginLeft": "-=390px"}, "slow");

$(this).animate({"marginLeft": "-=387px"}, "slow").animate({"marginLeft": "+=5px"}, "fast");

$('#overlay').css({display: 'none'});

});

//validate the form

$("#contactForm").validate({

//set the rules for the fild names

rules: {

required: true,

minlength: 2

email: {

required: true,

email: true

comment: {

required: true

}

//set messages to appear inline

messages: {

email: "",

comment: ""

submitHandler: function() {

$('.holder').hide();

$('#loading').show();

$.post('mail.cfm',{subject:defaults.subject, name:$('#name').val(), email:$('#email').val(), comment:$('#comment').val()},

function(data){

$('#loading').css({display:'none'});

if( data == 'success') {

$('#callback').show().append(defaults.recievedMsg);

if(defaults.hideOnSubmit == true) {

//hide the tab after successful submition if requested

$('#contactForm').animate({dummy:1}, 2000).animate({"marginLeft": "-=450px"}, "slow");

$('div#contactable').animate({dummy:1}, 2000).animate({"marginLeft": "-=447px"}, "slow").animate({"marginLeft": "+=5px"}, "fast");

$('#overlay').css({display: 'none'});

}

} else {

$('#callback').show().append(defaults.notRecievedMsg);

}

});

}

});

};

})(jQuery);

mail.cfm:

<cfmail to="me@mysite.com"

from="#form.emailAddr#"

subject="Feedback"

type="html"

server="mail.mysite.com"

port="25">

<b>Feedback Form!!</b><br>

<br>

<b>Customer Name:</b> #form.name#<br>

<b>Customer Email:</b> #form.emailAddr#<br>

<br />

<b>Feedback:</b><br>

<p> #form.comment#</p></font>

</cfmail>

Thank you. I hope someone can help me.

ByteArray objects cannot be converted to strings

forums_noreply@adobe.com — Thu, 01 Sep 2011 16:29:39 GMT

I am trying to manage images using cf and mysql. What a pain! My SQL doesn't play nice with images so I'm finding out.

Here is what I have done. I have blobs enabled in mysol admin. Now that I did that, I can't just read the image values I uploaded to the server, I have to read a byteArray. How do I do this??

This is the code giving me a problem:

#toString(thumb)#

</cfif>

My cfif is throwing this error.

I also need it to be read if I update a record.. this is my insert update code:

<cfif form.id EQ 0>
<cfquery name="InsertDetails" datasource="#sitedatasource#">
    INSERT INTO recipes
    (title, Body, thumb, descript, categoryID)
    VALUES
(<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.title#">,
<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.Body#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.descript#">,
<cfqueryparam value="#form.categoryID#" cfsqlType="CF_SQL_INTEGER">)
</cfquery>

<cfquery name="UpdateDetails" datasource="#sitedatasource#">
UPDATE recipes
SET
recipes.title=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.title#">,
recipes.Body=<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.Body#">,
<cfif uploadedfile is true>
recipes.thumb=<cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#">,
</cfif>
recipes.descript=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.descript#">,
recipes.CategoryID=<cfqueryparam value="#form.categoryID#" cfsqlType="CF_SQL_INTEGER">
WHERE recID = <cfqueryparam value="#form.ID#" cfsqlType="CF_SQL_INTEGER">
</cfquery>

</cfif>

Can anyone help me out? I'm hoping this is a simple solution.. I have been at this for 2 days now, and this is my last issue. It is also my first time using mysql for image management.

Thank you.

problem with multiple cffile upload.

forums_noreply@adobe.com — Wed, 01 Jun 2011 16:03:49 GMT

Hello;

I am trying to program a small manager that will allow someone to upload 3 files, an image, pdf, and vcf files. I don't get any errors, BUT when I upload, the pdf file writes in as true to the db, it does upload the file, but I can't figure out why It's writting true and not the file name. I think I only need anothe rpair of eyes.. I can't figure it out. Can anyone help me out, and maybe see what I missed? I'll put in the form fields from the edit page and the query for the upload. So you get the idea.

Edit page:

</cfform>

Action Page:

<cfparam name="fileuploaded" type="boolean" default="false">
<cfparam name="uploadedfile" default="">
<cfset pathToFile = "c:\websites\215296Kh8\images\contentfile\">

<cfif len(trim(form.MYFile))>

<cftry>
<cffile Action="upload" filefield="MYFile" accept="image/gif,
image/jpg, image/jpeg, image/pjpeg"
destination="#pathToFile#" nameconflict="MAKEUNIQUE">
<cfset fileuploaded = true>
<cfset uploadedfile = cffile.serverfile>
<cfcatch type="any">

<cfset fileuploaded = false>
<cfset uploadedfile = "">
</cfcatch>
</cftry>
</cfif>

<cfparam name="PDFfileuploaded" type="boolean" default="false">
<cfparam name="PDFUploadedfile" default="">
<cfset pathToFile = "c:\websites\215296Kh8\images\contentfile\">

<cfif len(trim(form.MYPdf))>

<cftry>
<cffile Action="upload" filefield="MYPdf" accept="application/pdf, application/msword" destination="#pathToFile#" nameconflict="MAKEUNIQUE">
<cfset PDFfileuploaded = true>
<cfset PDFUploadedfile = cffile.serverfile>
<cfcatch type="any">

<cfset PDFfileuploaded = false>
<cfset PDFUploadedfile = "">
</cfcatch>
</cftry>
</cfif>

<cfparam name="VCFfileuploaded" type="boolean" default="false">
<cfparam name="VCFUploadedfile" default="">
<cfset pathToFile = "c:\websites\215296Kh8\images\contentfile\">

<cfif len(trim(form.MYVfile))>

<cftry>
<cffile Action="upload" filefield="MYVfile" accept="text/x-vcard, application/vcard (Macintosh only), text/anytext, text/directory, application/x-versit (Eudora Plug-in), text/x-versit (Eudora Plug-in), text/x-vcalendar" destination="#pathToFile#" nameconflict="MAKEUNIQUE">
<cfset VCFfileuploaded = true>
<cfset VCFUploadedfile = cffile.serverfile>
<cfcatch type="any">

<cfset VCFfileuploaded = false>
<cfset VCFUploadedfile = "">
</cfcatch>
</cftry>
</cfif>

<cfquery name="UpdateDetails" datasource="#APPLICATION.dataSource#">
UPDATE Projects
SET
<cfif fileuploaded is true>
Projects.MYFile=<cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#">,
</cfif>
Projects.mainPhone=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.mainPhone#">,
<cfif PDFfileuploaded is true>
Projects.MYPdf=<cfqueryparam cfsqltype="cf_sql_varchar" value="#PDFfileuploaded#">,
</cfif>
Projects.mainEmail=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.mainEmail#">,
<cfif VCFfileuploaded is true>
Projects.MYVfile=<cfqueryparam cfsqltype="cf_sql_varchar" value="#VCFfileuploaded#">,
</cfif>
Projects.position=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.position#">,
Projects.Body=<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.PDSeditor#">,
Projects.CategoryID=<cfqueryparam value="#form.CategoryID#" cfsqlType="CF_SQL_INTEGER">
WHERE ProjectID = <cfqueryparam value="#form.ID#" cfsqlType="CF_SQL_INTEGER">
</cfquery>

<cfquery name="InsertDetails" datasource="#APPLICATION.dataSource#">
    INSERT INTO Projects
(MYFile, mainPhone, MYPdf, mainEmail, MYVfile, position, Body, CategoryID)
VALUES
(<cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#" null="#NOT fileuploaded#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#PDFUploadedfile#" null="#NOT PDFfileuploaded#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#VCFUploadedfile#" null="#NOT VCFfileuploaded#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.mainPhone#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.mainEmail#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.position#">,
<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.PDSeditor#">,
<cfqueryparam value="#form.CategoryID#" cfsqlType="CF_SQL_INTEGER">)
</cfquery>
<cfquery name="qFetchID" datasource="#APPLICATION.dataSource#">
     SELECT id
     FROM Projects
     WHERE mainEmail =<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.mainEmail#">
</cfquery>
<cflocation url="part-manager.cfm?id=#qFetchID.id#" addtoken="no">
</cfif>

I'm sorry it's so much code.. I commented it out a little so you can see what I'm doing... It's just writting to the database improperly on both the update and insert.

Thank you.

CF 9 form validation issue on deadicated server

forums_noreply@adobe.com — Wed, 18 May 2011 13:00:03 GMT

Can anyone help me out? I have a client using a cf9 server in a deadicated environment. I'm trying to use the form validation built into cf like this:

</cfform>

it is supposed to have a pop up box (java) stating the field is needed, right now, it kicks you off to a cgi type page with validation.Is there a setting in cf9 that I need to get this active? As you see I am trying to call the script in the form tag as well, and that isn't helping either..

Thank you for the help

invalid date or time string

forums_noreply@adobe.com — Wed, 05 Jan 2011 21:13:16 GMT

I am trying to put data into my db that is a date string from a .csv file, this is the format it's in from the file: 3/3/1952 (example)

this is my query:

<cfquery name="importcsv" datasource="#APPLICATION.dataSource#">
         INSERT INTO employees (siteID,empstatus,empfirstname,empmiddlename,emplastname,empnickname, emplocation,empgender,empdob,empdoh,empee)
         VALUES
                  (<CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#trim(listgetAt(i,1))#">,
                    <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,2)#">,
                    <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,3)#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#trim(listgetAt(i,4))#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,5)#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,6)#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,7)#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,8)#">,
                 <CFQUERYPARAM cfsqltype="cf_sql_date" VALUE="#DateFormat(CreateODBCDate(ParseDateTime(listgetAt(i,9))), 'MM/DD/YYYY')#">,
                 <CFQUERYPARAM cfsqltype="cf_sql_date" VALUE="#DateFormat(CreateODBCDate(ParseDateTime(listgetAt(i,10))), 'MM/DD/YYYY')#">,
                 <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,11)#">
                  )
   </cfquery>

This is the line giving me the problem:

<CFQUERYPARAM cfsqltype="cf_sql_date" VALUE="#DateFormat(CreateODBCDate(ParseDateTime(listgetAt(i,9))), 'MM/DD/YYYY')#">,

Can anyone help me get thi sworking properly? I've been looking at all kinds of documents and web tricks and it's not working.

Thank you

Insert Excel information to Access Table, cf error

forums_noreply@adobe.com — Wed, 29 Dec 2010 12:27:22 GMT

I am trying to create a file upload that will allow me to use a .csv file, to insert the data into an access database. I have the code written, but right now, it's giving me an error and I can't figure out what I'm doing wrong, this is my first time doing this, so any and all help would be greatly appreciated.

This is my code to read the .csv file.:

<cffile action="read" file="#svrFile#" variable="csvfile">

<cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#">
    <cfquery name="importcsv" datasource="#APPLICATION.dataSource#">
         INSERT INTO employees (siteID,empstatus,empfirstname,empmiddlename,emplastname,empnickname,emplocation,empgende r,empdob,empdoh,empee)
         VALUES
                  ('#listgetAt('#index#',1, ',')#',
                   '#listgetAt('#index#',2, ',')#',
                   '#listgetAt('#index#',3, ',')#',
                   '#listgetAt('#index#',4, ',')#',
                   '#listgetAt('#index#',5, ',')#',
                   '#listgetAt('#index#',6, ',')#',
                   '#listgetAt('#index#',7, ',')#',
                   '#listgetAt('#index#',8, ',')#',
                   '#listgetAt('#index#',9, ',')#',
                   '#listgetAt('#index#',10, ',')#',
                   '#listgetAt('#index#',11, ',')#'
                  )
   </cfquery>
</cfloop>

<cfquery name="rscsvdemo" datasource="#APPLICATION.dataSource#">
SELECT * FROM csvdemo
</cfquery>
<cfdump var="#employees#">
</cfif>

The error is in the insert query, I have all my columns named the same ad the database table and in the same order, I also formatted each cell in the .csv to be the same as the database.

This is the error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

The error occurred in C:\websites\211562fe3\partners\cfm\csvUploadAction.cfm: line 60

58 : '#listgetAt('#index#',9, ',')#',

59 : '#listgetAt('#index#',10, ',')#',

60 : '#listgetAt('#index#',11, ',')#'

61 : )

62 : </cfquery>

Thank you

Error Executing Database Query. (Please help)

forums_noreply@adobe.com — Tue, 09 Nov 2010 21:23:19 GMT

I can't get this query to work properly. I have gone over it so many times.. I can't count, I don't get why it's throwing an error. Here is my code, and followed by the error:

My update query:

<cfquery name="UpdateDetails" datasource="#APPLICATION.dataSource#">
UPDATE books234
SET
books234.title=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.title#">,
books234.info=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.info#">,
books234.statement=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.statement#">,
<cfif fileuploaded is true>
books234.MYFile=<cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#">,
</cfif>
books234.links=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.links#">,
books234.ordNum=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.ordNum#">
WHERE books234.ID = <cfqueryparam value="#form.ID#" cfsqlType="CF_SQL_INTEGER">
</cfquery>
<cflocation url="bookView.cfm?ID=#Form.ID#" addtoken="no">

Here is my error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value

The error occurred in C:\websites\209689jh6\slideAction.cfm: line 455 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 442 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 390 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 1 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 455 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 442 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 390 Called from C:\websites\209689jh6\admin\cms\slideAction.cfm: line 1
453 : books234.links=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.links#">, 454 : books234.ordNum=<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.ordNum#"> 455 : WHERE books234.ID = <cfqueryparam value="#form.ID#" cfsqlType="CF_SQL_INTEGER"> 456 : </cfquery> 457 : <cflocation url="bookView.cfm?ID=#Form.ID#" addtoken="no">

Can anyone see what I did wrong here? It's not like it's a sophisticated query. I write these all the time.

Thank you.

Issue with formating a query broken into columns

forums_noreply@adobe.com — Thu, 28 Oct 2010 21:12:01 GMT

Hello;

I have 2 issues actually. I'm breaking my query down into 2 columns. That all works, it's outputting it and everyhting looks nice... But now, I'm trying to do a little formating to the code to make things look correct (the out put data) and I'm not getting the proper information for some reason.. Can someone help me figure out what I need to do?

This is my code for the query, and the columns, this all works:

<cfquery name="GetList" datasource="#APPLICATION.dataSource#" dbtype="ODBC">
SELECT liveVideo.ID AS ID, liveVideo.title, liveVideo.MYVideo, liveVideo.fileURL, liveVideo.MYFile, liveVideo.Body, liveVideo.dateDD
FROM liveVideo
ORDER BY liveVideo.dateDD
</cfquery>

</td>
</cfif>

</td></cfif>
          <td width="40%" align="center" valign="top"> </td>
          </tr>
          </cfoutput>
      </table>

My first issue is to try and get the date to show up like this January 12, 2010 When I try and set the formatting, it doesn't like how I'm coding it...I tried this, and a few other variations.. isn't there a better way, like making a cfset change it and then use the name of the set in the output instead of the dateformat? this is the experimental non working code: #GetList.dateformat(dateDD[CurrentRow],'mm/dd/yyyy')#

Also, I can 't seem to use cf to find out if a db cell has data in it, this code works on a normal query or a loop, but I can't get it to work with breaking up a query like this...
<cfif isDefined("GetList.fileURL")>#GetList.fileURL[Evaluate(CurrentRow+halfrecords)]#</cfif> - Doesn't work
<cfif isDefined("GetList.fileURL")> - desn't work

I realize, I need to look at each column, so I need to make the if statememnt work for how the rcords are being broken down...Can anyone help me with the logic here?

Thank you.

Problem with PayPal IPN, please help

forums_noreply@adobe.com — Sun, 29 Aug 2010 17:38:16 GMT

Hello;

I am using this code to grab the users information from paypal, I have the correct IPN and it brings it in fine, BUT here is my issues. I have 2 of them I can't figure out.

1. When the information comes back it is URL Encoded, how do I change it back to normal format so the email address actually uses the @ sign and not %004, and other issues with the information it brings back.

2. I get an error. In this page, I have a form that is populated by the information that comes back from paypal, when the user submits this form to send that info as well as the new info we need from them I get this error:

Element TX is undefined in URL.


The error occurred in C:\Inetpub\wwwroot\paypal\step2.cfm: line 60
58 : <p align="left"><img src="../images/bridalText.jpg" width="257" height="59"></p> 59 : <cfset authToken="WIdGltUcQs9sLX8vbFzjejE6QyMsO9JQh96G_ZM1JIY8mNPfhVW-aOqJzvy"> 60 : <cfset txToken = url.tx> 61 : <cfset query="cmd=_notify-synch&tx=" & txToken & "&at=" & authToken> 62 :

I know this is a lot of code, but it is pretty simple. How do I define TX in the form? and how do I unencode the information back from paypal?

My code: (I'm cutting a lot out, so you can see the main portion of what I am doing)

<cfif left(cfhttp.FileContent,7) is "SUCCESS">
    <cfloop list="#cfhttp.FileContent#"
                 index="curLine"
                 delimiters="#chr(10)#">
        <cfif listGetAt(curLine,1,"=") is "first_name">
            <cfset firstName=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "last_name">
            <cfset lastName=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "payer_email">
            <cfset email=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "address_street">
            <cfset streetAdd=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "address_city">
            <cfset city=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "address_state">
            <cfset state=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "address_zip">
            <cfset zip=listGetAt(curLine,2,"=")>
        </cfif>

        <cfif listGetAt(curLine,1,"=") is "item_name">
            <cfset itemName=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "mc_gross">
            <cfset mcGross=listGetAt(curLine,2,"=")>
        </cfif>
        <cfif listGetAt(curLine,1,"=") is "mc_currency">
            <cfset mcCurrency=listGetAt(curLine,2,"=")>
        </cfif>
    </cfloop>
    <cfoutput>
        <p><h3>Your order has been successfully received.</h3></p>
        <b>Details</b><br>
        <li style="line-height:15px; margin-left:20px;">Name: #firstName# #lastName#</li>
        <li style="line-height:15px; margin-left:20px;">Description: #itemName#</li>
        <li style="line-height:15px; margin-left:20px;">Amount: #mcCurrency# #mcGross#</li>
        <hr>
    </cfoutput>

<cfelse>
ERROR: Check to make sure the authToken value set is EXACTLY what PayPal gave
</cfif>

<cfparam name="FORM.firstName" default="#firstName#">
<cfparam name="FORM.lastName" default="#lastName#">
<cfparam name="FORM.email" default="#email#">
<cfparam name="FORM.cPhone" default="#phone#">
<cfparam name="FORM.streetAdd" default="#streetAdd#">
<cfparam name="FORM.city" default="#city#">
<cfparam name="FORM.state" default="#state#">
<cfparam name="FORM.zip" default="#zip#">

</cfform>

</cfoutput>

I also took out a bunch of fields I need to have the user fill out, but this is the meat of what I'm trying to do.
Can anyone help me??? Please? It's driving me nuts!

Thank you!

Creating an archive from db data?

forums_noreply@adobe.com — Mon, 04 Oct 2010 12:44:05 GMT

Hello;

I was wondering if there is way to use coldfusion (and my database) to create archives in records after a certain date? I've been looking all over the web to see if there is a way or if someone has made it.. I have only found .zip file archives.

Can anyone point me in the right direction to accomplish this? Is it possible?

This is what I want to do maybe a query of queries on all articles any in:in the month of september go to a september link and the same for each month, then also broken down by years.

I started with a strait up query with next and previous capabilities.I can post the code if needed. Now I want to archive some of the records out to another page / query.

Thank you.. any help is appreciated

ColdFusion slideshow possibilities?

forums_noreply@adobe.com — Thu, 16 Sep 2010 17:00:00 GMT

Hello;

I am trying to come up with a way to make a coldfusion slideshow using cf code and javascript. I am hoping someone can help focus me into a proper solution. In my head, it seems kind of easy, I would just need a java script "timer" of sorts to cycle through all the records in the database, or turn it off and do it manually. I am going to post my coldfusion portion of the code.. maybe someone can either point me in the direction of a site with a tutorial, or help me with the java portion?

Normal cf query with paging function-

<cfquery NAME="slideShow" datasource="#APPLICATION.dataSource#">
SELECT ID, mainImage, content
FROM slide
ORDER BY ID
</cfquery>
<cfset rowsPerPage = 1>
<cfparam name="URL.startRow" default="1" type="numeric">
<cfset totalRows = slideShow.recordCount>
<cfset endRow = min(URL.startRow + rowsPerPage - 1, totalRows)>
<cfset startRowNext = endRow + 1>
<cfset startRowBack = URL.startRow - rowsPerPage>

#mainImage#
#content#
</cfoutput>

</cfloop>

I'm not loading it up with layout code or anything.. I am just putting the hard code for this.. I also want to have links to go back to each record, something like this....

<cfset thisPage = 1>
<cfloop from="1" to="#totalRows#" step="#rowsPerPage#" index="pageRow">
<cfset isCurrentPage = (pageRow gte URL.startRow) and (pageRow lte endRow)>
<cfif isCurrentPage>
<cfoutput>#thisPage#</cfoutput>

<cfoutput>
<a href="#CGI.script_name#?startRow=#pageRow#" class="nav">#thisPage#</a>

</cfoutput>

</cfif>
<cfset thisPage = thisPage + 1>
</cfloop>

I am not sure how easy it is going to be to make it automatically go through the records without reloading the page.. maybe using an ajax control or javascript is what I'm thinking. I know this can be done in flash, but I'm not good enough with flash to use remoting and create it...

Can anyone either point me in the right direction or help me out with a script that might work this type of a small app?

Thank you

PHP email form with Validation - not working

forums_noreply@adobe.com — Wed, 11 Aug 2010 15:56:45 GMT

Hello;

I am new to using php. I usually use coldfusion or asp but this site requires me to write in php. I have a form I am trying to get to work and right now.. it doesn't do anyhting but remember what you put in the fields. It doesn't want to send, and it won't execute the validation script for the fields that are required. Can anyone help me make this work? I'm confused and a definate newbie to PHP.

Here is my code:

<?php

              $PHP_SELF = $_SERVER['PHP_SELF'];
              $errName    = "";
              $errEmail    = "";
              $errPhone    = "";

              if(isset($_POST['submit'])) {

                      if($_POST["ac"]=="login"){

                    $FORMOK = TRUE;    // $FORMOK acts as a flag. If you enter any of the conditionals below,                             // it gets set to FALSE, and the e-mail will not be sent.

                    // First Name
                    if(preg_match("/^[a-zA-Z -]+$/", $_POST["name"]) === 0) {
                        $errName = '<div class="errtext">Please enter you name.</div>';
                        $FORMOK = FALSE;
                    }
                    // Email
                if(preg_match("/^[a-zA-Z]\w+(\.\w+)*\@\w+(\.[0-9a-zA-Z]+)*\.[a-zA-Z]{2,4}$/", $_POST["email"]) === 0) {                                                    $errEmail = '<div class="errtext">Please enter a valid email.</div>';
                        $FORMOK = FALSE;
                    }
                    // Phone
                    if(preg_match("/^[a-zA-Z -]+$/", $_POST["phone"]) === 0) {
                        $errPhone = '<div class="errtext">Please enter your phone number.</div>';
                        $FORMOK = FALSE;
                    }


                    if($FORMOK) {
                            $to = "mysite@mysite.com";
                            $subject = "my. - Contact Form";
                            $name_field = $_POST['name'];
                            $email_field = $_POST['email'];
                            $phone_field = $_POST['phone'];
                            $city_field = $_POST['city'];
                            $state_field = $_POST['state'];
                            $message = $_POST['comment'];
                            $message = "
                            Name: $name_field
                            Email: $email_field
                            Phone: $phone_field
                            City: $city_field
                            State: $state_field
                            Message: $message";

                            $headers = 'MIME-Version: 1.0' . "\r\n";
                            $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

                            // Additional headers
                            $headers .= 'To: <mysite@mysite.com>' . "\r\n";
                            $headers .= '[From] <$email_field>' . "\r\n";

                            // Mail it
                            mail($to, $subject, $message, $headers);
                            header("Location: thankyou.php")

                            // I have no idea what these next 3 lines are for. You may just want to get rid of them.

ini_set("sendmail_from","[Send from]");

ini_set("SMTP","[mail server]");

mail($to, $subject, $message, $headers);

                            } else {

                            echo "Error!";
                            }
                        }
                    }
                    ?>

<form method="post" action="<?php $PHP_SELF ?>" id="commentForm">

<input name="phone" size="40" value="<?php echo $_POST["phone"]; ?>" type="text" id="phone">
<?php if(isset($errPhone)) echo $errPhone; ?>

<input name="state" size="40" value="<?php echo $_POST["state"]; ?>" type="text" id="state">

</form>

It seems pretty simple.. but it's not working at all. I would also like this page to submit to it's self, and when it actually does send an email, to just make the form disappear and replace it with the thank you text instead of sending you to another page. I also do not need to use an smtp server, it goes directly to the network server when sent.

I'm really sorry to ask all of this, I'm trying to learn this language and need to make this work.

Thank you for anyones help in advance.

how to set a cell to accept null values.

forums_noreply@adobe.com — Thu, 08 Jul 2010 18:36:33 GMT

Hello;

I am having a problem with my insert query. My form, is passing the year (2010 and up) as a null value. I am using access (ugg) and I can't get it to accept this null value. I have tried setting required to no, and allow zero lenght, even deleted the table and remade it.. STILL I get this error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null) The error occurred in C:\Websites\187914kg3\accManage\signUp.cfm: line 234
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 206
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 204
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 4
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 1
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 234
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 206
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 204
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 4
Called from C:\Websites\187914kg3\accManage\signUp.cfm: line 1

232 :         <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#form.securitCode#">,
233 :         <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#form.ExpirationMonth#">,
234 :         <cfqueryparam value="#FORM.ExpirationYear#" cfsqltype="CF_SQL_VARCHAR">)
235 : </cfquery>
236 :

SQLSTATE	22003
SQL	INSERT INTO MerchandiseOrdersItems (c_ID, cc_type, cc_num, cc_verify, cc_expir_m, cc_expir_y) VALUES ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) )
VENDORERRORCODE	3

This is my form element and query that is causing the problem:

<form>

<select name="ExpirationYear" class="formSelect">
           <cfloop index="i" from="#VARIABLES.y1#" to="#VARIABLES.y2#">
              <option value="#i#"<cfif FORM.ExpirationYear EQ i> selected</cfif>>#NumberFormat(i,"0000")#</option>
           </cfloop>
         </select>

</form>

<cfquery datasource="#APPLICATION.dataSource#" dbtype="ODBC">
INSERT INTO MerchandiseOrdersItems
(c_ID, cc_type, cc_num, cc_verify, cc_expir_m, cc_expir_y)
VALUES (<cfqueryparam value="#getUpdate.NewID#" cfsqltype="CF_SQL_VARCHAR">,
        <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.creditType#">,
        <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#form.creditCard#">,
        <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#form.securitCode#">,
        <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#form.ExpirationMonth#">,
        <cfqueryparam value="#FORM.ExpirationYear#" cfsqltype="CF_SQL_VARCHAR" null="yes">)
</cfquery>

The string that is erroring is this:

I still get this error. SO It has to be something inside the access database not allowing this null value. It is set as text right now, allowing zero length and not required.

Can anyone help me please?

Innerjoin type mismatch error

forums_noreply@adobe.com — Wed, 07 Jul 2010 15:03:29 GMT

Hello;

I'm trying to write an innerjoin query, and I get an error with a mismatched expression... I'm posting my query, maybe someone else can see where I'm going wrong here...

<cfquery name="logMem" datasource="#APPLICATION.dataSource#">
SELECT Lcustomers.c_ID, Lcustomers.c_fname, Lcustomers.c_lname, Lcustomers.c_street, Lcustomers.c_city, Lcustomers.c_state, Lcustomers.c_zip, Lcustomers.c_email, MerchandiseOrdersItems.cardID, MerchandiseOrdersItems.c_ID, MerchandiseOrdersItems.cc_type, MerchandiseOrdersItems.cc_num, MerchandiseOrdersItems.cc_verify, MerchandiseOrdersItems.cc_expir_m, MerchandiseOrdersItems.cc_expir_y
FROM Lcustomers
INNER JOIN MerchandiseOrdersItems
ON MerchandiseOrdersItems.c_ID = LCustomers.c_ID
WHERE Lcustomers.c_email = '#SESSION.uscl.c_email#'
</cfquery>

This is the error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.

The error occurred in C:\Websites\187914kg3\store\confirmorder.cfm: line 52

50 : INNER JOIN MerchandiseOrdersItems
51 : ON MerchandiseOrdersItems.c_ID = LCustomers.c_ID
52 : WHERE Lcustomers.c_email = '#SESSION.uscl.c_email#'
53 : </cfquery>
54 : <cfif logMem.cc_type EQ "">

SQLSTATE	HY000
SQL	SELECT Lcustomers.c_ID, Lcustomers.c_fname, Lcustomers.c_lname, Lcustomers.c_street, Lcustomers.c_city, Lcustomers.c_state, Lcustomers.c_zip, Lcustomers.c_email, MerchandiseOrdersItems.cardID, MerchandiseOrdersItems.c_ID, MerchandiseOrdersItems.cc_type, MerchandiseOrdersItems.cc_num, MerchandiseOrdersItems.cc_verify, MerchandiseOrdersItems.cc_expir_m, MerchandiseOrdersItems.cc_expir_y FROM Lcustomers INNER JOIN MerchandiseOrdersItems ON MerchandiseOrdersItems.c_ID = LCustomers.c_ID WHERE Lcustomers.c_email = 'mjc@phoenixdesignstudio.com'
VENDORERRORCODE	-3079

Can anyone see what's wrong?
Thank you.

Java Error for slideshow

forums_noreply@adobe.com — Mon, 07 Jun 2010 13:13:16 GMT

Hello;

I wrote a small slide show app using dhtml and ajax. (java) I have everything working accept the pop up window, I get a java error when I try and click on the link for the larger image. Can anyone help me figure out how to fix this error?

This is my error:

"objectPhotoSlide" is undefined line 14

Line 14 is this code in my java file:
objectPhotoSlide.innerHTML='<img src="'+ evt.src +'" id="largePhoto" alt="Large Photo" border="0"/>';

This is my java page:

It is an external java script. this is the code in the main page that is supposed to be attached to this java:

<div id="cover"> </div>
<div id="slide" onclick="hideSlide()">
<span class="slideControl">Click To Close&otimes;</span>
<div id="photoSlide">Loading</div>
</div>
<div id="photoAlbum">
<img src="lighting/photo0.jpg" class="photoAlbumImg" alt="Testing" onclick="showSlide(this);"/>

</div></div>

and that's it other then the .css code. If you need to see that, I can post it as well.

Thank you

Ajax / Java script error, conflict in my page.

forums_noreply@adobe.com — Thu, 03 Jun 2010 20:29:19 GMT

Hello;

I'm writting a simple slideshow for my web site. I'm trying to use dynamic html / ajax to accomplish this but I am getting an error in my code, and it seems to be conflicting with my navigation as well. The navigation is written in Java as well. So what I'm going to do is post my pages code from my java in the head to the java page that runs the slideshow and the css file. Maybe someone else can see where my problem is. It will work once this problem is figured out...

Here is my code:

Main page:

<head>

function newImage(arg) {
if (document.images) {
rslt = new Image();
rslt.src = arg;
return rslt;
}
}

var preloadFlag = false;
function preloadImages() {
if (document.images) {
home_over = newImage("images/home-over.jpg");
about_over = newImage("images/about-over.jpg");
services_over = newImage("images/services-over.jpg");
projects_over = newImage("images/projects-over.jpg");
contact_over = newImage("images/contact-over.jpg");
preloadFlag = true;
}
}

// -->
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="preloadImages();" class="mainBody">
<center>
<div id="wrapper">
<div id="mainHeader">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td width="50%" align="left" valign="top"><img src="../images/logo.jpg" alt="" width="296" height="120" /></td>
    <td width="50%" align="right" valign="top"><img src="../images/projectHead.gif" alt="" width="393" height="120" /></td>
</tr>
</table>
</div>
<div id="mainSpacer"></div>
<div id="navBar" align="center">
<a href="../index.html"
    onmouseover="window.status='home'; changeImages('home', 'images/home-over.jpg'); return true;"
    onmouseout="window.status=''; changeImages('home', 'images/home.jpg'); return true;"
    onmousedown="changeImages('home', 'images/home-over.jpg'); return true;"
    onmouseup="changeImages('home', 'images/home-over.jpg'); return true;" style="margin-right:15px;">
    <img name="home" src="../images/home.jpg" width="68" height="26" border="0" alt="Home"></a>
<a href="../about.html"
    onmouseover="window.status='about'; changeImages('about', 'images/about-over.jpg'); return true;"
    onmouseout="window.status=''; changeImages('about', 'images/about.jpg'); return true;"
    onmousedown="changeImages('about', 'images/about-over.jpg'); return true;"
    onmouseup="changeImages('about', 'images/about-over.jpg'); return true;" style="margin-right:9px;">
    <img name="about" src="../images/about.jpg" width="87" height="26" border="0" alt="About Us"></a>

<a href="../project.html"
    onmouseover="window.status='projects'; changeImages('projects', 'images/projects.jpg'); return true;"
    onmouseout="window.status=''; changeImages('projects', 'images/projects-over.jpg'); return true;"
    onmousedown="changeImages('projects', 'images/projects.jpg'); return true;"
    onmouseup="changeImages('projects', 'images/projects.jpg'); return true;" style="margin-right:15px;">
    <img name="projects" src="../images/projects-over.jpg" width="83" height="26" border="0" alt="projects"></a>

<a href="../service.html"
    onmouseover="window.status='services'; changeImages('services', 'images/services-over.jpg'); return true;"
    onmouseout="window.status=''; changeImages('services', 'images/services.jpg'); return true;"
    onmousedown="changeImages('services', 'images/services-over.jpg'); return true;"
    onmouseup="changeImages('services', 'images/services-over.jpg'); return true;" style="margin-right:10px;">
    <img name="services" src="../images/services.jpg" width="84" height="26" border="0" alt="Services"></a>

           <a href="../contact.asp"
                onmouseover="window.status='contact us'; changeImages('contact_us', 'images/contact-over.jpg'); return true;"
    onmouseout="window.status=''; changeImages('contact_us', 'images/contact.jpg'); return true;"
    onmousedown="changeImages('contact_us', 'images/contact-over.jpg'); return true;"
    onmouseup="changeImages('contact_us', 'images/contact-over.jpg'); return true;">
    <img name="contact_us" src="../images/contact.jpg" width="101" height="26" border="0" alt="contact us"></a>

</div>
<div id="mainBody">
<div id="cover"> </div>
<div id="slide" onclick="hideSlide()">
<span class="slideControl">Click To Close&otimes;</span>
<div id="photoSlide">Loading</div>
</div>
<div id="photoAlbum">
<img src="lighting/photo0.jpg" alt="Testing" onclick="showSlide(this);"/>
<img src="lighting/photo1.jpg" alt="" onclick="showSlide(this);"/>
<img src="lighting/photo2.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo3.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo4.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo5.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo6.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo7.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo8.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo9.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo10.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo11.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo12.jpg" alt="" border="0" onclick="showSlide(this);"/>
<img src="lighting/photo13.jpg" alt="" border="0" onclick="showSlide(this);"/>
</div>
</div>
<div id="footerSpace"></div>
<div id="mainFooter">
<div id="footerLeft">© 2010 Conway Brothers</div>
<div id="mainFooterRight"><a href="../index.html">Home</a> | <a href="../about.html">About Us</a> | <a href="../project.html">Projects</a> | <a href="../service.html">Services</a> | <a href="../contact.asp">Contact Us</a></div>
</div>
</div><br />
<br />
<br />

</center>
</body>
</html>

This is the slideControls.js file:

window.onload=initSlides;

this is the css file:

#slide {
position:absolute;
z-index: 1000;
display: none;
top: 100px;
text-align:right;
padding:0px 8px 8px 8px;
background-color:#fff;
cursor: pointer;
font:"Arial Black", Gadget, sans-serif;
font-weight:bold;
font-size:10px;
}
#cover {
position:absolute;
width:100%;
height:100%;
z-index:100;
display: none;
background-color:#000;
opacity: .75;
filter:progid:DXImageTransform.
Microsoft.BasicImage(opacity=.75);
top:0px;
left:0px;
}
#photoAlbum {
position:relative;
z-index:0;
width: 400px;
}
#photoAlbum img {
width: 20%;
border: 2px solid red;
margin:8px;
vertical-align: top;
}
.slideControl {
color: red;
}

the error is in the slideControl.js file on line 13.
the error:
objectPhotoSlide is undefined line 13

that would be this code:

objectPhotoSlide.innerHTML+='<p>' + evt.alt +'</p>';

then there is the issue of interfearing with the operation of my nav.
Can anyone help me out.. I think I've been looking at this to long.

Thank you.

problem with a bound cfselect using the selected feature.

forums_noreply@adobe.com — Tue, 11 May 2010 17:07:42 GMT

I'm trying to get my bound cfselects to know if a record

was pulled up, and a selection was made, the cfselect shows it. If your adding a new

record, it doesn't matter. I get it to work without the bind, but I think this is a little different and not workin

g the way I need it to. Can anyone help me? I'll put in my 2 selects.. if you need more code, I can provide it. I'll als

o add the query that is called up for the page, the selects are populated by the cfc file, so maybe I'm going abo

ut this in the wrong direction?

query:

<cfquery name="categRec" datasource="#APPLICATION.dataSource#">
SELECT c.CategoryID, c.CatName AS cat_name, p.MerchName, p.MerchDescription, p.MerchPrice, p.MYFile, p.ProNumber, p.merchID, p.subID
FROM merchCategory AS c
INNER JOIN Merchandise AS p ON c.CategoryID = p.CategoryID
WHERE p.merchID = <cfqueryparam value="#URL.ID#" cfsqltype="cf_sql_integer">
AND c.CategoryID = p.CategoryID
</cfquery>

My Selects:

Can anyone help me out? I can make my .cfc querys or file available if needed.

update / insert records using a dynamic dropdown problem.

forums_noreply@adobe.com — Sat, 08 May 2010 16:06:41 GMT

Hello;

I'm trying to write part of an app that has to use a dynamic dropdown for category selection. Right now, it's all written in coldfusion, and if I use a java script, to "submit the form" so the dropdown can see if there is a sumb cat attached to your selection, it kicks my page over to the action page, and I don't want a select function to do that, that's where the update / insert record code is. I'm trying to either make this dynamic dropdown work without reloading the page, or have it reload the page, but not submit the form if it's the select dropdown that was used.

Is that understandable?

I also tried some ajax that reloads a div tag, but that isn't working at all. I am attaching my coldfusion code. Maybe someone can help me think of a way to make this work? Or a web site with a tutorial on something like this?

The code:

<cfquery name="get_Main_Group" datasource="#APPLICATION.dataSource#">
SELECT DISTINCT merchCategory.CategoryID, merchCategory.CatName
FROM merchCategory
ORDER BY CatName
</cfquery>

<select name="select_Main_Group" required="yes" id="ajaxmenu" onChange="ajaxcombo('ajaxmenu', 'contentarea')">
     <option>Select Main Group</option>
<cfloop query="get_Main_Group">
         <option value="#CategoryID#" <cfif isDefined('form.select_Main_Group')><cfif form.select_Main_Group eq "#url.CategoryID#">selected</cfif></cfif>>#CatName#</option>
     </cfloop>
</select>

<cfif isDefined('page.select_Main_Group')>
    
    <cfquery name="get_Sub_Group" datasource="#APPLICATION.dataSource#">
        SELECT subID, subName, CategoryID
        FROM merchSubCat
        WHERE CategoryID = #page.select_Main_Group#
   </cfquery>

<select name="select_Sub_Group" required="yes">
      <option>Select Subgroup</option>
      
      <cfloop query="get_Sub_Group">
        <option value="#subID#">#subName#</option>
        </cfloop>
      </select>
</cfif>

Can anyone help me out? I can add the ajax code if needed, or java that I've tried or am trying. But there has to be a better way.

Thank you.

problem with a query inner-join

forums_noreply@adobe.com — Wed, 05 May 2010 12:59:42 GMT

Hello;

I'm trying to innerjoin these 2 tables in my query for a page that will allow you to add / edit records. Right now, it's telling me I have a data mismatch. I don't see where I went wrong. Can someone help me out?

This is my code:

<cfif url.CategoryID GT 0>
<cfquery name="categRec" dataSource="#APPLICATION.dataSource#">
SELECT merchSubCat.subName, merchSubCat.subID, Categories.CategoryID, Categories.Name
FROM merchSubCat
INNER JOIN Categories
ON merchSubCat.CategoryID = Categories.CategoryID
WHERE merchSubCat.subID = <cfqueryparam value="#url.CategoryID#" cfsqltype="cf_sql_integer">
</cfquery>

<cfif categRec.RecordCount EQ 1>
<cfset CategoryID = categRec.subID>
<cfset subName = categRec.subName>
<cfset CategoryID = categRec.CategoryID>
<cfset Name = categRec.Name>
</cfif>
</cfif>

this is my error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.

The error occurred in C:\Websites\187914kg3\admin\cms\merchant\merchSub-edit.cfm: line 16
14 : INNER JOIN Categories 15 : ON merchSubCat.CategoryID = Categories.CategoryID 16 : WHERE merchSubCat.subID = <cfqueryparam value="#url.CategoryID#" cfsqltype="cf_sql_integer"> 17 : </cfquery> 18 :

I don't see what I did wrong, can another pair of eyes see where I missed something?

Thank you

adding an if / cfswitch statement to a query missing peramiters

forums_noreply@adobe.com — Tue, 04 May 2010 16:02:16 GMT

Hello;

I'm trying to add a feature into a page I made. It has a lot going on, so I'll try and give you the basic function I'm trying to add.. and as little of the other logic as possible.

I want to add a dropdown menu to this page, I have 2 querys running it. one, runs the dropdown.. here is the code for that:

<CFQUERY name="cata" datasource="#APPLICATION.dataSource#" cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
select subName, subID
FROM merchSubCat
ORDER BY subName
</CFQUERY>

<form Name="category" method="get" Action="wallProduct.cfm?id=#subID#">
<select name="CategoryID" size="1" class="selectstyle" onChange="category.submit();">
     <option value=""> --Select a Category-- </option>
         <CFOUTPUT query= "cata">
         <option value="#subID#">#subName#</option>
         </CFOUTPUT>
     </select></form>

ok, simple enough. It takes the info from my db and makes a little menu out of it. click on one of the selections, and it will pass a url.id to the same page. This query is the main query that runs the page. I need it to serve up the first set of records by default, and if you select from the drop down, the according records will be brough up. here is my query to add this feature.

<cfquery name="getMerch" datasource="#APPLICATION.dataSource#">
SELECT merchID, MerchName, MerchDescription, MerchPrice, MYFile, subID, CategoryID
FROM Merchandise
WHERE
<cfif isDefined ("#url.id#")>
<cfswitch expression="#url.id#">
<cfcase value="1">subID = 1</cfcase>
<cfcase value="2">subID = 2</cfcase>
<cfcase value="3">subID = 3</cfcase>
</cfswitch>
<cfelse>
subID = 1
</cfif>

</cfquery>

When my page loads, there is no ID in the url, and my code is not liking this and throwing an erro as such:

Element ID is undefined in URL.


The error occurred in C:\Websites\187914kg3\magWall\wallProduct.cfm: line 19
17 : FROM Merchandise 18 : WHERE 19 : <cfif isDefined ("#url.id#")> 20 : <cfswitch expression="#url.id#"> 21 : <cfcase value="1">subID = 1</cfcase>

This is my problem, and I'm sure it's something silly I'm forgetting ehre. I've done this b4. How do I make this work so that by default, subID = 1 is shown when the page loads, and the others are shown when you use the dropdown menu.

I also spoke of other logic on this page. there is a next n button running this query, as well as a cfswitch to switch the order of the records, using the ORDERBY in my query. But I want to get this dropdown menu working before I add in all this other logic.

can anyone help me? I'm having a mental block on this problem.

thank you.

cfquery problem with insert.

forums_noreply@adobe.com — Thu, 29 Apr 2010 15:52:48 GMT

Hello;

I'm having problems with my insert query for adding a new record. It's not throwing any errors, I dump all the variables from the from that feeds it and their there.. but it's not adding the record to the database. IT IS an access db, not my choice.. clients. Maybe that's the problem? (just kidding) Can someone help me figure out why this code won't add a new record. I'm posting my insert query, if you need more I can supply it. But i think it's a problem with this code.

<cfset EventDate = '#DateFormat(form.edit1,"mm/dd/yyyy")#'>
<cfquery result="yourResults" datasource="#APPLICATION.dataSource#" dbtype="ODBC">
INSERT INTO events
(title, eventDate, eventTime, location, contact, phone, fax, email, URL, sponsor, Body)
VALUES (<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.title#">,
        <cfqueryparam cfsqltype="cf_sql_date" value="#EventDate#">,
        <cfqueryparam cfsqltype="cf_sql_time" value="#form.eventTime#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.location#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.contact#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.phone#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.fax#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.email#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.URL#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.sponsor#">,
<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.PDSeditor#">)
</cfquery>
<cfquery name="qFetchID" datasource="#APPLICATION.dataSource#">
        SELECT id
        FROM events
        WHERE title = '#form.title#'
</cfquery>

It all looks right to me.. I even tried making it throw errors to maybe trip up the real problem and it's not working. Obviously.. I'm missing something.

mixing next n records with cfswitch order by problem

forums_noreply@adobe.com — Mon, 22 Mar 2010 14:53:46 GMT

Hello;

I'm trying to make 2 types of page navigation work together. both work fine independently, but when I put my next n record code together with my change order by code, when you hit the next button, it goes back to the set default for the order by. I know I need to change some code logic in my scripts that run the next n records, but I'm not sure what I need to change in it to make it all work together properly. I am attaching the code, in it's rawest form, but all code is here for both features.

<cfquery name="getMerch" datasource="#APPLICATION.dataSource#">
SELECT merchID, MerchName, MerchDescription, MerchPrice, MYFile, CategoryID
FROM Merchandise
WHERE CategoryID = 2
ORDER BY
<cfswitch expression="#sort#">
<cfcase value="1">MerchName</cfcase>
<cfcase value="2">MerchPrice</cfcase>
</cfswitch>
</cfquery>
<cfset rowsPerPage = 3>
<cfparam name="URL.startRow" default="1" type="numeric">
<cfset totalRows = getMerch.recordCount>
<cfset endRow = min(URL.startRow + rowsPerPage - 1, totalRows)>
<cfset startRowNext = endRow + 1>
<cfset startRowBack = URL.startRow - rowsPerPage>

<a href="#CGI.script_name#?sort=#IIF(sort is 1, '2', '1')#" class="pre2Nav">Order By Price</a>

<a href="#CGI.script_name#?sort=#IIF(sort is 2, '1', '2')#" class="pre2Nav">Order By Product</a>

</cfif>

</cfif>

</cfif>

</cfoutput>

All my output goes here

</cfoutput></cfloop>

Can anyone help me get this to work together? is it possible? and more importantly, how hard is it going to be to do this?

Thank you.

cfquery qeustion, not sure about syntax

forums_noreply@adobe.com — Thu, 11 Mar 2010 22:32:25 GMT

Hello;

Can someone tell me how to make this query work properly.
I need to make this query do 2 things in my where statement. one function is, any record with the number 2 in the categoryID field, is to be shown, I'm not sure how to write that. Here is my query:

<cfquery name="getMerch" datasource="#APPLICATION.dataSource#">
SELECT MerchName,MerchDescription, MerchPrice, MYFile, CategoryID
FROM Merchandise
WHERE merchID = #ATTRIBUTES.merchID# AND CategoryID = 2
</cfquery>

This part works fine: WHERE merchID = #ATTRIBUTES.merchID#

This part is wrong: AND CategoryID = 2

how would I write this? can anyone help?

thanks

Server side validation for file type with cffil sent via cfmail problem

forums_noreply@adobe.com — Mon, 15 Feb 2010 14:45:18 GMT

Hello;

I have a small app that I need to allow users to be able to use a form, and send me and email with a file attachment. I have it working nicely, I included file manipulation into the validation process of the form and required form fields. The problem I'm having, is this. I'm trying to create and instance where if they try and upload lets say a pdf, it throws and error: "You are trying to upload the wrong file, please try again we only accept bla bla bla" Problem is, even if I'm uploading the proper file, it's rejecting it and deleting it. Can someone help me fix this? I've tried a number of different ways and can't seem to get this to go off properly. I am posting some of the code. There is a ton, so I'm posting the main parts so you get the idea and see my variables.

<cfparam name="FORM.descript" type="string" default=""/>
<cfparam name="FORM.attachment_1" type="string" default=""/>

</cfcatch>
</cftry>
<cfelse>

<cftry>
<cfset request.AcceptImage="image/gif,image/jpg,image/jpeg,image/pjpeg,image/x-png">
<cffile action="upload"
                 filefield="attachment_1"
                 accept="#request.AcceptImage#"
                 destination="c:\websites\187914Kg3\uploads\"
                 nameconflict="Makeunique">

<cfif NOT ListFindNoCase("request.AcceptImage",CFFILE.ServerFileExt)>
<cfset ArrayAppend(arrErrors,"Only JPEG, GIF, and PNG file formats are accepted!<br>") />

<cftry>
<cffile action="DELETE" file="#CFFILE.ServerDirectory#\#CFFILE.ServerFile#"/>
<cfcatch>

</cfcatch>
</cftry>
</cfif>

Can anyone help me out. I can make more of this code available if needed. Like i said, there's a lot and I didn't want to dump it all out, this is the section creating the problem. There are no errors at this time, just rejecting all file types.

thank you.

Using cfxml to create a file for flash animation to read, please help

forums_noreply@adobe.com — Tue, 16 Feb 2010 16:04:00 GMT

Hello;

Forgive my ignorance on this. I'm just learning how to make coldfusion and flash work together. Right now, I have a small flash animation that plays video's and shows a thumb nail of the video, click on it and it plays. Simple enough. It reads an xml document for what video's and thumbs go toether. I'll post that code first, it works, then I'll post what I'm trying to do in ColdFusion to this.

I need to hook in a "file loading system" so the user can upload a new video and thumb into the directory and write it to a database. I would then like to have coldfusion create teh xml doc for the flash to read. I believe this is how it should work.? Am I correct on this?

Here is my xml code that is working properly right now:

<?xml version="1.0" encoding="UTF-8"?>
<gallery>
<album>
<img src="videos/video1.flv" tn="videos/thumbs/video1.jpg" />
<img src="videos/video2.flv" tn="videos/thumbs/video2.jpg" />
<img src="videos/video3.f4v" tn="videos/thumbs/video3.jpg" />
<img src="videos/video4.f4v" tn="videos/thumbs/video4.jpg" />
<img src="videos/video5.f4v" tn="videos/thumbs/video5.jpg" />
<img src="videos/video1.flv" tn="videos/thumbs/video1.jpg" />
<img src="videos/video2.flv" tn="videos/thumbs/video2.jpg" />
<img src="videos/video3.f4v" tn="videos/thumbs/video3.jpg" />
<img src="videos/video4.f4v" tn="videos/thumbs/video4.jpg" />
<img src="videos/video5.f4v" tn="videos/thumbs/video5.jpg" />

</album>
</gallery>

This is what I'm trying to do with coldfusion:

<cfquery name="GetVideo" datasource="#APPLICATION.dataSource#">
SELECT homeVid.MYFile, homeVid.MYVideo, homeVid.ID
FROM homeVid
</cfquery>

<cfoutput>
<cfxml variable="video.xml">
<?xml version='1.0' encoding='utf-8' ?>
<gallery>
   <cfloop query="GetVideo">
   <album>
      <img src="videos/#GetVideo.MYVideo#" tn="videos/thumbs/#GetVideo.MYFile#" />
   </album>
</cfloop>
</gallery>
</cfxml>
</cfoutput>

<cfdump var="#video.xml#">

My first question is, is my code correct? My second and more important question is, how do I get this to execute automatically? Can I place this in my application.cfc file and allow it to execute on application start? OR can I place this into the top of the page with the animation in it, and it will execute each time the page is loaded? Is there a better way to do this?

lastly, will this code make this into a list? It all needs to basically dump everything in the database table into this area so the animation can just go down the line and read them all properly and load the appropriate videos and thumbs.

thank you. Again, I'm sorry for so many questions, I'm learning this and am hoping I have my head wrapped around this properly.

dynamic radio button issues.

forums_noreply@adobe.com — Mon, 01 Feb 2010 02:04:52 GMT

Hello;

I changed around the way I do a contact form from one page loading onto another to just one page. I had my radio buttons working the 2 page way, but now, it throws an error and says that the TYPE is undefined in the form. The type is the name of my group of radio buttons. Here is what I'm doing, can someone help me fix this so a form will remember if it has to be reloaded what radio button you chose?

My code:

</cfif>

</cfif>

</cfif>

those are the 3, I need this form to remember your choice, they control parts of the form. The if statement is throwing the error, this is the error:

Element TYPE is undefined in FORM.

The error occurred in C:\quoteReq.cfm: line 282
Called from C:\Websites\187914kg3\quoteReq.cfm: line 276
Called from C:\Websites\187914kg3\quoteReq.cfm: line 275
Called from C:\Websites\187914kg3\quoteReq.cfm: line 260
Called from C:\Websites\187914kg3\quoteReq.cfm: line 1

280 :                 <span class="contactText">Select the type of project to get a quote.</span><br>
281 :                 <br>
282 :                 <input name="type" type="radio" id="type" onClick="setVisibility('sub3', 'inline');setVisibility('sub4','none');setVisibility('sub5','none');" value='male' <cfif form.type EQ 'male'>checked="checked"</cfif>/>
283 :                 <span class="contactText">Magnets</span>
284 :                 <input type="radio" name="type" id="type" value='female' onClick="setVisibility('sub3', 'none');setVisibility('sub4','inline');setVisibility('sub5', 'none');" <cfif form.type EQ 'female'>checked="checked"</cfif>/>

Can anyone help me fix this please?

get a dynamic cfselect to remember a selected value

forums_noreply@adobe.com — Sun, 31 Jan 2010 20:48:30 GMT

Hello;

How do I get a cfselect to remember a value if a user has selected one of the choices, but forgets to fill out another form field?

here is my select:

<cfselect enabled="No" name="state" size="1" class="formSelect" multiple="no">
                <option value="">--Select a State--</option>
                <cfloop query= "SESSION.stat">
                  <option value="#state#">#state#</option>
                </cfloop></cfselect>

Everything works accept for remembering what a user chooses I usually use something like value="#form.state#" but it doesn't work in this insance. Can anyone help me? I can't figure this out.

thanks

using a radio button in cfmail / form.

forums_noreply@adobe.com — Fri, 15 Jan 2010 18:38:28 GMT

Hello;

This is a silly question, but I can't remember how to program in radio buttons for a cfmailer. I have 3 radio buttons, basically, I just need to know what the users choice was when they checked it off. The following is my radio buttons and what I have for code right now. But I'm not grabbing the proper variable, I also tried dumping a few diffrerent variables to see if I could get it.

<input name="type" type="radio" onClick="setVisibility('sub3', 'inline');setVisibility('sub4','none');setVisibility('sub5','none');" value='male' checked="checked"/>Magnets
<input type="radio" name="type" value='female' onClick="setVisibility('sub3', 'none');setVisibility('sub4','inline');setVisibility('sub5', 'none');"/>Paper Steel
<input type="radio" name="type" value='child' onClick="setVisibility('sub3', 'none');setVisibility('sub4','none');setVisibility('sub5', 'inline');"/> both

on my response page, I tried this:

if this was their choice, then this set of rules would apply

</cfif>

and so on for the other two choices. This isn't catching my buttons, what am I doing wrong? do I need to make a paramiter for the radio buttons before I can allow it to function? like this?

then I can use my if statement? (that isn't working right now either)

here is what I'm trying to dump:

How do I do this? Can anyone help me?

simple "show / hide" script using radio buttons, need a little help

forums_noreply@adobe.com — Tue, 12 Jan 2010 16:23:31 GMT

Hello;

I have a place in my form where I need to swap out what type of form you need to fill out in an area. If I don't do this, it makes the page look over crowded and if I pass it off to a 2 or 3 step process, it doesn't have enough info in each section to be worth it. It's either one or the other.

Right now, this code works nice. click on a radio button, and the form section appears and disappears. What I am trying to make this do it when the page loads, one of the radio buttons is selected and one of the form sections is visible. Then if you click on the other radio button, it swaps them.

can anyone help me tweek this code so one of the buttons is selected all the time?

here is my script.

</script>

<form>

<input name=type type=radio onclick="setVisibility('sub3', 'inline');setVisibility('sub4','none');" value='male' checked>Selection 1

<input type=radio name=type value='female' onclick="setVisibility('sub3', 'none');setVisibility('sub4','inline');";>Selection 2

<div id="sub3" class="showHide">Selection 1 content</div>

<div id="sub4" class="showHide">Selection 2 content</div>

</form>

That's the short of it with out dumping tons of other code on anyone.

Thank you

problems passing query variable into cfwindow.

forums_noreply@adobe.com — Mon, 28 Dec 2009 15:49:42 GMT

Hello;

I'm writting a small custom app for a friend. I need to make a "user interface" for this project. The only thing that needs to be allowed to be updated is a new file I have set up in an admin section. The front end is more like an interface with 4 numbered links that will never change, so it is "hard coded" and not database driven.

When I click on my link to open up my cfwindow I get this error: (it also happens when I do a cfdump for url.a)

Element A is undefined in URL.


The error occurred in C:\websites\Vid1.cfm: line 9
7 : SELECT pastVid.title AS ViewField1, pastVid.MYFile AS ViewField2, pastVid.companyID 8 : FROM pastVid 9 : WHERE vidID = <cfqueryparam value="#URL.a#" cfsqltype="cf_sql_integer"> 10 : </cfquery> 11 : <cfset APPLICATION.vidCli=vidCli>

I realize when dealing with a cfwindow you can't pass url variables to it normally like from page to page. How do I pass this variable? I've been running searches on the web and have come up dry on this. I also have one other question. in the pop up window, how to I create a link to just reload the pop up (cfwindow) and pull the query I'm looking for? The links I am using now, close the window and open up a full page in the place of the web site that launched the window.

Can anyone help me with this? Here is my code so far. It shouldn't have to be changed much, I'm mostly missing a variable to pull from, in place of the url.

Parent Page Code (cfwindow launch page)

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=1','m yWindow');">Video 1</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=2','m yWindow');">Video 2</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=3','m yWindow');">Video 3</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=4','m yWindow');">Video 4</a>

</cfoutput>

CFWINDOW page code:

<cflock timeout="2" scope="APPLICATION" type="READONLY">
<cfquery name="vidCli" datasource="#APPLICATION.dataSource#" blockfactor="100">
SELECT pastVid.title AS ViewField1, pastVid.MYFile AS ViewField2, pastVid.companyID
FROM pastVid
WHERE vidID = <cfqueryparam value="#URL.a#" cfsqltype="cf_sql_integer">
</cfquery>
<cfset APPLICATION.vidCli=vidCli>
</cflock>

<cfoutput query="vidCli" maxrows="1">
#ViewField1#<br />

#ViewField2#<br />

</cfoutput>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=1','m yWindow');">Video 1</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=2','m yWindow');">Video 2</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=3','m yWindow');">Video 3</a>

<a href="javascript:ColdFusion.Window.show('myWindow');ColdFusion.navigate('Vid1.cfm?a=4','m yWindow');">Video 4</a>

</cfoutput>

Can anyone help me figure out how to make the owrk properly? I think I'm close

Thank you

Working with a pop up window updating childWindow from ParentWindow

forums_noreply@adobe.com — Tue, 15 Dec 2009 19:34:09 GMT

Hello;

I have call for a custom script to work a type of movie screen. I'm using java & ColdFusion. I am learning how to put this all together so please bear with me. Let me try and explain what I need this to do.

I have a page, call it parent page. In this page is 4 links:

link 1

link2

link 3

link 4

each link spawns a pop up window with a movie clip on it. Now here is the trick.

I need the pop up window to always stay on top, I am trying to write this script to position the pop up window to the left of the links on the parent page. The pop up (child page) will also be the only window these 4 links spawn. So if you clicked on link 1, it opens the child window, then with the child window open you click on link 3 in the parent under / next to the pop up, it updates the open pop up window, not spawning a new page, but updating the child page. In this process, I can make it one page with a query and an id in the url, like <cfoutput><a.... ID="childWin">childPage.cfm?ID=#ID#</a></cfoutput>

First off, is this scenario possible? If so, is there a different way to go about it or is that a question for a cf bord? Also, will there be a conflict between the childPage.cfm?ID=#ID# and the ID="childWin" embedded in my hyperlink?

Here is my java script so far.

var newWindow = null;
window.onload = initWindows;
var topPos = 30;
var leftPos = 100;

function initWindows() {
if (document.getElementById("childWin")) {
    document.getElementById(childWin).
       onchange = updateParent;
}
else {
    newWindow = window.open("child.cfm",
       "newWin","status=yes,width=300,
    height=300");
}
}

var topPos = 30;
var leftPos = 100;

if(this.id.indexOf("childWin")> -1) {
topPos = screen.availableHeight-200;
}

it's on it's own page called script04.js I know this isn't correct yet, can anyone help me iron this out to make the same window update and pop in a location I tell it...

Thank you.

is it possible to use next n record and not reload the page?

forums_noreply@adobe.com — Wed, 18 Nov 2009 20:40:27 GMT

Hello;

I'm trying to make a page on my site and I can't have it reload every time you hit the next or prev buttons. Is this possible to do this using Ajax or something like that? I have code that works well. I can post it if needed. This code reloads the page, I can tweek it if there is a simple-ish solution. I'm trying to come up with a way to stop the page from reloading. Any idea would help. I am also considering an I-frame type solution with the next / prev in the iframe and just that reloads... if that is possible.

Thank you.

Syntax error in UPDATE statement Please help

forums_noreply@adobe.com — Tue, 17 Nov 2009 20:37:35 GMT

I can't figure out what is wrong in my update statement. I did a cfdu

mp for the form.id just before this query and I get the form ID, so it's passing my ID, but why is my q

uery throwing this error?

error:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

The error occurred in C:\Inetpub\wwwroot\website\admin\cms\babyAction.cfm: line 54

52 : baby_port.weight = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.weight#">,
53 : baby_port.TimeB = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.tob#">,
54 : WHERE baby_port.ID = <cfqueryparam value="#FORM.ID#" cfsqlType="CF_SQL_INTEGER">
55 : </cfquery>
56 : <cflocation url="babyPort.cfm?ID=#ID#" addtoken="no">

SQLSTATE	42000
SQL	UPDATE baby_port SET baby_port.dob = (param 1) , baby_port.Name = (param 2) , baby_port.Body = (param 3) , baby_port.weight = (param 4) , baby_port.TimeB = (param 5) , WHERE baby_port.ID = (param 6)
VENDORERRORCODE	-3503
DATASOURCE	mainDB

Resources:

Here is my query:

<cfquery datasource="#APPLICATION.dataSource#">
UPDATE baby_port
SET
baby_port.dob = <cfqueryparam cfsqltype="cf_sql_date" value="#form.edit1#">,
baby_port.Name = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Name#">,
<cfif fileuploaded is true>
baby_port.MYFile = <cfqueryparam cfsqltype="cf_sql_varchar" value="#uploadedfile#">,
</cfif>
baby_port.Body = <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.PDSeditor#">,
baby_port.weight = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.weight#">,
baby_port.TimeB = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.tob#">,
WHERE baby_port.ID = <cfqueryparam value="#FORM.ID#" cfsqlType="CF_SQL_INTEGER">
</cfquery>

I don't understand what I'm doing wrong here. Can anyone help me? Is it more then something in this query? passing the wrong variable maybe? I can provide more code if needed.

thank you.

Java script on off switch issue in IE, Please help

forums_noreply@adobe.com — Wed, 21 Oct 2009 16:26:55 GMT

Hello;

I wrote this little script that is an on / off switch for a background sound on my web page. I have it working in all browsers accept all versions of IE. I have been pulling my hair out for weeks trying to get this script to work in IE and have only met failure. There has to be a way to get this thing to fire properly and I just can't figure out what I am missing.You can take this script, add your own sound and see how it works. It is very simple.

code:

<head>

function stopSound(){
document.getElementById('PacSound').src='../video/silence.wav';}

function playSound() {
document.getElementById('PacSound').src='../video/RollerPop.wav'; }

</script>
</head>

<a href="javascript:stopSound();" >Stop Sound</a><br />
<br />
<br />
<a href="javascript:playSound();" >play sound</a>

</body>

I am so frustrated with this. I have tried a number of different approaches to this code and I always meet failure. I am trying to make it work so the page does not re-load it's self, just turns it on and or off.

Can anyone please help me figure this out?
Thank You

Passing an identifier using hyperlink

forums_noreply@adobe.com — Thu, 01 Oct 2009 22:18:46 GMT

Hello;

I am at a loss. I fogot how to be able to pass a simple peramiter using a hyper link back to it's self on the same page. I also need the code that it activates only to activate if the link is used. How do I do this using a hyper link? I know how to use forms like this.

This is how the link works if I use another page to activate the code:

applysetting.cfm

index.cfm

<a href="apply-setting.cfm?engage=hitbox">Sound On</a>

<a href="apply-setting.cfm?deactivate=hitbox"><strong><u>Sound Off</u></strong></a>

I am trying to make it work on one page:

index.cfm

<head>

</head>

<body>

<a href="index.cfm?engage=hitbox">Sound On</a>

<a href="index.cfm?deactivate=hitbox"><strong><u>Sound Off</u></strong></a>

</body>

as it sits right now, it doesn't work properly.How can I adjust this so I can just make it load the one page and not the applysetting.cfm to make it work?

Thank you

Error with query compairing form entry.

forums_noreply@adobe.com — Tue, 01 Sep 2009 10:57:51 GMT

Hello;

I wrote a small log in and it is giving me a problem. I use this all the time, and can't figure out why now on a different server it's giving me a hard time.I get an error when I submit the log in form. I can't figure out what I missed and why it decided to give me a problem now.

this is my error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

The error occurred in C:\website\admin\LoginCheck.cfm: line 13
Called from C:\website\admin\index.cfm: line 7
Called from C:\website\admin\LoginCheck.cfm: line 13
Called from C:\website\admin\index.cfm: line 7

11 :  FROM adminUser
12 :  WHERE userName =<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.userLogin#">
13 :  AND password =<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.userPassword#">
14 : </CFQUERY>
15 :

SQLSTATE	07002
SQL	SELECT adminUser.id, adminUser.Fname, adminUser.Lname, adminUser.isAdminstrator, adminUser.userName, adminUser.password FROM adminUser WHERE userName = (param 1) AND password = (param 2)
VENDORERRORCODE	-3010
DATASOURCE	mainDB

This is that block of code from the form to the LoginCheck.cfm block of code.

Form:

</cfform>

LoginCheck.cfm page:

<CFQUERY NAME="IsValidLogin" datasource="#APPLICATION.dataSource#">
SELECT adminUser.Fname, adminUser.Lname
FROM adminUser
WHERE userName =<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.userLogin#">
</CFQUERY>
<CFQUERY NAME="IsValidUser" datasource="#APPLICATION.dataSource#">
SELECT adminUser.id, adminUser.Fname, adminUser.Lname, adminUser.isAdminstrator, adminUser.userName, adminUser.password
FROM adminUser
WHERE userName =<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.userLogin#">
AND password =<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.userPassword#">
</CFQUERY>

this IsValidUser is the one throwing the error. I have gone over this a million times and don't see what I did wrong. Can anyone see what I might be missing?

Thank you

Creating an Ajax function with a background sound. Please help.

forums_noreply@adobe.com — Fri, 28 Aug 2009 01:14:42 GMT

Hello:
I have a page that has 5 "video streams" you can call up. In the center of the page, it is a picture, if you hit the PLAY VIDEO button, it brings up the main movie, if you click on video 1 - 4 it plays those videos in the same window on the main page. The window it brings up is using an ajax script that acts like an iframe so the page doesn't have to reload everytime you click on a video link.

In the main page it's self, I want to have the sound in the background. When someone clicks the "play video" button (that is made out of an image with ajax code in the link) it will disable the bg sound to play the video. When they hit the stop video button, just like the play accept it enables the bg sound.The other 4 videos don't need to disable the sound. They will not have sound in them. so those links using the same ajax code don't need to execute anything.

I am writting this using Dreamweaver and ColdFusion (a lot of hand coding also) The following is my code. I am trying to set it up, I will comment out the parts I added for stopping the bg sound.

document.getElementById("bgsound").stop();

var loadedobjects=""
var rootdomain="http://"+window.location.hostname

function ajaxpage(url, containerid){
var page_request = false
if (window.XMLHttpRequest) // if Mozilla, Safari etc
page_request = new XMLHttpRequest()
else if (window.ActiveXObject){ // if IE
try {
page_request = new ActiveXObject("Msxml2.XMLHTTP")
}
catch (e){
try{
page_request = new ActiveXObject("Microsoft.XMLHTTP")
}
catch (e){}
}
}
else
return false
page_request.onreadystatechange=function(){
loadpage(page_request, containerid)
}
page_request.open('GET', url, true)
page_request.send(null)
}

function loadpage(page_request, containerid){
if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1))
document.getElementById(containerid).innerHTML=page_request.responseText
}

</script>

<head>

<body>

<a href="javascript:ajaxpage('mainVideo.cfm', 'rightcolumn');">image here</a>

<a href="index.cfm">my image here</a>

<a href="javascript:ajaxpage('mainVideo1.cfm', 'rightcolumn');">image here</a>

<a href="javascript:ajaxpage('mainVideo2.cfm', 'rightcolumn');">image here</a>

<a href="javascript:ajaxpage('mainVideo3.cfm', 'rightcolumn');">image here</a>

<a href="javascript:ajaxpage('mainVideo4.cfm', 'rightcolumn');">image here</a>

</body>

Can anyone help me solve this problem. There has to be a way.

thankyou! any help would be appreciated!

</body>

attempting to use onRequestStart to execute when a specific page is called up. Please help

forums_noreply@adobe.com — Thu, 27 Aug 2009 20:43:02 GMT

Hello;

I am trying ot use a little app I have for turning off background music from a dynic web site. It works nice if I reload the page. But I want to pass it off to the application.cfc file and let that file run the code and if a button is clicked, the application should catch it. (If I miss my guess, everytime you click a link in a cf site, the application.cfc is the first page read?) Does that include a page using ajax as a Iframe loader?Anyway. This is my application file code:

</cfif>
</cffunction>
</cfcomponent>

this is part of a larger site. This application file sits in a sub directory pulling the info from the main application.cfc file in the main directory. Now, I want this code to fire every time the page www.mydomain.com/subdirectory/index.cfm file is pulled up.Is this possible this way? If so, how far am I off and can someone help me code this to work?

Thank You!

cfml preloader, is it possible? please assist

forums_noreply@adobe.com — Wed, 12 Aug 2009 18:20:05 GMT

Hello;

I have a page on a site that is mostly images. One big image cut up in pieces with a couple of cfwindows going in them.

I want to preload the page before it appears because it looks terrible when it is loading up. Is it possible to use a pre-loader for an html page to do this? Better yet is there an html preloader out there?

I am trying to use this code, but it is not cutting it.

_cf_loadingtexthtml="<div align='center'><img src='hig_progcircle_pending.gif'/>";
_cf_contextpath="";
_cf_ajaxscriptsrc="/CFIDE/ajax";
_cf_jsonprefix='//';
_cf_clientid='CAEFC4EBBACACC9E9920EB79DFC39CE9';

</script>

anyone have a better idea or even know if what I want to do is possible?

thank you.

cfajax onsubmit self form. please help

forums_noreply@adobe.com — Sun, 09 Aug 2009 00:19:39 GMT

Hello;

I am trying to make a small app that works as follows.

I made a page for getting drections to my office. I have it tied into google maps. The whole thing works really well. I have one issue. When you hit submit on the form with your departure address, the whole page loads and you have to scroll down to the bottom to get the directions.

I want it to load on the directions it's self. So I am trying to use this ajax loading code I have. As of right now, the way it is set up, I get no error, my information still loads, and I still have to scroll down. Can anyone help me fix this code OR tell me a better way to accomplish this. I have limited options as anyone knows who has programmed google maps into a web site.

This is my code, as it is set up.

<head>

<script type="text/javascript">
/***Combo Menu Load Ajax snippet**/
function ajaxcombo(selectobjID, loadarea){
var selectobj=document.getElementById? document.getElementById(selectobjID) : ""
if (selectobj!="" && selectobj.options[selectobj.selectedIndex].value!="")
ajaxpage(selectobj.options[selectobj.selectedIndex].value, loadarea)
}
</script>

</head>

<body>

<--- here are my form filds --->

I am doing something wrong here, or this code is not meant to be used like this.

Can anyone help me?

thank you

cfajax text load using a form. please help

forums_noreply@adobe.com — Sat, 08 Aug 2009 03:17:06 GMT

Hello;

I am trying to make a small app that works as follows.

I am making a page for getting drections to my house. I have it tied into google maps. The whole thing works really well. I have one issue. When you hit submit on the form with your departure address, the whole page loads and you have to scroll down to the bottom to get the directions.

I want it to load on the directions it's self. So I am trying to use this ajax loading code I have. As of right now, the way it is set up, I get an object error, but my information still loads, just get an error and have to scroll down still. Can anyone help me fix this code OR tell me a better way to accomplish this. I have limited options as anyone knows who has programmed google maps into a web site.

This is my code, as it is set up.

<head>

<script type='text/javascript' src='/scripts/engine.js'></script>
<script type='text/javascript' src='/scripts/util.js'></script>
<script type='text/javascript' src='/scripts/settings.js'></script>
<script language="javascript">
   function loadInfo()
   {
    var address = DWRUtil.getValue("address");
    DWREngine._execute(_cfscriptLocation, null, 'addressinfo', address, getResult);
   }

   function getResult(result)
   {
    document.getElementById("info").innerHTML = result;
   }

function init()
   {
    DWRUtil.useLoadingMessage();
    DWREngine._errorHandler = errorHandler;
    loadInfo();
   }
</script>

</head>

<--- here are my form filds --->

The java files are fine, I don't need to change anything on those. I am doing something wrong here, or this code is not meant to be used like this.

Can anyone help me?

thank you

basic spam filter error.

forums_noreply@adobe.com — Tue, 04 Aug 2009 16:47:30 GMT

Hello;

I am working on a small script to add to my contact form. It generates a random number, puts it in a session variable then compairs it before it will send the email. if it doesn't match, then you can not send the form. As everyone knows, spam bots like sending spam via contact forms.Anyway, this is a nice script but it is throwing an error on some computers and not on others. I can't figure out why. this is my code and how it is set up.

application.cfc

</cffunction>

contact form

<head>

</head>

<body>

<cfoutput>#SESSION.chk_rand#</cfoutput> Enter this number here ->
<cfinput type="text" name="spmchck" message="You must enter our Security Number" validateat="onSubmit" validate="integer" required="yes" class="spam_Inputs" size="4" maxlength="4"/>

</form>

Response page

<cfparam name="form.spmchck" default="">
<cfif form.spmchck NEQ session.chk_rand>
<cfoutput>"Sorry, you did not fill in the Security Field, you must go <a href="contact.cfm" class="subNav">back</a> and refill in our contact form.<br> If you are human and sending spam, please don't bother, we do not want any. Thank you."</cfoutput>
<cfset x = StructDelete(Session, "chk_rand")>
<cfabort>
</cfif>

This is the error I get, but not all the time.

Complex object types cannot be converted to simple values.
The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a cfif tag.

The error occurred in C:\websites\response.cfm: line 6 Called from C:\websites\response.cfm: line 4 Called from C:\websites\response.cfm: line 1 Called from C:\websites\response.cfm: line 1 Called from C:\websites\contact.cfm: line 3
4 : <cftry> 5 : <cfparam name="form.spmchck" default=""> 6 : <cfif form.spmchck NEQ session.chk_rand> 7 : <cfoutput><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="##990000">"Sorry, you did not fill in the Security Field, you must go <a href="contact.cfm" class="subNav">back</a> and refill in our contact form.<br> If you are human and sending spam, please don't bother, we do not want any. Thank you."</font></cfoutput> 8 : <cfset x = StructDelete(Session, "chk_rand")>

Can anyone help me figure out why this only throws an error once and a while on certain machines? There are no cookies, only session variables. I am confused.

Thank you

detecting plug-ins with CF

forums_noreply@adobe.com — Mon, 20 Jul 2009 14:43:22 GMT

Hello;

Is there a way.. (other then the obvious using the actualy plug in as a detector) to detect if someone has lets say the java plut in installed using coldfusion code? If so, how would I do that, what variables do I go after?

Thank you for any help on this.

Need help with writting an update / insert with related tables

forums_noreply@adobe.com — Thu, 09 Jul 2009 16:08:40 GMT

I am new at ColdFusion. I am learning how to write querys and am creating a small app to collect information from visitors to my web site. (It is also a good way for me to learn this language) I am having a problem and it is not just how to use an update / insert with related tables. I am not sure if I am even gathering the proper variables to compair them to existing db records before it runs either the update or insert querys.Can someone help me, show me how to update / insert related tables and maybe tell me if I am creating the proper varibales to do the compairison?This is my code, I am commenting it out.

<cfset userIP = ('#CGI.REMOTE_ADDR#')>

<cfquery name="userTracking" datasource="#APPLICATION.dataSource#" dbtype="ODBC">
SELECT REMOTE_ADDR
FROM user_track
WHERE REMOTE_ADDR = #userIP#
</cfquery>

<cfif userTracking EQ userIP>
<cfquery datasource="#APPLICATION.dataSource#">
UPDATE user_track, trackDetail
SET user_track.REMOTE_ADDR=<cfqueryparam value="#Trim(CGI.REMOTE_ADDR)#" cfsqltype="CF_SQL_VARCHAR">,
user_track.browser=<cfqueryparam value="#Trim(CGI.HTTP_USER_AGENT)#" cfsqltype="CF_SQL_VARCHAR">,
user_track.visits = visits+1,
trackDetail.date=<cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP">,
trackDetail.path=<cfqueryparam value="#Trim(PATH_INFO)#" cfsqltype="CF_SQL_LONGVARCHAR">
WHERE REMOTE_ADDR =<cfqueryparam value="#Trim(CGI.REMOTE_ADDR)#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfelse>

<cfquery datasource="#APPLICATION.dataSource#" dbtype="ODBC">
INSERT INTO user_track, trackDetail
(user_track.REMOTE_ADDR, user_track.browser, user_track.visits, trackDetail.userID, trackDetail.date, trackDetail.path)
VALUES(
<cfqueryparam value="#Trim(CGI.REMOTE_ADDR)#" cfsqltype="CF_SQL_VARCHAR">,
<cfif Len(Trim(HTTP_USER_AGENT)) GT 1>
<cfqueryparam value="#Trim(CGI.HTTP_USER_AGENT)#" cfsqltype="CF_SQL_VARCHAR">,
</cfif>
visits+1,
<cfqueryparam value="#Trim(CGI.HTTP_USER_AGENT)#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#user_track.userID#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP">,
<cfqueryparam value="#Trim(PATH_INFO)#" cfsqltype="CF_SQL_LONGVARCHAR">
)
</cfquery>
</cfif>

Am I at all close on this? This doesn't throw any errors, but it isn't working either. So obviously it is wrong. I get a cfdump at the end of my compairison query, but once it hits the if statement, it is lost.

Thank you for your time anyone.

Newbie

Adobe Community : All Content - All Communities

jquery validation engine and CF issue.

jquery validation engine and CF issue.

YouTube fileupload api error.

YouTubeCFC Upload Error: Domain=yt:validation, Code=invalid_value

Converting a small php mail app to a cf mail app, is it possible?

using a cfinput checkbox with a MySQL db issue

jquery / cfmail app issues

ByteArray objects cannot be converted to strings

problem with multiple cffile upload.

CF 9 form validation issue on deadicated server

invalid date or time string

Insert Excel information to Access Table, cf error

Error Executing Database Query. (Please help)

Error Executing Database Query.

Issue with formating a query broken into columns

Problem with PayPal IPN, please help

Element TX is undefined in URL.

Creating an archive from db data?

ColdFusion slideshow possibilities?

PHP email form with Validation - not working

how to set a cell to accept null values.

Innerjoin type mismatch error

Error Executing Database Query.

Java Error for slideshow

Ajax / Java script error, conflict in my page.

problem with a bound cfselect using the selected feature.

update / insert records using a dynamic dropdown problem.

problem with a query inner-join

Error Executing Database Query.

adding an if / cfswitch statement to a query missing peramiters

Element ID is undefined in URL.

cfquery problem with insert.

mixing next n records with cfswitch order by problem

cfquery qeustion, not sure about syntax

Server side validation for file type with cffil sent via cfmail problem

Using cfxml to create a file for flash animation to read, please help

dynamic radio button issues.

Element TYPE is undefined in FORM.

get a dynamic cfselect to remember a selected value

using a radio button in cfmail / form.

simple "show / hide" script using radio buttons, need a little help

problems passing query variable into cfwindow.

Element A is undefined in URL.

Working with a pop up window updating childWindow from ParentWindow

is it possible to use next n record and not reload the page?

Syntax error in UPDATE statement Please help

Java script on off switch issue in IE, Please help

Passing an identifier using hyperlink

Error with query compairing form entry.

Error Executing Database Query.

Creating an Ajax function with a background sound. Please help.

attempting to use onRequestStart to execute when a specific page is called up. Please help

cfml preloader, is it possible? please assist

cfajax onsubmit self form. please help

cfajax text load using a form. please help

basic spam filter error.

Complex object types cannot be converted to simple values.

detecting plug-ins with CF

Need help with writting an update / insert with related tables