I would like to add to my query the following logic but I don't know how to right it:
WHERE
IF
Date800 IS NOT NULL
THEN
(Date802 + 75 Days) < Date803
END
Can someone please help me with my situation?
Thanks,
Mike
Hello,
I am running IIS 6 and ColdFusion MX in one machine. I am hosting about 5 domain names with my IIS such as xyz.com, abc.com, def.com, ghi.com, and jkl.com. One of these 5 domain is all the way written with basic HTML language so ColdFusion is not used in this domain and I don't have any...
Let's say I have a table which has records like this:
ID Date1 Date2 Date3 Date4 OtherFields...
1 2/23/03 4/15/03 3/11/03 3/18/05 ..............
2 2/24/03 2/10/05 4/12/03 3/15/03 ..............
3 NULL 3/12/03 2/11/03 3/31/03 ..............
Is it possible to find the largest...
Let say I have following date outputs:
Date1 = NULL
Date2 = 12/12/04
Date3 = 12/19/03
Date4 = NULL
Date5 = 01/01/05
How can I get the biggest date which is 01/01/05?
I played with DateCompare() and I couldn't get this to work with multiple dates (specially if a date field is NULL).
Please...
I have an HTML page with a form which has 57 text fields.
19 Columns X 3 Rows.
Is it possible to jump between these text boxes with Arrow Keys?
I appriciate any comments on this.
Thanks,
Mike
I have an HTML page with a form which has 57 text fields.
19 Columns X 3 Rows.
Is it possible to jump between these text boxes with Arrow Keys?
I appriciate any comments on this.
Thanks,
Mike
I have this inputer field:
<input name="The301" type="text" size="5" maxlength="8" value="#The301#" style="font-size:9px" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')">
I would like to not apply...
i am using cfcontent and cfheader to export some sql data to a dbf file. some of the numeric data should be in text datatype. for example a particular numeric value has to read as 05 vs. 5 so it i would like to set this field as a text datatype. i am actually passing 05 via cfheader/cfcontent...
For example let say I have this:
<td title="titleA titleB titleC">
Is it possible to have titleA on a separate line, titleB on a separate line and titleC on a separate line?
Also is it possible to control the title box height and width?
Thanks,
Mike
I have below <TR>:
<tr>
<td bgcolor="Red"></td>
<td bgcolor="Blue"></td>
</tr>
Is it possible to change the <TR> background color onmouseover and onmouseout put the default colors back to <TD>s?
On my actual scenario I have a lot more <TD>s.
Thanks in advanced,
Mike
is it possible to modify my computer's dns cache?
for example if i do ipconfig /displaydns i get something like this:
www.adomain.com
----------------------------------------
Record Name . . . . . : www.adomain.com
Record Type . . . . . : 1
Time To...
I’m running SBS 2003 Premium in the following setup:
Static IP/Internet -> Firewall -> Switch -> Server and Stations
With this box I’m hosting few internet domain names. These domain names have my Static IP address listed with their registrar as their DNS1 and DNS2. The problem I currently...
We have purchased 2 exact printers. These printers are on a network and each has unique IP address. What I would like to achieve is to split the print jobs between these two printers. For example if printer A is currently printing and a user print a word document I want that job to be redirected...
I have a field which holds full name like below:
FullName: Joseph M. Jennings, Jr., QKA
M. sometimes can be full middle name like Michael.
Is it possible parse this field and break it down between 5 fields like below?
First: Joseph
Middle: B.
Last: Jennings
Suffix: Jr.
Designation: QKA...
I'm running Windows 2003 SBS and with this box I am hosting few websites, Exchange and SQL.
Under DNS services I have created "Forward Lookup Zone" for each of my website's domain name. I'm pointing the Host (A) to my public IP Address which is set at my Firewall Hardware. All of my domain...
We are currently using Microsoft Exchange to manage our emails and an AntiSpam software to quarantine spam emails. As we are getting more and more spam everyday this AntiSpam software is putting more load in our server so I was thinking about setting up a Linux box as a gateway to filter the bad...
i would like to setup a linux firewall on my network to block some unwanted ports and direct some particular ports to particular servers. i looked at firewall-jay.sf don't know if it's a best option for me to go with since it goes on top of another linux os. i also looked at IPCop and i liked...
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.