User Profile

Collapse

Profile Sidebar

Collapse
cfmx2008
cfmx2008
Last Activity: Jul 21 '08, 02:34 PM
Joined: Jan 28 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • cfmx2008
    replied to Upper or Lower case
    Thanks. I really appreciate your help.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to Upper or Lower case
    Thank you, but how can I check the case of the original data?
    See more | Go to post

    Leave a comment:


  • cfmx2008
    started a topic Upper or Lower case

    Upper or Lower case

    Hi Guys,
    I hope you could help me to solve this problem. Here it is: I have a huge table of data. Some data are Lower case and some are upper case. these data could be changed by agents, But I want to keep the case. For example: if data is Lower case and it changed to upper case at the time of change it should be lower case again. I know sounds terrible, but this is the problem. any hints will be appreciated. thanks
    See more | Go to post

  • cfmx2008
    replied to add date
    Thank you so much. it works. your're great.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to add date
    so it should be:

    DateAdd("dd", 1 , "#url.calldate# ")...
    See more | Go to post

    Leave a comment:


  • cfmx2008
    started a topic add date

    add date

    Hi,

    I have a date url.calldate. My calldate is like 05/01/08 and I want the values for 1 day after this day too. I used
    DateAdd("#url.c alldate#", 1, "mm/dd/yy")

    I receive error and I need your help.
    See more | Go to post

  • cfmx2008
    started a topic Radio button validation

    Radio button validation

    Hi guys,
    I'm not good at javascript. I have a series of radio buttons on my form and it's required field. One has to be checked. Do you have any javascript code for it? Please help.
    See more | Go to post

  • cfmx2008
    replied to ColdFusion Function and JavaScript
    What about my new window's attribute?...
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to ColdFusion Function and JavaScript
    Ohhhhhh Daaaa. Thanks so much. It works!...
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to how can i import excel data into mysql
    No there is no Copyright. it's on the web for free. I used it befor so I thought it may be hany....
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to how can i import excel data into mysql
    copy and past the codes below save it as read.cfm:

    [CODE=cfm]<!--- default values --->
    <cfparam name="form.Inpu tExcelFile" default="">
    <cfparam name="form.Star tCol" default="A">
    <cfparam name="form.EndC ol" default="0">
    <cfparam name="form.Star tRow" default="1">
    <cfparam name="form.EndR ow"...
    See more | Go to post
    Last edited by acoder; Mar 13 '08, 03:02 PM. Reason: Added code tags

    Leave a comment:


  • cfmx2008
    started a topic ColdFusion Function and JavaScript

    ColdFusion Function and JavaScript

    Hi everyone,

    I have a coldfusion form (ReportMenu.cfm ) that the action page is itself as below:
    [CODE=cfm]<cfform action="/cfreport/ReportMenu.cfm" method="POST" enctype="multip art/form-data">
    [/CODE]
    and it's button:

    [CODE=cfm]<input type="Submit" value="View Report" class="button" name="submit" >
    <!---...
    See more | Go to post
    Last edited by acoder; Mar 13 '08, 03:35 PM. Reason: Added code tags

  • cfmx2008
    replied to trim and REReplace
    You’re awesome!!!!!
    It's done exactly the way I wanted. Thank you sooooooo much for giving me your time. I really appreciate it.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    Thanks. But this replacement works only for this example. Did you get the chance to see the exact pattern I've posted? I need the "-" be in the middle of the numbers after cleaning. ^0+ works for START RANGE (10 bytes) But not for the END RANGE (10 bytes) because it will remove the 0s even if the start number is 10 or 100.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    I Got the exact pattern:

    Street number ranges for near matches are returned in the following fixed-width format:

    START RANGE (10 bytes) + END RANGE (10 bytes) + OEB code (1 byte) left-padded with zeros



    Secondary (apartment) ranges for near matches are returned in the following fixed-width format:

    START RANGE (8 bytes) + END RANGE (8 bytes) + OEB code (1 byte) left-padded...
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    Here is the code:
    <cfset StreetNumber = REReplace(#Stre etNumber#,"^0+([1-9]+)(0+)([1-9]+)([A-Z]?)$","$1-$3", "all")>

    it will replace the whole StreetNumber by $1-$3. I tried it with trim() as well. It does the same. #StreetNumber# is 000000000100000 00099B
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    Cool. I'll try it and let you know.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    In this example I have 9 0s. but remember the 1st 10 digits are belong to 1st number. In this case number is 1 so we have 9 0s left. The real number could be 111 then we will have 7 0s before the number.
    See more | Go to post

    Leave a comment:


  • cfmx2008
    replied to trim and REReplace
    Agree. I have this problem too. The pattern is : 10 digits at the beginning of the string (for the 1st number) + 10 more digits after (for the 2ed number) + 1 alphabet.

    I think we should clean the 4 or 5 first digits (0s) from the beginning of the string then leave the next 5 digits then insert our "-" and again clean the 4 or 5 next 0s and leave the rest and again clean the alphabet. What do you think?
    See more | Go to post

    Leave a comment:


  • cfmx2008
    started a topic trim and REReplace

    trim and REReplace

    Hi,

    I have this number: 000000000100000 00099B I need to remove the 0s before 10 and 99 and the alphabets like B after 99. I also need to replace the 0s between 10 and 99 by "-". I don't know how to use trim and Rereplace for these two numbers in this string. Any Idea? I appreciate it. Thanks
    See more | Go to post
No activity results to display
Show More
Working...