Adobe Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
About ammarq48536816
since
‎Apr 12, 2015
‎Sep 22, 2022
ammarq48536816
New Here
8
Posts
0
Upvotes
0
Solutions
‎Sep 21, 2019
09:18 PM
I'm having an issue with uploading or looping through the the file names of my images to my database table. I am able to select various images and upload the selected image on my local machine to a specific folder that I designate. After the image files are put into my folder, I am having some difficulties because I want to insert the file names of the images that I just inserted into my folder, into my database. I'm trying to use the cffile parameters to do that. My question: Being that it is multiple files being uploaded at once, do I need to do a cfloop on a cfquery insert in order to capture and insert the names into my database? My attempt at the code is below. The upload work just fine. But It chokes out at the insert portion. What do you think could be the issue? <cfparam name="form.fileUpload3" default=""> <cfif len(trim(form.fileUpload3))> <cffile action="uploadall" fileField="fileUpload3" destination="#cookie.c.webpathmultipleimages#" accept = "image/jpeg, image/png, image/jpeg" nameconflict="makeunique"> <!---This is where i'm running into my issue---> <cfloop INDEX="i" LIST="#Form.fileUpload3#"> <cfquery name="addtoimage"> insert into image (imaid, imacomid, imaname) Value ( '00', '#cookie.communityID#', '#file.clientfile#') </cfquery> </cfloop> </cfif> Thanks for any help you can provide...
... View more
‎Sep 15, 2018
04:37 PM
Wolfshade, BKBK, My apologies for just getting back to reply to the thread. I suffered a sudden loss of a family member. i will tryout the suggestions within the next few days. Thank you guys all for your help.
... View more
‎Sep 05, 2018
12:01 PM
Good morning, i am using CF2016 on a window PC. At my job i have the role of adding new hires into our card reader box so that new employees can enter into our office. I often can get up to 10 new employee request per day. I devised a rather complicated way of converting each character of their last name into a number format so that i can quickly punch their name info into nine-digit keypad of the card reader box. The letter arrangement of the key pad is similar a touch-tone phone. I currently have two Cf pages to do what i need. The first page is a basic form with 6 text boxes that will only allow 1 character per box for the person last name. the second page is a series of conditional statements that will assign a numerical value to each character. What i want to accomplish is to have one text box that i can enter the entire last name of the new employee and then have Coldfusion separate each character from the input box of the previous page and assign then display the same numerical values. Below is an abbreviated version of my current code for each page. i have enter last name of "Nelson" into each individual box. Is there a simpler way to do this? <!---First Page. The Form---> <form class="form-inline"action="fob_assign1.cfm"enctype="application/x-www-form-urlencoded"name="form1"method="post"> <form class="form-inline"> <input type="text"name="box1" maxlength="1"tabindex=1 size="4"> <input type="text"name="box2" maxlength="1"tabindex=2 size="4"> <input type="text"name="box3" maxlength="1"tabindex=3 size="4"> <input type="text"name="box4" maxlength="1"tabindex=4 size="4"> <input type="text"name="box5" maxlength="1"tabindex=5 size="4"> <input type="text"name="box6" maxlength="1"tabindex=6 size="4"> <div class="form-group"> <button class="btn btn-primary btn-lg btn-block" type="submit" value="Submit">Submit</button> </div> </form> <!---Second Page. Condition Statements---> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <cfif '#form.box1#' EQ "A">2# <cfelseif '#form.box1#' EQ "B">22# <cfelseif '#form.box1#' EQ "C">222# <cfelseif '#form.box1#' EQ "D">3# <cfelseif '#form.box1#' EQ "E">33# <cfelseif '#form.box1#' EQ "F">333# <cfelseif '#form.box1#' EQ "G">4# <cfelseif '#form.box1#' EQ "H">44# <cfelseif '#form.box1#' EQ "I">444# <cfelseif '#form.box1#' EQ "J">5# <cfelseif '#form.box1#' EQ "K">55# <cfelseif '#form.box1#' EQ "L">555# <cfelseif '#form.box1#' EQ "M">6# <cfelseif '#form.box1#' EQ "N">66# <cfelseif '#form.box1#' EQ "O">666# <cfelseif '#form.box1#' EQ "P">7# <cfelseif '#form.box1#' EQ "Q">77# <cfelseif '#form.box1#' EQ "R">777# <cfelseif '#form.box1#' EQ "S">7777# <cfelseif '#form.box1#' EQ "T">8# <cfelseif '#form.box1#' EQ "U">88# <cfelseif '#form.box1#' EQ "V">888# <cfelseif '#form.box1#' EQ "W">9# <cfelseif '#form.box1#' EQ "X">99# <cfelseif '#form.box1#' EQ "Y">999# <cfelseif '#form.box1#' EQ "Z">9999# </cfif><br> <cfif '#form.box2#' EQ "A">2# <cfelseif '#form.box2#' EQ "B">22# <cfelseif '#form.box2#' EQ "C">222# <cfelseif '#form.box2#' EQ "D">3# <cfelseif '#form.box2#' EQ "E">33# <cfelseif '#form.box2#' EQ "F">333# <cfelseif '#form.box2#' EQ "G">4# <cfelseif '#form.box2#' EQ "H">44# <cfelseif '#form.box2#' EQ "I">444# <cfelseif '#form.box2#' EQ "J">5# <cfelseif '#form.box2#' EQ "K">55# <cfelseif '#form.box2#' EQ "L">555# <cfelseif '#form.box2#' EQ "M">6# <cfelseif '#form.box2#' EQ "N">66# <cfelseif '#form.box2#' EQ "O">666# <cfelseif '#form.box2#' EQ "P">7# <cfelseif '#form.box2#' EQ "Q">77# <cfelseif '#form.box2#' EQ "R">777# <cfelseif '#form.box2#' EQ "S">7777# <cfelseif '#form.box2#' EQ "T">8# <cfelseif '#form.box2#' EQ "U">88# <cfelseif '#form.box2#' EQ "V">888# <cfelseif '#form.box2#' EQ "W">9# <cfelseif '#form.box2#' EQ "X">99# <cfelseif '#form.box2#' EQ "Y">999# <cfelseif '#form.box2#' EQ "Z">9999# </cfif><br> ....... this continues on until the 12th box </cfif> <!---Final Display---> Below are the numbers on the key pad that i will enter for the last name "Nelson" is as follows N = 66# E = 33# L = 555# S = 7777# O = 666# N = 66#
... View more
‎Apr 05, 2018
07:13 AM
Thank you for your help.
... View more
‎Apr 04, 2018
08:55 PM
Dave, Thank you for clearing up my 2nd question. For my 1st question, I guess what I'm asking is does the file extension that the cfschedule itself is written in, need to be saved as a ".CFM" file or a ".dwt.cfm" and does it matter where that same cfschedule file stored?
... View more
‎Apr 04, 2018
06:05 PM
good morning, i've been using CF for about 1.5 years. I'M using Coldfusion 2016 in a windows PC. I'm trying to figure out the location to save a <cfschedule> document. 1 Should the file be saved as a regular .cfm file or do I save it as a template ".dwt.cfm" file and put it into the template folder of my file directory? The reason is that I am not getting any thing to fire-off 2. My second question is: can multiple <cfschedule> code be placed inside of the same coldfusion file? Below is my code that I used to point to the file to execute... <!-- TemplateBeginEditable name="head" --> <!--- This read-only example schedules a task. To run the example, remove the comments around the code and change the startDate, startTime, url, file, and path attributes to appropriate values. ---> <cfschedule action = "update" task = "ove3r0" operation = "HTTPRequest" url = "www.studentlt.com\scheduled_tasks\over30.cfm" startDate = "3/31/18" startTime = "6:00 AM" interval = "86401" resolveURL = "yes" publish = "Yes" file = "sample.html" path = "D:\home\studentlt.com\wwwroot\SR\scheduled_tasks\" requestTimeOut = "600"> <!-- TemplateEndEditable -->
... View more
‎Apr 13, 2015
11:04 AM
Thank you for your reply. I want to do a query that will collect and list the primary id's of all of my students who are currently inactive. The intent of the is to contain the studentID's for later insertion into another table entitled "student_attendance". The goal is To insert Each ID's consecutively until the #list1# is exhausted. This query will run every 30 days or so. So it may be 10, 15, 20 at a time that is being inserted with just one query. When the insert is executed the results looks like the following: Stuid Name 23 Jonathan 23 Jonathan 23 Jonathan I want it to execute like this: Stuid Name 23 Jonathan 34 Alfred 5 Harry Am I doing something wrong?
... View more
‎Apr 12, 2015
12:38 PM
‌ggood morning, i am new to This forum. I am working on a PC, using MySQL and Coldfusion 9. The query below does a multiple row insert just fine with one problem. The query is inserting the same ID of one of my students the number of times that I specify. Is there a way to loop through the insert so that all of the different ID's of the inactive student are inserted for each new row? Am I missing something obvious? <cfquery name="maxID" datasource="master"> select max(stuid) as maxid from student </cfquery> <cfquery name="student" datasource="master"> select count(stuid) as inactive_number from name where type = 'senior' AND squadlt = '#session.user_id#' AND CITY = 'richmond' AND STATUS = 'i' order by stuid </cfquery> <cfquery name="student2" datasource="master"> select stuid, fname as name from name where type = 'senior' AND squadlt = '#session.user_id#' AND CITY = 'richmond' AND STATUS = 'i' order by stuid </cfquery> <cfset initialmaxid1 = (#maxID.maxid# + 1)> <cfset initialmaxid2 = (#initialmaxid1# + #student.inactive_number#)> <cfset list1 = "#stuid#"> <cfloop from="#initialmaxid1#" to="#initialmaxid2#" index="i"> <cfquery name="insertabsentee" datasource="master"> INSERT INTO student_attendance (stuid, name) VALUES (#i#,'#list1#') </cfquery> </cfloop>
... View more
Copyright © 2024 Adobe. All rights reserved.
AdChoices