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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by webron
-
A different kind of pager
You are right. My example was not complete. Apart from the numeric pager there are [previous] en [next] buttons. But it's of no concern anymore, as I solved this problem already. Thanks anyway for your response. -
A different kind of pager
Hi, im working on a pager for a client. Here's how it should work.... Let's assume we've got many products. I don't want to show them all at once. But let's say 10 per page. The pager should not display all pages as links, but it should be configurable. Let's say I want to show a maximum of 10... -
Dynamic sitemap generation
Imagine a dynamic website. The site consist of sections and pages. home intro vacancies vacancy 1 etc contact sections and pages are stored in separate tables stblsections ---------------- SectionID int (primary key) Title varchar parentSectionID sortorder int stblpages...- webron
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
summing to a total
Perfect! Thank you Could you be bothered explaining how this all works?- webron
- Post #5
- Forum: Microsoft SQL Server: Programming
-
summing to a total
Let's take groupid 1: matches [countryid] my predicted scores gameid ---------------------- ------------------- [1]germany - [2] Costa Rica 6 - 0 1 [3] poland - [4] Ecuador 1 - 2 2 [1] germany - [3] poland 2 - 1 3 [4] Ecuador - [2] Costa Rica 0 - 0 4 [4] Ecuador - [1] germany 2...- webron
- Post #3
- Forum: Microsoft SQL Server: Programming
-
summing to a total
country ---------- countryid pooleid countryname pool ------------ pooleid poulename game ------------ gameid pooleid homecountyid awaycountyid prediction ------------ predictionid userid gameid scorehome scoreaway predictedscores --------------- userid gameid countryid score (0, 1, or 3)...- webron
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Hide var in URL
You could use the encrypt and decrypt functions <cfset seed = "1234567890"> somepage.cfm?somevar=#urlencodedformat(encrypt(78, seed))# #decrypt(urlDecode(url.somevar), seed)# -
Calculating Average time with bussiness hours taken into account
My order table consist of 2 fields Time_RX (datetime) dateTime order has been placed Time_TX (datetime) dateTime order has been handled Now I have to calculate the responsetime between placing an handling, with bussiness hours taken into account! What I mean is: Suppose Bussinesshours : 08:00...- webron
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How to get the data out of the COOKIE (CGI variable)
Hi, try <cfset MYINTRANET_USERID =listgetat(cgi,HTTP_COOKIE, 2, "=,;")> it should return CF42912 webron -
How many mails can CFMAIL handle?
Yes we do use cfschedule for the batches. The scheduled mailer looks something like this: 1. Select all subscribers from the database 2. Select the next 150 from the query (based on a url.start) 3. mail the ezine 4. check for an existing schedule (if so -> delete) 5. Make a new schedule (if... -
How many mails can CFMAIL handle?
For a client, an ezine is sent once a week (about 9000 subscribers). We experienced serious troubles on the server (win 2000 sever, CF5, 512 mb). So we decided to send the mail in batches of 150 every 5 minutes (just to be sure). I think its a good idea to send the mail in 3 batches. webron -
SQL Query Builder not connecting
>How do I know if RDS is running or not? in the cf admin. Edit any datasource, click on the button 'browse server' at the right of the field 'Database File'. If the 'Select File on the Server' just keeps displaying 'retrieving initial directories...' RDS is not running. webron -
Counting Query
You might try this: <CFQUERY NAME="CATZ" DATASOURCE="GLKB"> Select CATID, CATEGORY From CATEGORIES Order By CATEGORY </CFQUERY> <HTML> <HEAD> <TITLE>Categories</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">... -
Query and Table Fields
Or you could use: <cfloop query="qName"> <cfloop list="#columnList#" index="currentfield"> <CFOUTPUT>#evaluate(currentfield)#<CFOUTPUT> </cfloop> </cfloop> The first loop loops over the rows and the second over every field. webron -
CFdirectory
Hi, you are trying to set a variable with a variable name Remove the '#' and it wil work fine. <cfset #test# = "e:\web\xyz\#variable#\images"> <cfset test = "e:\web\xyz\#variable#\images"> <cfdirectory action="LIST" directory="#test#"...
