User Profile

Collapse

Profile Sidebar

Collapse
taunt
taunt
Last Activity: Jan 17 '15, 12:28 AM
Joined: Jan 11 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • taunt
    started a topic cfupdate always in upper case?

    cfupdate always in upper case?

    OK now I'm having issues when an item is edited. I got the new items to work in upper case. Now I can't get it to covert the edited field to alway be in upper case. Here's the coding: <cfupdate Datasource="#da tasource#" tablename="Item s" formfields="Ite mID,Artist>. I tried both Ucase(Artist) and UPPER(Artist). Ucase has no errors, but doesn't do anything and UPPER errors out. How would I go about adding always upper...
    See more | Go to post

  • taunt
    replied to Add field always in upper case?
    Got it I needed to use UCase.
    See more | Go to post

    Leave a comment:


  • taunt
    started a topic Add field always in upper case?

    Add field always in upper case?

    Hello I have a Coldfusion page that goes to a sql 2008 server. I'm trying to make it convert what ever the user enters to all upper case. So far I tried this Values ('#Form.UPPER(A rtist)#', but so far it errors out saying "The UPPER method was not found". How would I go about so it will change anything in the Artist field to upper case?

    Thanks
    See more | Go to post

  • taunt
    started a topic check box Coldfusion 9 question

    check box Coldfusion 9 question

    Hello i"m trying to use two check boxes when selected I want it to change how it does the order by. So far I have this:

    Code:
    <CFIF isDefined("Form.artist") IS "YES">
    ORDER BY products.artist
    </CFIF>
    
    <CFIF isDefined("Form.qoo") IS "YES">
    ORDER BY products.QtyOnOrder DESC
    </CFIF>
    This also errors out. What am I doing wrong?...
    See more | Go to post
    Last edited by acoder; May 23 '12, 01:35 PM.

  • taunt
    replied to Default radio button
    Speaking of the session scope. I just looked at it and:

    <cfparam name="Session.P Type" default="edit">

    So it's set as the default. My issue is when the page loads it won't go back to edit. Do I need to do a onload maybe?
    See more | Go to post

    Leave a comment:


  • taunt
    started a topic Default radio button

    Default radio button

    Hello I'm trying to make a sertain radio button the default. How would I get about doing this? Here is my coding so far:

    Code:
    <td>	
        	Edit&nbsp;<input type="radio" name="Ptype" value="Edit"<cfif #Session.PType# IS "Edit">CHECKED</cfif> onClick="this.form.submit();">&nbsp;&nbsp;&nbsp;Print&nbsp;<input type="radio" name="Ptype"
    ...
    See more | Go to post
    Last edited by acoder; Jan 18 '12, 02:58 PM. Reason: Added [code] tags

  • taunt
    started a topic More than 6 months query

    More than 6 months query

    Hello I have a table that looks like this:

    Code:
    <td><div align="center"><strong><cfset dtDiff = (qsearch.ReceiptDate - qsearch.LAST_SOLD) />
       #DateDiff( "yyyy", "12/30/1899", dtDiff )# Years,
    #DateFormat( dtDiff, "m" )# Months,
    #DateFormat( dtDiff, "d" )# Days,
       </strong></div></td>
    Which returns:
    -2 Years,...
    See more | Go to post
    Last edited by acoder; Jan 14 '12, 06:10 PM. Reason: Added [code] tags
No activity results to display
Show More
Working...