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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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#"... -
Concatenating a variable and a string
<cfset #image# = "#productnumber#.jpg"> works for me..... -
select * where date1 >= start and date2 >= end
If the field in the db is a date, you might try: <cfquery name="shwList" datasource="deco" dbtype="odbc"> select * from mthSaleEvent where mthEffective >= #createOdbcDate(now())# AND mthExpires <= #createOdbcDate(now())# order by mthExpires </cfquery> webron -
Interface Lotus Notes with Cold Fusion
I don't think its possible. There is no lotus notes odbc-driver for coldfusion. Maybe its possible to (shedule) the export of data from lotus notes as comma delimited data and write it to a file. I know lotus notes can perform scheduled tasks. webron -
Passing URL.Parameter and using in CFQuery
Looks like printerid is not a field. try <cfquery datasource="printer" name="aboutPrinters"> Select * From Printer </cfquery> <cfoutput>#aboutPrinters.columnlist#</cfoutput> maybe PrinterID is Printer_ID? webron -
inserting data into database
Maybe you could check on duplicate entries Query checkdupe checks for duplicates If 'checkdupe' return a record -> update the record (or do nothing, whatever you want). Else insert the record. <cfquery name="checkdupe" datasource="datasource"> select fieldname from table...
