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 Mike Lewis 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. minli98

    Storing cf variables in database

    Here are some useful links on the topic (courtesy of a member in the Adobe forum) http://tinyurl.com/57zws4 http://tinyurl.com/6gzvl2 http://tinyurl.com/6llo6g
  2. minli98

    Storing cf variables in database

    Hi Lyndon, I got the answer at the adobe forum. Thanks! Min
  3. minli98

    Storing cf variables in database

    Hi Lyndon, Thanks, but it doesn't work. It will just print out #url.pageNum#. The <cfoutput> does not process the variable. Min
  4. minli98

    Storing cf variables in database

    Hi, I am storing in database some text that has coldfusion variables in it. For example: This is page #url.pageNum# When I retrieve this text from the db and display it using cfoutput, the #url.pageNum# does not get processed. Instead, it is shown as a text. What do I do in order to get the...
  5. minli98

    Passing an event object

    Sorry, the second code should read <script> function processEvent(str,e){ alert(str + " " + e.clientX); } </script> <html> <input type="button" value="Click" onclick="processEvent('abc')"> </html>
  6. minli98

    Passing an event object

    Hi, I am learning how to use event in javascript and I have a basic question about passing an event object. I know that the following is the basic method (for Firefox anyway) <script> function processEvent(e){ alert(e.clientX); } </script> <html> <input type="button" value="Click"...
  7. minli98

    How to group data from two tables

    Hi Rudy, Thank you so much for your help. The code you wrote is what I what I was looking for. Thanks again. Regards, Min
  8. minli98

    How to group data from two tables

    Hi, Say I have two tables, visitTbl which is used to keep track of each web visit (by users) and transactionTbl, which is used to keep track of each transaction made by users. visitTbl: VisitDate UserId transactionTbl: TransactionDate UserId TransactionType I'd like to create a report that...
  9. minli98

    Replacing special character ’

    Thanks. I figured it out. Rgds, Min
  10. minli98

    How to display a date in a certain format?

    Use dateformat. See http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000441.htm In your example, it would be #dateformat(getEvent.eventDate,"mmmm d, yyyy")#
  11. minli98

    Replacing special character ’

    Sorry, a small typo in the original post. Does anyone know why when I run #chr(asc("’"))# I get â instead of the original character ’? FYI, this character is the single quote in Microsoft Word. I am trying to replace it with the regular single-quote ' but I am having a hard time. I tried...
  12. minli98

    Replacing special character ’

    Hi, Does anyone know why when I run #chr(asc(’))# I get â instead of the original character ’? FYI, this character is the single quote in Microsoft Word. I am trying to replace it with the regular single-quote ' but I am having a hard time. I tried using #replace(strVal,"’","'","all")# but it...
  13. minli98

    Alternative to Query Analyzer

    Thanks for all the suggestions! I tried Query Express and it's perfect for my needs. It's small, runs great, and has a side window pane that shows me all my tables and variables. Thanks all! Min
  14. minli98

    Alternative to Query Analyzer

    Hi, I was trying to install MS SQL Query Analyzer for my laptop, but I found out that the product has been discontinued. Does anyone know of a good Windows based alternative that is free and small (don't want to install a whole package of programs that I don't use). The database is MS SQL...
  15. minli98

    Help with sql

    Mark, Thanks. I will give it a try. Regards, M
  16. minli98

    Help with sql

    Hi, I have a simple table to keep track of marathon runners and their time in the events that they run in. The table has 3 fields: Runner's name, EventID, Run Time. So, for example, Name EventId Time A 1 2:15 B 1 2:11 C 1 2:12 .... B...
  17. minli98

    Updating records

    Boris, Ok thanks. I will give it a try. Regards, Min
  18. minli98

    Updating records

    Hi Borislav, Here's a simple illustration of the problem: Table 1: Id Count *********** A 2 B 5 C 1 Table 2: Id Count *********** B 2 D 1 How do I update table 1 with data from table 2 such that the new table 1 is Id Count *********** A 2 B 7 C...
  19. minli98

    Updating records

    Hi, I have a simple table with two keys: ID and count. Now I have a list of id's with their corresponding count that I want to integrate into the table in the following manner: If ID exists in the table, update the count by adding the count in the table with the new count. If ID does not...
  20. minli98

    Using Sum function within Union

    Thanks ESquared, I will give it a try. Regards, Min

Part and Inventory Search

Back
Top