Adobe Community : All Content - All Communities

100% zoom is too small on screen

forums_noreply@adobe.com — Sun, 30 Jun 2013 17:34:09 GMT

Hello, I'm using photoshop CC on amacbook pro retina. I mainly use photoshop for web design and when I open a document that is 300x200 px, the 100% view is too small on screen. Any ideas, It was this way on PS cs6 also before I upgraded. I just tried to delete the prefs file and restarted PS and it did not change. I have also tried to change my screen resolution to "best for retina" and it is still the same.

Steve

Cfspreadsheet

forums_noreply@adobe.com — Sun, 19 Oct 2014 01:18:26 GMT

Hi, I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:

The spreadsheet could look like this:

First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern

Joe Smith Sample 12 main denver co 80513 concerns go here

My question is this, if Joe has more than 1 concern I get multiple rows with joe's info...is there a way I can loop the concerns and only have 1 row for joe?

Thanks,

Steve

Can you specify the columns that get written to a spreadsheet when using the query attribute of cfspreadsheet?

forums_noreply@adobe.com — Sat, 31 May 2014 18:51:03 GMT

Hello, I wanted to see if you can control which columns from a query get written to a excel spreadsheet. I have some items in my query that I do not want in the spreadsheet but need for my query, if that makes sense.

Thanks.

Steve

upload files to os x with cffile

forums_noreply@adobe.com — Sat, 29 Dec 2012 01:05:55 GMT

I'm working in my dev environment on my macbook pro. It is setup like this:

CF 10 and sql server running on parallels 8. I run cf builder on OS X along with Cornerstone for Subversion control All my web files are located on my mac os x hard drive.

My web app has several forms in which you can upload files. I can not seem to figure out the right path to put in the destination field for cffile. I have tried /path/to/location/ format but it does not work. Any ideas?

Thanks in advance.

CFspreadsheet issue

forums_noreply@adobe.com — Sat, 11 Aug 2012 22:33:06 GMT

Hello, I have a question about CFspreadsheet....

I'm reading a spreadsheet and inserting the data into a SQL server DB....everything works fine unless 1 of my columns in the spreadsheet is blank. I'm getting the following error:

Element PHONE is undefined in EXCELQUERYBYNAME.

I tried the put a cfif isdefined to see if that would solve it but no luck....same error message. How can I handle this issue? My cfquery is below:

INSERT into contactrecord

(

contact_date,

fname,

lname,

address,

city,

state,

zip,

county,

<cfif isDefined(excelQueryByName.phone)>phone,</cfif>

<cfif isDefined(excelQueryByName.title)>title,</cfif>

<cfif isDefined(excelQueryByName.organization)>organization,</cfif>

<cfif isDefined(excelQueryByName.email)>email,</cfif>

<cfif isDefined(excelQueryByName.general_comments)>general_comments,</cfif>

<cfif isDefined(excelQueryByName.fname2)>fname2,</cfif>

<cfif isDefined(excelQueryByName.lname2)>lname2,</cfif>

mailing,

input_by,

input_date,

input_time,

input_by_id,

country,

sh_rating

)

Values(

'#Trim(excelQueryByName.contact_date)#',

'#Trim(excelQueryByName.fname)#',

'#Trim(excelQueryByName.lname)#',

'#Trim(excelQueryByName.address)#',

'Trim(excelQueryByName.city)#',

'#Trim(excelQueryByName.state)#',

'#Trim(excelQueryByName.zip)#',

'#Trim(excelQueryByName.county)#',

<cfif isDefined(excelQueryByName.phone)>'#Trim(excelQueryByName.phone)#',</cfif>

<cfif isDefined(excelQueryByName.cell)>'#Trim(excelQueryByName.cell)#',</cfif>

<cfif isDefined(excelQueryByName.fax)>'#Trim(excelQueryByName.fax)#',</cfif>

<cfif isDefined(excelQueryByName.title)>'#Trim(excelQueryByName.title)#',</cfif>

<cfif isDefined(excelQueryByName.organization)>'#Trim(excelQueryByName.organization)#',</cfif>

<cfif isDefined(excelQueryByName.email)>'#Trim(excelQueryByName.email)#',</cfif>

<cfif isDefined(excelQueryByName.general_comments)>'#Trim(excelQueryByName.general_comments)#', </cfif>

<cfif isDefined(excelQueryByName.fname2)>'#Trim(excelQueryByName.fname2)#',</cfif>

<cfif isDefined(excelQueryByName.lname2)>'#Trim(excelQueryByName.lname2)#',</cfif>

'#Trim(excelQueryByName.mailing)#',

'#Trim(excelQueryByName.input_by)#',

'#Trim(excelQueryByName.input_date)#',

'#Trim(excelQueryByName.input_time)#',

'#Trim(excelQueryByName.input_by_id)#',

'#Trim(excelQueryByName.country)#',

'#Trim(excelQueryByName.sh_rating)#'

)

</cfquery>

Thanks in Advance.

Onclick with checkboxes and add value to a string

forums_noreply@adobe.com — Fri, 10 Feb 2012 17:51:53 GMT

Hello, I have a search results page that has a checkbox next to each returned record. Is there a way to append its value to a string via an Onclick function? My search results page uses paging as well, that is why I was wondering if it can be done as they click the checkbox.

cfloop over dynamically generated check boxes and radio buttons

forums_noreply@adobe.com — Thu, 26 Jan 2012 22:34:28 GMT

Hello, I have a page where a user can select a project, via a checkbox then select a radio buttion with the following options "Support, Oppose, Not Known". The form fields are dynamically generated, can be anywhere from 1 to many. here is a screenshot:

A user has to at least select 1 but can select many. The checkbox names are dynamically generated and follow this naming convention:

f_project_1

f_project_2

the radio buttons are named similar:

f_support_1

f_support_2

So, on my submit page I need to loop through each of these and insert into my database. before I just had a select box with projects(no support, oppose stuff) and I used the following code and it worked great.

INSERT into contactrecord_project

(contactrecord_project_id,

contactrecord_project_nm,

project_support)

Values ('#newid#','#projectlist#',)

</CFQUERY>

</cfoutput>

</CFLOOP>

I'm just brain dead today, can someone please help me out with looping over the list and getting it inserted into my database