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
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...
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"...
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...
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")#
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...
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...
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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.