Recent content by KirkKelly

I need to create a stored procedure that when passed the starting date and ending date, will return a result set that has one record for day of the month and a count for how many records where scheduled for that day, even if there are no records for that day. I can create a set down, group by...

*Program: ctConnect *Returns: Int ConnHandle *Parameters tcServerName public gcWinDir,gcSysDir Local lnConnHandle = SQLSetProp(0, "displogin", 3) lcDSNLess=[DRIVER={SQL SERVER};SERVER=]+ALLTRIM(tcServerName)+[;UID=ctore;pwd=passwordhere;Network=DBMSSOCN;database=CTORE;]...

I have the following query that returns records where there are gaps of times between meetings, and only ones that meet a certain amount of time gap, and are associated with a valid roomid. The problem I have is that it returns records that are past the last possible time to schedule in a room...

I'm looking for a good way to timeout an applicaiton if there is no use for a given period of time. I use sql as the back end and visual foxpro for the front end. at the begininng of the applicaiton I create a connection handle. I was wondering if sql maintains a connection status (idle and...

I have an exe that needs to have the ability to close itself down after there is no user activity for a set period of time. Anybody have any idea's how to start or samples? Kirk

1. Does any body know how to include a quote inside a string? 2. Is anyone using the overlib.js? Thanks Kirk

If you store the desired hex value for the color in a session object, you can use it to set the background color of a page. I put the code in the pageGenerateBegin, but it may be better suited in the pageLoad section: String dbColor=""; dbColor = (String)...

I have the user's desired background color stored in a session object. Does anyone know how I can make the page use that color when the page is loaded? Thanks Kirk

// put code in pageRequestBegin String ipAddress =(String) req.getRemoteAddr();

The following code will get the previous page (refering page) and store it in a session object. You can then get the value out when you need it. Put this code in the pageLoad section: setSessionValue("previouspage",req.getHeader("referer"));

/*This sould be in the pageLoaded section */ java.util.Enumeration elist = req.getHeaderNames(); String sHeader=""; while (elist.hasMoreElements()) { sHeader=(String) elist.nextElement(); System.out.println(sHeader+" = "+req.getHeader(sHeader)); }

The javascript is used on a sub-page: var browser = navigator.appName; method rowOver(whichRow) { if (browser == "Microsoft Internet Explorer") { whichRow.style.background="#EFE48E"; } } method rowOut(whichRow) { if (browser == "Microsoft...

We are using a thing called SimpleReports that uses a SimpleReports.db file to format the data in either HTML (Default), word, excel or pdf. It's free and out there somewhere on the internet or I have a zip file I can send you. Kirk kkelly@cqisol.com

Thanks Kirk

Can anybody tell me how to get the IP address in a silverstream page? Thanks Kirk