Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
Gear_Head
New Here
Gear_Head
New Here
Activity
‎Mar 21, 2019
06:13 AM
I have a simple query for a list using checkbox : <cfloop query="getlist"> #thingstodo# : <input type="checkbox" name="thingstodo" value="<br/>#thingstodo#"> <p> </cfloop> So it will apear like this : Some list of things to do 1 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 1"> <p> Some list of things to do 2 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 2"> <p> Some list of things to do 3 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 3"> <p> Some list of things to do 4 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 4"> <p> My problem is it adds a coma at the end and this is how it looks in the database : <br/>Some list of things to do 1,<br/> Some list of things to do 2,<br/> Some list of things to do 3,<br/> Some list of things to do 4,<br/> Some list of things to do 5,<br/> I tryed using replace before i send it in the databse but i think i'm doing it wrong plus some of the text in the list might have a coma in it so this might not be the answer: <cfset thingstodo = Replace(thingstodo, ",","","ALL")> Thanks for your help
... View more
‎Oct 16, 2017
06:33 AM
I got it to work i found in Aurigma a field that has the value i was looking for form.PACKAGEINDEX its working now
... View more
‎Oct 13, 2017
11:39 AM
Yes and i did that nothing happens in the Aurigma Code uploadSettings: { actionUrl: 'Upload.cfm', }, Is suppose to be uploadSettings: { actionUrl: 'Upload.cfm', redirectUrl: 'Gallery.cfm' }, So upload.cfm just loads to transfert the files I dont see the dump
... View more
‎Oct 13, 2017
08:39 AM
Nothing happens the upload.cfm files only transfeert the images it stays on the index.cfm i uploaded here so you can see Test
... View more
‎Oct 13, 2017
07:51 AM
This is the the page where you load the images : Index.cfm ***************************************************************************** <cfprocessingdirective pageEncoding="UTF-8" /> <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Test </title> <meta name="viewport" content="width=device-width, initial-scale=1" /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"/> <link href="Scripts/css/aurigma.htmluploader.control.css" rel="stylesheet" type="text/css" /> <link href="Styles/css.css" rel="stylesheet" type="text/css" /> <link href="bower_components/bootstrap/dist/css/bootstrap.css" rel="stylesheet"/> <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> <script type="text/javascript" src="bower_components/jquery/dist/jquery.min.js"></script> <script src="Scripts/aurigma.imageuploaderflash.min.js" type="text/javascript"></script> <script src="Scripts/aurigma.htmluploader.control.js" type="text/javascript"></script> <script type="text/javascript"> $().ready(function(){ var uploader = $au.imageUploaderFlash({ id: 'Uploader1', licenseKey: '77FF1-00001-78280-0002D-132E8-3520C7', width: '100%', height: '450px', uploadButtonText: "Télécharger", enableDescriptionEditor: false, enableRotation: true, converters: [ { mode: '*.*=SourceFile' }, { mode: '*.*=Thumbnail', thumbnailFitMode: 'Fit', thumbnailWidth: '120', thumbnailHeight: '120' } ], uploadSettings: { actionUrl: 'Upload.cfm', }, topPane: { visible: false, }, uploadPane: { addFilesButtonText: "ajoutez les photos", }, statusPane: { filesToUploadText: "<font color='#7a7a7a'>Fichier</font> {0}", noFilesToUploadText: "<font color='#7a7a7a'>Aucun fichier</font> {0}", }, flashControl: { codeBase: '../Scripts/aurigma.imageuploaderflash.swf', bgColor: '#f5f5f5' }, restrictions: { maxFileSize: 31457280, fileMask: [ ['Images (*.jpg)', '*.jpg'] ], minFileCount: 5, maxFileCount: 5}, messages: { tooFewFiles: 'Vous devez soumettre 5 photos.', maxFileCountExceeded: 'Vous devez soumettre 5 photos.' }, }); $("#uploader").html(uploader.getHtml()); }); </script> <script> $().ready(function(){ if (typeof $au !== 'undefined' && !!$au.debug) { $("#uploader-version").text($au.debug().version()); } }); </script> </head> <body> <div class="container"> <div class="col-md-10 col-lg-10 col-sm-10 col-md-offset-1 col-lg-1-offset col-sm-offset-1"> <div class="row"> <div class="panel panel-primary"> <div class="panel-heading"> </div> <div class="panel-body" id="sample-body"> <div id="uploader"></div> </div> <div class="panel-footer"> </div> </div> </div> </div> </div> <!-- Bootstrap core JavaScript ================================================== --> <!-- Placed at the end of the document so the pages load faster --> <script src="bower_components/bootstrap/dist/js/bootstrap.js"></script> </body> </html> ***************************************************************************** This is the entire upload.cfm page ***************************************************************************** <CFQUERY NAME="getinfo" datasource="MyDNS"> SELECT * FROM company WHERE no_client = 1 </cfquery> <CFQUERY NAME="thelastid" datasource="MyDNS"> SELECT id FROM tires ORDER by id desc </cfquery> <cfset lastcount = 0> <cfset lastid = #thelastid.id# + 1> <cfprocessingdirective pageEncoding="utf-8" /> <!---This variable specifies relative path to the folder, where the gallery with uploaded files is located. Do not forget about the slash in the end of the folder name.---> <cfset galleryPath="UploadedFiles/" /> <cfset absGalleryPath="#ExpandPath(galleryPath)#" /> <cfset absThumbnailsPath="#absGalleryPath#Thumbnails/" /> <!---Create XML file which will keep information about files (image dimensions, description, etc). XML is used solely for brevity. In real-life application most likely you will use database instead.---> <!---Get total number of uploaded files (all files are uploaded in a single package) and iterate through uploaded data and save the original file, thumbnail, and description.---> <cfset fileCount = Form.PackageFileCount - 1 /> <cfloop index="i" from="0" to="#fileCount#"> <cfset name="#Form["SourceName_#i#"]#"/> <!--- Get source file and save it to disk. ---> <cffile action="UPLOAD" filefield="File0_#i#" destination="#absGalleryPath#" nameconflict="MakeUnique"> <cfimage action = "resize" width="800" height="600" source = "#galleryPath#\#name#" destination = "D:\MyPath\#cookie.no_client#_#lastid#_#i#.jpg" overwrite = "yes"> <cffile action = "delete" file = "D:\MyPath\UploadedFiles\#name#"> <cfset sourceFileName="#replace(URLEncodedFormat(serverFile), '%2E', '.', 'ALL')#" /> <!--- Get first thumbnail (the single thumbnail in this code sample) and save it to disk. ---> <cfset thumbnailFileName=Form["File1Name_#i#"] /> <cffile action="UPLOAD" filefield="File1_#i#" destination="#absThumbnailsPath#" nameconflict="MakeUnique"/> <cffile action="rename" source="#serverDirectory#/#serverFile#" destination="#thumbnailFileName#" attributes="normal"/> <!---Save file info.---> <cfset thumbnailFileName="#URLEncodedFormat(thumbnailFileName)#" /> </cfloop> <cfoutput>#fileCount#</cfoutput> *****************************************************************************
... View more
‎Oct 13, 2017
06:45 AM
Same result and the code for the <cffile action="upload"> was provided by Aurigma with the uploader i added the resize/rename and delete
... View more
‎Oct 11, 2017
10:52 AM
Hi, i'm using Aurigma image uploader to upload photos for a used tire website and i want to have specific names for the photos so they dont get overwrite so i use my clientID and the next ID in my tire databasse plus i want to add the loopcount and the end so i upload the image then i rename them but my index i stays a 0 in destination = "D:\MYPATH\#clientID#_#nextID#_#i#" i only get 1 out of my 5 images in my directory somthing like 12_176_0.jpg and its the last one that got uploaded so why is my i index not adding up ? <cfset fileCount=(#Form.PackageFileCount#-1) /> <cfloop index="i" from="0" to="#fileCount#"> <cfset name="#Form["SourceName_#i#"]#"/> <!--- Get source file and save it to disk. ---> <cffile action="UPLOAD" filefield="File0_#i#" destination="D:\MYPATH\" nameconflict="MakeUnique"> <cfimage action = "resize" width="800" height="600" source = "D:\MYPATH\#name#" destination = "D:\MYPATH\#clientID#_#nextID#_#i#.jpg" overwrite = "yes"> <cffile action = "delete" file = "D:\MYPAT\#name#"> </cfloop> **************************************************************************** And i also what to update my database with the name of the photos i have 5 field named photo, photo1, photo2, photo3, photo4 once i get the loopcount i was thinking of using something like this but how do i get the photo1, photo2 etc... in there ? <cfquery name="updatetData" datasource="myDNS"> UPDATE INTO usedtires WHERE ID = #lastid# (photo) VALUES ( <cfqueryparam value="#cookie.no_client#_#lastid#_#i#" cfsqltype="cf_sql_varchar"> ) </cfquery> Thanks
... View more
‎Sep 21, 2017
05:51 PM
You are right Bkbk, because i have been looking for this kind of code for a few days before i asked here. So here is the woking one i added a 4th select box for the options and it is working perfectly. Keep in mind that the sitepneus in the CFC bind was a test directory I was using. The database was for a car and tire match : year/vendor/model/modification 2016/Acura/RDX/3.0i the search-result.cfm is a simple page to see if i was getting the proper tire size for a specific car. ************************************ CFM main page ************************************ <html> <head> <title>Car search</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <cfform action="search-result.cfm" method="post"> <table> <tr> <td>Select Year :</td> <td><cfselect name="year" bind="cfc:sitepneus.cars.getyear()" bindonload="true" /></td> </tr> <tr> <td>Select Vendor:</td> <td><cfselect name="vendor" bindOnLoad="false" bind="cfc:sitepneus.cars.getVendor({year})" /></td> </tr> <tr> <td>Select Model:</td> <td><cfselect name="model" bindOnLoad="false" bind="cfc:sitepneus.cars.getModel({year},{vendor})" /></td> </tr> <tr> <td>Select option:</td> <td><cfselect name="modification" bindOnLoad="false" bind="cfc:sitepneus.cars.getoption({year},{vendor},{model})" /></td> </tr> </table> <input type="Submit" value="Search"> </cfform> </body> </html> ************************************ CFC ************************************ <cfcomponent> <cfset this.dsn = "MyDate"> <cfprocessingdirective pageEncoding="utf-8"> <!--------------- year -----------> <cffunction name="getyear" access="remote" returntype="array"> <cfset var yearQry = ""> <cfquery name = "yearQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT year FROM tx_carmodels order by year DESC </cfquery> <!--- Values for the first - the default - select option ---> <cfset yearArray[1][1]=""> <cfset yearArray[1][2]="Select a year"> <cfloop query="yearQry"> <cfset yearArray[currentrow+1][1]=yearQry.year> <cfset yearArray[currentrow+1][2]=yearQry.year> </cfloop> <cfreturn yearArray> </cffunction> <!--------------- Vendor / Make -----------> <cffunction name="getVendor" access="remote" returntype="array"> <cfargument name="yr" required="true" type="string"> <cfset var vendorQry = ""> <cfset var vendorArray = arrayNew(2)> <cfquery name = "vendorQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT vendor FROM tx_carmodels WHERE year = '#arguments.yr#' order by vendor </cfquery> <!--- Values for the first - the default - select option ---> <cfset vendorArray[1][1]=""> <cfset vendorArray[1][2]="Select a vendor"> <cfloop query="vendorQry"> <cfset vendorArray[currentrow+1][1]=vendorQry.vendor> <cfset vendorArray[currentrow+1][2]=vendorQry.vendor> </cfloop> <cfreturn vendorArray> </cffunction> <!--------------- Model -----------> <cffunction name="getModel" access="remote" returntype="array"> <cfargument name="yr" required="true" type="string"> <cfargument name="vendor" required="true" type="string"> <cfset var modelQry = ""> <cfset var modelArray = arrayNew(2)> <cfquery name = "modelQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT model FROM tx_carmodels WHERE year = '#arguments.yr#' AND vendor = '#arguments.vendor#' order by model </cfquery> <!--- Values for the first - the default - select option ---> <cfset modelArray[1][1]=""> <cfset modelArray[1][2]="Select a model"> <cfloop query="modelQry"> <cfset modelArray[currentrow+1][1]=modelQry.model> <cfset modelArray[currentrow+1][2]=modelQry.model> </cfloop> <cfreturn modelArray> </cffunction> <!--------------- options -----------> <cffunction name="getOption" access="remote" returntype="array"> <cfargument name="yr" required="true" type="string"> <cfargument name="vendor" required="true" type="string"> <cfargument name="model" required="true" type="string"> <cfset var optionQry = ""> <cfset var optionArray = arrayNew(2)> <cfquery name = "optionQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT modification FROM tx_carmodels WHERE year = '#arguments.yr#' AND vendor = '#arguments.vendor#' AND model = '#arguments.model#' order by modification </cfquery> <!--- Values for the first - the default - select option ---> <cfset optionArray[1][1]=""> <cfset optionArray[1][2]="Select an option"> <cfloop query="optionQry"> <cfset optionArray[currentrow+1][1]=optionQry.modification> <cfset optionArray[currentrow+1][2]=optionQry.modification> </cfloop> <cfreturn optionArray> </cffunction> </cfcomponent> ************************************ CFM search-result.cfm ************************************ <html> <head> <title>Tire Result</title> <cfquery name = "getcar" dataSource = "MyData"> SELECT * FROM tx_carmodels WHERE year = #year# AND vendor = '#vendor#' AND model = '#model#' </cfquery> <cfquery name = "gettires" dataSource = "MyData"> SELECT * FROM tyrespecifications WHERE carmodel = #getcar.id# </cfquery> </head> <body> <table> <cfoutput query="gettires"> <tr> <td>#Spectype#</td> <td>#front_width#/#front_profile#R#front_diameter#</td> </tr> </cfoutput> </table> </body> </html> To make it clearer Spectype was Default or Alternative. the rest was tire size #front_width#/#front_profile#R#front_diameter# in this case for year/vendor/model/modification 2016/Acura/RDX/3.0i would be : DEFAULT 235/60R18 ALTERNATIVE 235/55R19 ALTERNATIVE 255/50R19 ALTERNATIVE 255/45R20 Thanks BKBK
... View more
‎Sep 20, 2017
10:06 AM
You wanna cry ? annee/year is a varchar not a numeric field its working perfecly thank you so much WHERE annee = '#arguments.yr#' AND vendor = '#arguments.vendor#' Now why is <cfprocessingdirective pageencoding="utf-8"> not working ? I even tryed using é ; for the é
... View more
‎Sep 20, 2017
09:31 AM
Forgot to tell you i alredy tryed that same error
... View more
‎Sep 20, 2017
07:38 AM
same thing http://mesclients.ca/sitepneus/index4.cfm CFM ****************************** <cfform> <table> <tr> <td>Select Year :</td> <td><cfselect name="annee" bind="cfc:sitepneus.cars.getannee()" bindonload="true" /></td> </tr> <tr> <td>Select Vendor:</td> <td><cfselect name="vendor" bind="cfc:sitepneus.cars.getVendor({annee})" /></td> </tr> <tr> <td>Select Model:</td> <td><cfselect name="model" bind="cfc:sitepneus.cars.getModel({annee},{vendor})" /></td> </tr> </table> </cfform>
... View more
‎Sep 20, 2017
07:03 AM
CF 11 and no
... View more
‎Sep 20, 2017
06:34 AM
I just tryed this just in case i couldnt use vendor either same error message CFm ********************* <cfform> <table> <tr> <td>Select Year :</td> <td><cfselect name="annee" bind="cfc:cars.getannee()" bindonload="true" /></td> </tr> <tr> <td>Select Vendor:</td> <td><cfselect name="levendor" bind="cfc:cars.getVendor({annee})" /></td> </tr> <tr> <td>Select Model:</td> <td><cfselect name="model" bind="cfc:cars.getModel({annee},{levendor})" /></td> </tr> </table> </cfform> The error says Line 67 WHERE annee = #arguments.yr# Line 117 WHERE annee = #arguments.yr# AND vendor = '#arguments.vendor#' Is it possible that the cfc is loading the function before its called ?
... View more
‎Sep 20, 2017
06:23 AM
I changed it to annee with the same error message "Error","ajp-bio-8014-exec-1474","09/20/17","08:15:56",,"Error Executing Database Query.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by vendor' at line 7 The specific sequence of files included or processed is: D:\MyPath\sitepneus\cars.cfc, line: 67 " at cfcars2ecfc125460375$funcGETVENDOR.runFunction(D:\MyPath\sitepneus\cars.cfc:67) "Error","ajp-bio-8014-exec-1484","09/20/17","08:15:56",,"Error Executing Database Query.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND vendor = '' order by model' at line 5 The specific sequence of files included or processed is: D:MyPath\sitepneus\cars.cfc, line: 117 " at cfcars2ecfc125460375$funcGETMODEL.runFunction(D:\MyPath\sitepneus\cars.cfc:117) here is the code : CFM **************************** <cfform> <table> <tr> <td>Select Year :</td> <td><cfselect name="annee" bind="cfc:cars.getannee()" bindonload="true" /></td> </tr> <tr> <td>Select Vendor:</td> <td><cfselect name="vendor" bind="cfc:cars.getVendor({annee})" /></td> </tr> <tr> <td>Select Model:</td> <td><cfselect name="model" bind="cfc:cars.getModel({annee},{vendor})" /></td> </tr> </table> </cfform> ********************************* CFC ******************************** <cfcomponent> <cfset this.dsn = "Mydata"> <cfprocessingdirective pageEncoding="utf-8"> <cffunction name="getannee" access="remote" returntype="array"> <cfset var anneeQry = ""> <cfquery name = "anneeQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT annee FROM tx_carmodels order by annee DESC </cfquery> <!--- Values for the first - the default - select option ---> <cfset anneeArray[1][1]=""> <cfset anneeArray[1][2]="Sélectionner une année"> <cfloop query="anneeQry"> <cfset anneeArray[currentrow+1][1]=anneeQry.annee> <cfset anneeArray[currentrow+1][2]=anneeQry.annee> </cfloop> <cfreturn anneeArray> </cffunction> <cffunction name="getVendor" access="remote" returntype="array"> <cfargument name="yr" required="true" type="string"> <cfset var vendorQry = ""> <cfset var vendorArray = arrayNew(2)> <cfquery name = "vendorQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT vendor FROM tx_carmodels WHERE annee = #arguments.yr# order by vendor </cfquery> <!--- Values for the first - the default - select option ---> <cfset vendorArray[1][1]=""> <cfset vendorArray[1][2]="Sélectionner une marque"> <cfloop query="vendorQry"> <cfset vendorArray[currentrow+1][1]=vendorQry.vendor> <cfset vendorArray[currentrow+1][2]=vendorQry.vendor> </cfloop> <cfreturn vendorArray> </cffunction> <cffunction name="getModel" access="remote" returntype="array"> <cfargument name="yr" required="true" type="string"> <cfargument name="vendor" required="true" type="string"> <cfset var modelQry = ""> <cfset var modelArray = arrayNew(2)> <cfquery name = "modelQry" dataSource = "#THIS.dsn#"> SELECT DISTINCT model FROM tx_carmodels WHERE annee = #arguments.yr# AND vendor = '#arguments.vendor#' order by model </cfquery> <!--- Values for the first - the default - select option ---> <cfset modelArray[1][1]=""> <cfset modelArray[1][2]="Sélectionner un modele"> <cfloop query="modelQry"> <cfset modelArray[currentrow+1][1]=modelQry.model> <cfset modelArray[currentrow+1][2]=modelQry.model> </cfloop> <cfreturn modelArray> </cffunction> </cfcomponent> Thanks
... View more
‎Sep 19, 2017
05:20 AM
Hi, it is working but I get 2 error message before it does : http://mesclients.ca/sitepneus/index4.cfm "Error","ajp-bio-8014-exec-1393","09/19/17","07:16:56",,"Error Executing Database Query.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND vendor = '' order by model' at line 5 The specific sequence of files included or processed is: D:\MyPATH\sitepneus\cars.cfc, line: 117 " at cfcars2ecfc125460375$funcGETMODEL.runFunction(D:\MyPATH\sitepneus\cars.cfc:117) "Error","ajp-bio-8014-exec-1394","09/19/17","07:16:56",,"Error Executing Database Query.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by vendor' at line 7 The specific sequence of files included or processed is: D:\MyPATH\sitepneus\cars.cfc, line: 67 " How can i fix this ? Thank you so much
... View more
‎Sep 18, 2017
12:48 PM
I manage to make it work takes way to long to load you are right o needed to find another way so i found this tutorial http://forta.com/blo...Related-Selects I started playing around with the code here : http://mesclients.ca...neus/index3.cfm It takes a while to load and then it gives me this error message : "Error","ajp-bio-8014-exec-1371","09/18/17","13:49:48",,"Element year is undefined in ARGUMENTS. The specific sequence of files included or processed is: E:\MYPATH\sitepneus\art.cfc, line: 46 " at cfart2ecfc931360593$funcGETART.runFunction(E:\MYPATH\sitepneus\art.cfc:46) **************************************************** CFM Page, i kept his media / art refence for now <!DOCTYPE html> <head><title>Test page </title></head> <body> <cfform> <table> <tr> <td>Select year:</td> <td><cfselect name="mediaid" bind="cfc:art.getMedia()" bindonload="true" /></td> </tr> <tr> <td>Select Make:</td> <td><cfselect name="artid" bind="cfc:art.getArt({mediaid})" /></td> </tr> </table> </cfform> </body> </html> ********************************************** CFC Page <cfcomponent output="false"> <cfset THIS.dsn="mydns"> <!--- Get array of media types ---> <cffunction name="getMedia" access="remote" returnType="array"> <!--- Define variables ---> <cfset var data=""> <cfset var result=ArrayNew(2)> <cfset var i=0> <!--- Get data ---> <CFQUERY NAME="data" datasource="#THIS.dsn#"> SELECT DISTINCT year FROM tx_carmodels order by year DESC </cfquery> <!--- Convert results to array ---> <cfloop index="i" from="1" to="#data.RecordCount#"> <cfset result[2]=data.year> </cfloop> <!--- And return it ---> <cfreturn result> </cffunction> <!--- Get art by media type ---> <cffunction name="getArt" access="remote" returnType="array"> <cfargument name="mediaid" required="true"> <!--- Define variables ---> <cfset var data=""> <cfset var result=ArrayNew(2)> <cfset var i=0> <!--- Get data ---> <CFQUERY NAME="data" datasource="#THIS.dsn#"> SELECT DISTINCT vendor FROM tx_carmodels WHERE year = "#ARGUMENTS.year#" order by year vendor </cfquery> <!--- Convert results to array ---> <cfloop index="i" from="1" to="#data.RecordCount#"> <cfset result[2]=data.vendor> </cfloop> <!--- And return it ---> <cfreturn result> </cffunction> </cfcomponent> Why isnt it getting the year and why is it so long to load
... View more
‎Sep 14, 2017
09:58 AM
I uploaded it on a server Check it out http://mesclients.ca/sitepneus/ When you choose a year all the make for that year appear in the 2nd select box when you select the make all the models should appear in the 3rd one.
... View more
‎Sep 14, 2017
08:05 AM
No event should be trigger a list of model should appear then on submit i have all 3 info i need to find the tire size
... View more
‎Sep 13, 2017
08:12 AM
Hi, I use coldfusion but i'm no expert i'm trying to populate 3 select field from a previous selection its year/vendor/model of cars to find the appropriate tire size. I manage to find some code to make the first 2 to load but the 3rd one the model doesnt work here is my code what M I missing or doing wrong ? <!DOCTYPE html> <head> <title>losd list test</title> <CFQUERY NAME="getyear" datasource="dataname"> SELECT DISTINCT year FROM carmodels order by year DESC </cfquery> <cfset Start = 1> <cfset Start2 = 1> <cfset Start3 = 1> <cfset End = getyear.recordcount> <script language="javascript"> /*Fonction addLoadEvent */ function addLoadEvent(func) { var oldonload = window.onload; if (typeof window.onload != 'function') { window.onload = func; } else { window.onload = function() { if (oldonload) { oldonload(); } func(); } } } /*Define the options*/ var tab1 = new Array("Sélectionner une année", <cfloop query = "getyear" startRow = "#Start#" endRow = "#End#"><CFOUTPUT>"#year#"<CFIF getyear.currentRow EQ #end#><CFELSE>, </CFIF></CFOUTPUT></cfloop>); var tab2 = new Array(); tab2["year"] = new Array("Marque"); <cfloop query = "getyear" startRow = "#Start2#" endRow = "#End#"><CFOUTPUT><cfset lannee = '#year#'>tab2["#year#"] = new Array("Sélectionner une marque" <CFQUERY NAME="getvendor" datasource="dataname">SELECT DISTINCT vendor FROM carmodels WHERE year = '#lannee#' ORDER by vendor</cfquery><cfset End3 = getvendor.recordcount><cfloop query = "getvendor" startRow = "#Start2#" endRow = "#End3#">, "#getvendor.vendor#"</cfloop>);</CFOUTPUT></cfloop> var tab3 = new Array(); tab3["vendor"] = new Array("Model"); <cfloop query = "getvendor" startRow = "#Start3#" endRow = "#End#"><CFOUTPUT><cfset levendor = '#vendor#'>tab3["#vendor#"] = new Array("Sélectionner un modèle" <CFQUERY NAME="getmodel" datasource="dataname">SELECT DISTINCT model FROM carmodels WHERE vendor = '#levendor#' AND year = #lannee# ORDER by model</cfquery><cfset End4 = getmodel.recordcount><cfloop query = "getmodel" startRow = "#Start3#" endRow = "#End4#">, "#getmodel.model#"</cfloop>);</CFOUTPUT></cfloop> /*The function to load the list*/ <!------ SELECT 1 -----------------> function loadList1() { var list1 = document.getElementById("list1"); for (var i = 0; i < tab1.length; i++) { var item = document.createElement('option'); item.value = tab1; item.innerHTML = tab1; if (i == 0) { item.selected = true; } list1.appendChild(item); } if (tab1.length > 0) { loadList2(tab1[0]); } } <!------ SELECT 2 -----------------> function loadList2(list1Value) { var list2 = document.getElementById("list2"); var toDelete = list2.childNodes; var tab = tab2[list1Value]; while (list2.hasChildNodes()) { list2.removeChild(toDelete[0]); } if (tab) { for (var i = 0; i < tab.length; i++) { var item = document.createElement('option'); item.value = tab; item.innerHTML = tab; list2.appendChild(item); } list2.disabled = false; } else { list2.disabled = true; } } <!------ SELECT 3 -----------------> function loadList3(list2Value) { var list3 = document.getElementById("list3"); var toDelete = list3.childNodes; var tab = tab3[list2Value]; while (list3.hasChildNodes()) { list3.removeChild(toDelete[0]); } if (tab) { for (var i = 0; i < tab.length; i++) { var item = document.createElement('option'); item.value = tab; item.innerHTML = tab; list3.appendChild(item); } list3.disabled = false; } else { list3.disabled = true; } } </script> </head> <body> <form action="search.cfm" method="post"> <script type="text/javascript">addLoadEvent(loadList1);</script><select id="list1" name="year" style="width: 180px;" onChange="loadList2(this.value);"></select> <!---- Here i get all the years and its working ---> <select id="list2" name="vendor" style="width: 180px;" onChange="loadList3(this.value);"></select> <!---- the list3.disabled = true; is activated and the field is grey out once I select a year the vendor list appears GREAT ---> <select id="list3" name="Model" style="width: 180px;"></select> <!---- the list3.disabled = true; is not activated and once i select a vendor it stays empty and the list3.disabled = true; comes in fonction and the field is greyed out---> </form> </body> </html> Thank you in advence for your help
... View more
‎Apr 04, 2017
12:04 PM
Thank you so much it worked perfectly, all i had to do is change 1 little thing posting it for future users. <cfqueryparam value="#form.price1#" cfsqltype="cf_sql_numeric"> FOR <cfqueryparam value="#price1#" cfsqltype="cf_sql_numeric"> And thank you for the cfqueryparam for security i didnt know i'm changing all my code now..
... View more
‎Mar 31, 2017
06:31 AM
Really no one
... View more
‎Mar 29, 2017
11:46 AM
Hi, I'm kinna new to this i'm trying to create a little system for my son lawn mowing business. i have field that have services and prices for it services1 price1 services2 price2 When he enters the data for the price i want to prevent him from using commas and dollar sign so when he submits field i'm trying to use this to modify it on the inserting page price_f1 is the form field so if he puts in 450,50$ <cfset price1 = ReReplace(price_f1, "[^\d.]", "","ALL") > <cfoutput>#price1#</cfoutput> it comes out 45050 i want 450.50 how can i do that ? And once that works how can i enter it into the database i have tryed to get it in using <cfinsert datasource="mydatasource" tablename="thetablename" formfields="ID, firstname, lastname...., services1, price1"></cfinsert> All the data enters but not my price1 at 45050 it stays NULL any suggestion why that is and yes i do set my var before the insert. Thank you
... View more
‎Nov 02, 2009
11:47 AM
I'm really new to Web Service how do I send the vin number usigng Cfinvoke ?
... View more
‎Nov 02, 2009
11:21 AM
The last 1
... View more
‎Nov 02, 2009
06:27 AM
This is what is happening <cfinvoke method="getVehicleInformationFromVIN" webservice="ws_name" returnVariable="WS_vartest"> <cfinvokeargument name="language" value="en"/> <cfinvokeargument name="country" value="CA"/> <cfinvokeargument name="VIN" value="1FMFU2058********"/> </cfinvoke> <cfset XMLText=ToString(WS_vartest)> <cffile action="write" file="C:\mypath\mytest2.xml" output="#XMLText#"> Web service operation "getVehicleInformationFromVIN" with parameters {country={CA},VIN={1FMFU20586*****},language={fr}} could not be found. The error occurred in C:\mypath\test_vin.cfm: line 6 4 : <cfinvokeargument name="language" value="en"/> 5 : <cfinvokeargument name="country" value="CA"/> 6 : <cfinvokeargument name="VIN" value="1FMFU2058**** with a real vin"/> 7 : </cfinvoke> what i m doing wrong
... View more
‎Nov 01, 2009
04:03 AM
Ok using the DUMP i manage to get this : <cfset WS_var = createObject ("webservice","mywebservicename")> <cfoutput><cfdump var="#WS_var#"></cfoutput> Now i'm trying to use CFinvoke to pass the username nad password and a vin number to get an actuel XML from a decoded VIN then saving it has an XML file on my server but i cant get it to work can you please check my code out. And also would that work ? <cfinvoke method="getVehicleInformationFromVIN" webservice="aa_chrome" retrunVariable="WS_vartest"> <cfinvokeargument name="USERNAME_PROPERTY" value="myuser"/> <cfinvokeargument name="PASSWORD_PROPERTY" value="mypass"/> <cfinvokeargument name="VIN" value="an actual vin"/> </cfinvoke> <cfset XMLText=ToString(WS_vartest)> <cffile action="write" file="C:\mypath\mytest2.xml" output="#XMLText#"> Thank you very much for the help so far.
... View more
‎Oct 30, 2009
09:50 AM
How would i do a dump of that service ? If i can do that it would be a lot easier but i cant figure out how. I manage to get it in HTML format and save it there must be a way to get it in XML
... View more
‎Oct 30, 2009
06:50 AM
Is there a way i can save the result in an HTML file then ?
... View more
‎Oct 30, 2009
04:34 AM
Hi, I use a web service (use to be CFTTP and was working fine thanks to Ian Skinner) for a VIN decoder (Vehicle Identification Number) they charge per request and i can get all the car options in 3 language, they provided me with the CFM file i need to do the request and i got that part to work fine. but i need to save the XML result so i can have all the options on our server and not having to request it everytime we need to see it. So this is the CFM that gets the vin from the web service. I need to know if it is possible to get the XML out of there and save it to a file. <cffunction name="isNull" returntype="string" output="false"> <cfargument name="test" type="variableName" required="Yes"> <cfif isDefined(test)> <cfreturn Evaluate(test)> <cfelse> <cfreturn ""> </cfif> </cffunction> <cfscript> webService = createObject("webservice", "MY_VIN_WS"); countryCode = "US"; languageCode = "en"; if( IsDefined("url.countryCode") ){ countryCode = url.countryCode; } else { countryCode = "US"; } if( IsDefined("url.languageCode") ){ languageCode = url.languageCode; } else { languageCode = "en"; } if( languageCode EQ "es" AND countryCode EQ "CA" ){ languageCode = "en"; } if( languageCode EQ "fr" AND countryCode EQ "US" ){ languageCode = "en"; } accountInfo = StructNew(); accountInfo.accountNumber = "MY_ACCOUNTx"; accountInfo.accountSecret = "MY_PASSWORD"; accountInfo.locale = StructNew(); accountInfo.locale.language = languageCode; accountInfo.locale.country = countryCode; version = ""; dataVersionsRequest = StructNew(); dataVersionsRequest.accountInfo = accountInfo; dataVersions = webService.getDataVersions(dataVersionsRequest); for (i = 1; i LTE ArrayLen(dataVersions); i=i+1) { if (dataVersions.country EQ "US"){ version = dataVersions.country & " " & dataVersions.build & " (" & DateFormat(dataVersions.date) & " " & TimeFormat(dataVersions.date) & ")"; } } </cfscript> <cfif IsDefined("url.vin")> <cfscript> returnParameters = StructNew(); returnParameters.useSafeStandards = IsDefined("url.useSafeStandards"); returnParameters.excludeFleetOnlyStyles = IsDefined("url.excludeFleetOnlyStyles"); returnParameters.includeAvailableEquipment = IsDefined("url.includeAvailableEquipment"); returnParameters.includeExtendedDescriptions = IsDefined("url.includeExtendedDescriptions"); returnParameters.includeExtendedTechnicalSpecifications = IsDefined("url.includeExtendedTechnicalSpecifications"); returnParameters.includeRegionSpecificStyles = IsDefined("url.includeRegionSpecificStyles"); returnParameters.includeConsumerInformation = IsDefined("url.includeConsumerInformation"); returnParameters.enableEnrichedVehicleEquipment = false; vinRequest = StructNew(); vinRequest.accountInfo = accountInfo; vinRequest.vin = url.vin; vinRequest.manufacturerModelCode = url.manufacturerModelCode; vinRequest.trimName = url.trimName; vinRequest.wheelBase = val("url.wheelBase"); vinRequest.manufacturerOptionCodes = ListToArray(url.manufacturerOptionCodes, ","); vinRequest.equipmentDescriptions = ListToArray(url.equipmentDescriptions, ","); vinRequest.secondaryEquipmentDescriptions = ListToArray(url.secondaryEquipmentDescriptions, ","); vinRequest.exteriorColorName = url.exteriorColorName; vinRequest.returnParameters = returnParameters; vehicleInfo = webService.getVehicleInformationFromVin(vinRequest); showInstallCause = IsDefined("url.includeCauseChain"); </cfscript> </cfif> I also attach the entire file if you need to see it Help would be greatly appreciated
... View more
‎Oct 29, 2009
03:49 AM
Hi again, They just switch me to a web service, I played with it a little but now i got a new problem, I can get the data but i cant find a way to wrtite the file to a XML document. When i was calling thre service i used <cfset xmlObj = xmlParse(cfhttp.fileContent)> <cfset XMLText=ToString(xmlObj)> <cffile action="write" file="C:\inetpub\www\mystuff\#VIN#.xml" output="#XMLText#"> To write the XML file from that vin number but with a Web service i cant figure out how to doit. This is what the service call looks like : <cfscript> webService = createObject("webservice", "myservicename"); countryCode = "CA"; languageCode = "fr"; accountInfo = StructNew(); accountInfo.accountNumber = "myaccount"; accountInfo.accountSecret = "mypassword"; accountInfo.locale = StructNew(); accountInfo.locale.language = languageCode; accountInfo.locale.country = countryCode; version = ""; dataVersionsRequest = StructNew(); dataVersionsRequest.accountInfo = accountInfo; dataVersions = webService.getDataVersions(dataVersionsRequest); for (i = 1; i LTE ArrayLen(dataVersions); i=i+1) { if (dataVersions.country EQ "US"){ version = dataVersions.country & " " & dataVersions.build & " (" & DateFormat(dataVersions.date) & " " & TimeFormat(dataVersions.date) & ")"; } } </cfscript> Does this create a new Web service everytime ? I know it creates an object but how do i save it to ans XML file ? I sent you the entire sample file in a PM. The data i get is the same then in the previous XML file.
... View more
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more
Copyright © 2025 Adobe. All rights reserved.
AdChoices