Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cfStarlight

    Updating records

    In the first query that retrieves the ticket information, just fix the cfsqltype to match the datatype of the Ticket_ID column in your db table. For example, if column type is "integer" use cf_sql_integer, etc. WHERE ticket_ID = <cfqueryparam value="#url.ticket_id#"...
  2. cfStarlight

    Updating records

    I think that only way that could happen is if you're running a different update statement than the one posted, or if all of the records have the same ticket_id value. Turn on debugging. What is the exact sql statement generated ? Also "numeric" isn't a valid cfsqltype. Take a look at the...
  3. cfStarlight

    Updating records

    Yes, you would. The query should use the URL.ticket_id value to get the information for the selected ticket. You can then output the query values in your form fields (textboxes, etc). <cfquery name="getTicket" datasource="yourDatasource" SELECT ticket_ID, date_created, employee...
  4. cfStarlight

    Updating records

    Modify the link code slightly. Close the anchor tag and use "=" between the parameter name (ticket_id) and value (#ticket_ID#). <td align="left"><a href="update.cfm?ticket_id=#ticket_ID#">#ticket_ID#</a></td>
  5. cfStarlight

    image resize with image.cfc

    Yes, if the upload/reload works without the other "stuff" then it must be a problem with the other "stuff" on that page.
  6. cfStarlight

    image resize with image.cfc

    So you're saying the same works on CF8 but not on the other site (MX7)? Did you try the simple test in my last post?
  7. cfStarlight

    image resize with image.cfc

    Odd. Did you try a resize only test with two images? I typed this quickly so check the variable names carefully. <cfset myImage = CreateObject("Component", "iEdit")> <cfset myImage.SelectImage(pathToTestImage1)> <cfset myImage.scaleToFit(250,250)> <cfset myImage.output( pathToTestImage1...
  8. cfStarlight

    image resize with image.cfc

    Are you saying the resize code works on a single image, but not for multiple images.. or that resizing doesn't work at all? Also, does the component allow you to read/write to the same file name? Some components force you to use a different name when resizing.
  9. cfStarlight

    image resize with image.cfc

    What a pain in the neck you are! Just joking ;) IMO posting a resolution is a good thing, even if you solved your own problem. Never know when it might help someone else. Anyway, can you post the version of CF you are using? Maybe someone can try the code when time allows. They might be able...
  10. cfStarlight

    Loop Variable Scope

    Unless you're using the VAR scope, using a scoped variable should work, or you can use a conditional loop <cfset variables.count = 0> <cfloop from="1" to="15" index="variables.count"> <cfset count = count + 1> <cfoutput>the count is now #count#<br></cfoutput> </cfloop> <cfoutput>finshed...
  11. cfStarlight

    Query is too slow, using LIKE operator

    Thanks :) I thought it might be a typo, but just in case it wasn't I wanted to mention it.
  12. cfStarlight

    Question about Date Format

    Try <cfoutput>#DateFormat(now(), "mm/dd/yyyy")#
  13. cfStarlight

    Query is too slow, using LIKE operator

    As an aside, shouldn't your query be ..? <cfquery name="getObsv" datasource="#app.ds#"> SELECT a.observationnumber, a.observation, b.eventbegan, c.agencyname, e.sitename FROM observations a, inspections b, agency c, inspsites d, plantsites e WHERE a.eventid = b.inspectiontid...
  14. cfStarlight

    Multiple upload and rename with cffile

    The first thing I noticed is you're using overwriting the value of form.filename1 on the second upload. Also, the file names aren't guaranteed to be unique so you could overwrite the file that was uploaded and renamed in step 1 I don't think you should be using CLOB here. Likely you should be...
  15. cfStarlight

    Multiple upload and rename with cffile

    Can you post the relevant code?
  16. cfStarlight

    Dynamic form value

    In all recent versions you can use array notation to both set and get the values scopeName["variableName"] <cfset variables["Delivery_"& x &"_"& y] = "some value"> <input value="#variables['Delivery_'& x &'_'& y]#" name="delivery_#x#_#y#" type="text" size="4"> ...or.. <input...
  17. cfStarlight

    Trim

    Either extract the parameter from the URL structure, or use list functions with a delimiter of "=" #ListRest("question10=blah", "=")# ...or #ListLast("question10=blah", "=")#
  18. cfStarlight

    Using DateFormat in CFSELECT

    Yes, but afaik you cannot use it on "value" or "display" of a cfselect that uses "query". You have to format the "value" or "display" values beforehand (ie in the sql query)
  19. cfStarlight

    Using DateFormat in CFSELECT

    I thought UK was dd mm yyyy? ie day of month first Anyway, when using the "query" attribute you have to format your values before-hand (ie in your sql statement). I don't know what db you're using. Check your docs for formatting functions MS SQL - convert() MySql - Date_Format() Access - Try...
  20. cfStarlight

    Convert from char to decimal - errors

    Start with a test for numeric values. Add other conditions as needed. --- values that are numeric WHERE ISNumeric(YourVarcharColumn) = 1

Part and Inventory Search

Back
Top