Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
srouse72
Explorer
srouse72
Explorer
Activity
‎Apr 18, 2024
03:06 PM
I didn't have any luck with above solutions, but I did figure out a better way to explain what I'm needing to do. I need to generate the QR Code, save it to a folder and then set a variable with the information that I can call from another piece of code. Generate in tst2web and then call the variable from the div starting at line 77 in the tstWhite code.
... View more
‎Mar 26, 2024
06:58 AM
Thank you - I'll give that a try.
... View more
‎Mar 26, 2024
04:47 AM
I found a QR code generator to use, and it has worked great since I added it - until Sunday and not it isn't working. I copied the URL into a browser to make sure that the generator was working and it is, but the codes aren't printing on the badge card. <cfhttp method="get" url="https://api.qrserver.com/v1/create-qr-code/?size=150x150&data='https://www.ohrc.org/binkley/badgeCard/PDFs/#replace(badgPhotoName, '.jpg', '.pdf', 'All')#'" getasbinary="yes" charset="utf-8"/> <cfif isImageFile("#cfhttp.fileContent#")> <cfset myImage=imageNew("#cfhttp.fileContent#")> <cfset isImage ("#cfhttp.fileContent#")> <cfimage action="write" source="#cfhttp.fileContent#" destination="c:/workgroups/webdata/badgecards/qr/#Replace(BadgPhotoName,'.jpg','.png','All')#"> </cfif> This is the code that is suddenly not working. Any suggestions would be greatly appreciated.
... View more
‎Feb 28, 2024
08:25 AM
3 Upvotes
When I took over the care of a CF intranet site, the Google chart API was being used to generate QR codes that are on employee badges; this won't be working for much longer and I need to find a replacement. <cfimage source="#myImage#" destination="c:/workgroups/webdata/badgecards/#BadgPhotoName#" action="write" overwrite="Yes"> <cfhttp url="https://chart.apis.google.com/chart?chs=160x160&cht=qr&chl=#urlencodedformat('http://www.ohrc.org/binkley/BadgeCard/PDFs/#Replace(BadgPhotoName,'.jpg','.pdf','All')#')#&chld=H|0" result="qrcode" getasbinary="yes"> <cfimage action="write" destination="c:/workgroups/webdata/badgecards/qr/#Replace(BadgPhotoName,'.jpg','.png','All')#" source="#qrcode.filecontent#" overwrite="yes"> This is what the code looks like I found a new generator, but I haven't been able to get it to work correctly. The generator that I was looking at is goqr.me/api, but I was wondering if Adobe has something like that, that I could use?
... View more
‎Jan 12, 2021
09:40 AM
With Flah being EOL, I was wondering if anyone could give some advice on a problem that I have. I have an older application written in ColdFusion 9 that is used in conjunction with a web camera to take pictures to make licensing badges. Since Flash is being blocked we can't make badges; is there another product that I could use or some programming that I could add to get around using Flash?
... View more
‎Apr 09, 2020
01:43 PM
Hello Everyone; I'm hoping someone can give me some guidance on the issue that I'm having. I am working on some code for a photo badge card. After the photo is taken I click a print preview button that opens the badge in a PDF of the badge and I print it from there. However, I get the following error: The Base64 data is not in proper format. Data should be in the format understood by the <img> tag in HTML, which is "data:image/jpg;base64,[base64 data]" <cfset myImage = ImageReadBase64("#form.xBase64PhotoString#")>
<cfimage source="#myImage#" destination="c:/workgroups/webdata/badgecards/#BadgPhotoName#" action="write" overwrite="Yes"> This is my first experience with photos so I would appreciate any help that I can get. Please let me know if you need anymore information.
... View more
‎Mar 16, 2020
03:37 PM
The minute drop down works fine in CF9, but my development server has 2018 on it because we are looking at upgrading. However, I am getting a runtime error on the minute dropdown in 2018. My problem is, I can't figure out how to set a number range for the minutes. <cfset fullStartDate=CreateDateTime(DateFormat(form.STARTDATE,'yyyy'), DateFormat(form.STARTDATE,'mm'), DateFormat(form.STARTDATE,'dd'),Form.STARTHOUR, Form.STARTMINUTE,0)> This is the code that works just fine in CF9.
... View more
‎Nov 01, 2019
11:53 AM
Thank you so much for your help - I changed IsDefined() to StructKeyExists and that cleared the errpr that I was getting. Thank you very much
... View more
‎Nov 01, 2019
07:23 AM
I am getting this error as well under differenct circumstances and was hoping to get some guidance. Parameter 1 of function IsDefined, which is now Form.4316664, must be a syntactically valid variable name. This is the exact error that I am getting and the code snippet below is the code that I beleive is throwing the error. <cfloop list="#Form.INVOICEITEMS#" index="i">
<cfoutput>
<cfif isDefined('Form.#i#')>
<cfquery name="getGameStatus" datasource="Binkley">
Select gamingSplit From tdL_LTYPES Where LIC_CODE='#ListGetAt(form[i],1,'|')#'
</cfquery> I've only had ownership of the program since June and this is something that the person I took ever for didn't cover with me. This has been working until recently; so any guidance would be greatly appreciated.
... View more
‎Oct 15, 2019
03:15 PM
Thanks you for the quick response. Although I had hoped to not have a rewrite, I figured that is what I would have to do.
... View more
‎Oct 15, 2019
07:34 AM
I inherited a program that I've had to modify and I am stuck on adding conditions to. I have a very long <cfset> statement that is made up of a table and several divs. <td style="border-bottom: thin solid black">
<div align="left" class="HeadingTwo">
#DollarFormat(Session.WorkOrderReceipt.amount)# #Session.WorkOrderReceipt.Instrument# #Session.WorkOrderReceipt.CheckNumber#
</div>
</td> This div shows the dollar amount on the receipt and if it's paid with a check then it shows that and then the check number, but since we've added credit/debit cards it would need to show that information as well. So basically, if #Session.WorkOrderReceipt.instrument eq check# then #Session.WorkOrderReceipt.CheckNumber# would be correct, but if #Session.WorkOrderReceipt.Instrument eq creditDebitCard# then #Session.WorkOrderReceipt.creditDebitNumber# would be correct. There is another div that would basically be the same with the exception of the dollar amount. I'm not sure how to handle this, and any suggestions would be greatly appreciated.
... View more
‎Aug 21, 2019
05:26 AM
Thanks you Dave. I created a new login and changed the database owner to the new login and it worked like a charm!
... View more
‎Aug 20, 2019
05:10 PM
Ok, I set SQL Server to mixed-mode authentication, and the database is attached to my agency user account (if that is what you mean about creating a user account for my application). Do I need to add a connection string to the advanced settings, or a validation query? I really feel like I'm going around in circles.
... View more
‎Aug 20, 2019
03:30 PM
I did not set up a login/password for the DSN. I did not set up a login/password for SQL server. I use my Windows authentication for SSMS. If I need to set up a username and password in SQL then I'll do that.
... View more
‎Aug 20, 2019
01:56 PM
Yes, I deliberately named the data source the same thing as my database. However, I never set up a username and password for SQL Server. In SSMS when I connect to the server it uses Windows Authentication but I've tried those credentials and it doesn't work.
... View more
‎Aug 20, 2019
11:18 AM
I realized after further study that the connection string that was in CF Admin was pointing to the master DB instead of Blinkey. I changed that and now I getting the error below: Connection verification failed for data source: Blinkey java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Blinkey" requested by the login. The login failed. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Blinkey" requested by the login. The login failed. I read somewhere that if you set the authentication to both Windows and SQL authentication (in SSMS) then you don't enter a username and password in CF Admin.
... View more
‎Aug 19, 2019
12:39 PM
The error was on the table name OWContacts. No, it is a different named database on a different server. Yes, I have tried prefixing the able name, and I pulled the code and put it in a test page. The data source that is being called is the default database in SQL and the schema is dbo.
... View more
‎Aug 19, 2019
10:36 AM
This is the query that I am trying to run and I am getting the above error <CFPARAM NAME="Form.UserLogin" default=" " TYPE="string"> <CFPARAM NAME="Form.UserPassword" default=" " TYPE="string"> <CFQUERY NAME="GetUser" DATASOURCE="Blinkey"> SELECT * FROM OWContacts WHERE UserLogin = '#Form.UserLogin#' AND UserPassword = '#Form.UserPassword#' </CFQUERY> <cfdump var="#GetUser#"> This query is for the login page of the intranet system that I am responsible for. I've read several threads trying to figure out the problem and as of yet haven't found a good answer. The code works in CF9, but I am trying CF2018 on my test server and I keep getting the error. I've checked the DSN information and the data source that is being called is marked as the default database for the login.
... View more
‎Aug 19, 2019
06:31 AM
Adam, I'm having this issue as well, and this is the first time I've set up ColdFusion on my own. I am the database owner and the only one with access to this install of CF. I wondering if I missed something in my setup. Where would I check the permissions?
... View more
‎Aug 14, 2019
12:01 PM
I am modifying a receipt screen where I need to make a text box required for certain options. I need the InstrumentNumber cell required for option values Check and CreditDebit, but I'm really new to ColdFusion programming and I'm not really sure how to do what I need to do. Any suggestions or help would be greatly appreciated. <td class="NormalCell"> <select name="Instrument"> <option value="Check">Check</option> <option value="Cash">Cash</option> <option value="CreditDebit">Credit/Debit</option> <option value="Other">Other</option> </select> </td> <td class="DataLabel" style="background: smokewhite;"> <div align="right">Instrument#:</div> </td> <td class="NormalCell"> <input type="Text" name="InstrumentNumber" size="12"> </td>
... View more
Copyright © 2025 Adobe. All rights reserved.
AdChoices