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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bad interval external representation using now()

Status
Not open for further replies.
jmycr

jmycr

Programmer
Mar 11, 2002
48
0
0
US
I get this error

Bad interval external representation '(select maxday_savefile from backup) days'

Does anybody know of a way to use now() subtracting the result of a subquery?

I am trying to get values of a file saved that has overstayed its visit on my system.

The query itself looks good, but...

SELECT b.backup_id, a.file_name, a.file_size
FROM archive a, backup b
WHERE a.bkup_name = b.bkup_name and a.backup_date < 'now'::datetime - '(SELECT maxday_savefile
FROM backup) days'::timespan;
 
Sort by date Sort by votes
Have you tried putting a more complete set of parentheses?
Code: 
SELECT b.backup_id, a.file_name, a.file_size
FROM archive a, backup b
WHERE a.bkup_name = b.bkup_name and a.backup_date < ('now'::datetime - '(SELECT maxday_savefile FROM backup) days'::timespan);

And, does &quot;SELECT maxday_savefile FROM backup&quot; return a single integer value? Have you tried casting the results of that subquery to text? As an exercise, try taking one specific example of this query, and writing out what each of the parts would look like &quot;translated&quot;. -------------------------------------------

&quot;Calculus is just the meaningless manipulation of higher symbols&quot;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-unknown F student
 
Upvote 0 Downvote
<html>
<head>

<title>Another</title>

<meta name=&quot;keywords&quot; content=&quot;domain names, domain register, domain search, web address, domain names, network solutions, register domain name, domain, whois, netsol.com&quot; />
<meta name=&quot;description&quot; content=&quot;Visit netsol.com for domain names and web address information, building a web site details, domain search, and personalized email. Find out if VeriSign has the solution for you at netsol.com&quot; />
<meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=ISO-8859-1&quot; />
<meta name=&quot;robots&quot; content=&quot;all&quot; />
<meta http-equiv=&quot;pics-label&quot; content='(pics-1.1 &quot; l gen true for &quot; r (cz1 lz 1 nz 1 oz 1 vz 1) &quot; l gen true for &quot; r (n 0 s 0 v 0 l 0))' />













<!-- Insert page refresh parameters if not a landing page -->

<META HTTP-EQUIV=&quot;refresh&quot; CONTENT=&quot;refresh&quot;>









<script language=&quot;Javascript&quot; type=&quot;text/javascript&quot;>
<!--
function PreloadImages() {}
function SwapImage() {}
//-->
</script>
<script language=&quot;JavaScript&quot; type=&quot;text/javascript&quot;>

</script>
<script language=&quot;Javascript&quot; type=&quot;text/javascript&quot; src=&quot;/en_US/styles/popup.js&quot;>
<!--
function popupFAQ() {}
function popupWizard() {}
function popupSample() {}
function popupPayFlow() {}
function popupHelp() {}
function popupTour() {}
function popupTry() {}
function popupNameIt() {}
function FAQwin() {}

</script>
<script language=&quot;Javascript&quot; type=&quot;text/javascript&quot;>
<!--
var pollExitFlag = 1; //clear this to zero to show no polls
function noPolls() {
pollExitFlag = 0;

}
//-->
</script>

<!-- setting up the usemap -->


</head><body bgcolor=&quot;#ffffff&quot; text=&quot;#000000&quot; link=&quot;#003399&quot; vlink=&quot;#666666&quot; alink=&quot;#990000&quot; leftmargin=&quot;0&quot; topmargin=&quot;0&quot; marginwidth=&quot;0&quot; marginheight=&quot;0&quot;>
<SCRIPT language=&quot;JavaScript&quot; type=&quot;text/javascript&quot;>
<!--
function onBodyLoad() {
//-->

<!--
}
//-->
</SCRIPT>






<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;Register domain names at netsol.com&quot; width=&quot;1&quot; height=&quot;1&quot; align=&quot;right&quot; hspace=&quot;0&quot; vspace=&quot;0&quot; border=&quot;0&quot; />









<form action=&quot;whois.cgi&quot; method=post>














<a name=&quot;top&quot;></a>

<!-- Begin Header -->
<!-- Logo and Ad Banner -->
<table width=&quot;749&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr>

<td width=&quot;500&quot;><font color=&quot;#00FF00&quot; size=&quot;7&quot; face=&quot;Mistral&quot;><strong> &nbsp;<font color=&quot;#004080&quot; size=&quot;6&quot; face=&quot;Bauhaus 93&quot;>Aitcom
</font></strong></font><font color=&quot;#00FF00&quot;><strong><font color=&quot;#004080&quot; size=&quot;5&quot;>Internet
Technologies</font></strong></font></td>

<td width=&quot;249&quot;><img src=&quot;/en_US/images/common/logo-verisign-anim.gif&quot; alt=&quot;Network Solutions&quot; border=&quot;0&quot; vspace=&quot;6&quot;>
</td>
</tr>
</table>
<table width=&quot;759&quot; align=&quot;center&quot; border=&quot;1&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; bordercolor=&quot;#003366&quot; bgcolor=&quot;#003366&quot;>
<tr>
<td width=&quot;124&quot; bgcolor=&quot;#CCCCCC&quot;> <a href=&quot;CustomerLogin&quot; alt=&quot;View rder&quot;><em><strong>
<font color=&quot;#FF0000&quot;>Existing Members</font></strong></em></a></td>
<td width=&quot;111&quot; bgcolor=&quot;#CCCCCC&quot;><font color=&quot;#004080&quot;>&nbsp;<a href=&quot;TransferDomain&quot; target=&quot;_blank&quot;><font color=&quot;#003366&quot;>Transfer
Domain</font></a></font></td>
<td width=&quot;101&quot; bgcolor=&quot;#CCCCCC&quot;>&nbsp;</td>
<td width=&quot;116&quot; align=&quot;center&quot; bgcolor=&quot;#CCCCCC&quot;></td>
<td width=&quot;83&quot; align=&quot;center&quot; bgcolor=&quot;#CCCCCC&quot;><a href=&quot;#about&quot; ><font color=&quot;#004080&quot;>About Us </font></td>
<td width=&quot;210&quot; align=&quot;right&quot;> <table width=&quot;197&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr>
<td><font color=&quot;#004080&quot;><a href=&quot;/order&quot; target=&quot;_top&quot;><img src=&quot;/en_US/images/common/view-order-off.gif&quot; width=&quot;74&quot; height=&quot;29&quot; alt=&quot;View rder&quot; border=&quot;0&quot; /></a></font></td>
<td><font color=&quot;#004080&quot;><a href=&quot;/something&quot; ><img src=&quot;/en_US/images/common/nav-whois.gif&quot; width=&quot;55&quot; height=&quot;29&quot; alt=&quot;WHOIS&quot; border=&quot;0&quot; /></a></font></td>
<td><font color=&quot;#004080&quot;><a href=&quot;/something&quot; ><img src=&quot;/en_US/images/common/nav-help.gif&quot; width=&quot;68&quot; height=&quot;29&quot; alt=&quot;Help&quot; border=&quot;0&quot; /></a></font></td>
</tr>
</table></td>
</tr>
<!-- Dark Section Color -->
<tr>
<td colspan=&quot;5&quot;><font color=&quot;#004080&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></font></td>
</tr>
</table>
<table width=&quot;886&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr bgcolor=&quot;#990000&quot;> <!-- Section Color -->

<td width=&quot;6&quot; bgcolor=&quot;#003366&quot;>&nbsp;</td>
<td width=&quot;748&quot; bgcolor=&quot;#003366&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;14&quot; /></td>

<td width=&quot;132&quot; bgcolor=&quot;#003366&quot;>&nbsp;</td>
</tr>

</table>









<table width=&quot;759&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr>
<td width=6 rowspan=2 bordercolor=&quot;#333333&quot; bgcolor=&quot;#003366&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=6></td>
<!-- Left Content -->
<td valign=&quot;top&quot; width=532>
<table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;100%&quot; border=&quot;0&quot;>
<tr bgcolor=&quot;#CCCCCC&quot;>
<td width=&quot;265&quot; height=&quot;309&quot; colspan=&quot;4&quot; align=&quot;middle&quot; valign=&quot;top&quot;>
<table width=&quot;587&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; bordercolor=&quot;#003366&quot; bgcolor=&quot;#CCCCCC&quot;>
<tr>
<td width=10 rowspan=2><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=10></td>
<td height=&quot;80&quot; bgcolor=&quot;#CCCCCC&quot;><strong><font color=&quot;#003366&quot; size=&quot;6&quot;><a href=&quot;FreeInfo&quot; target=&quot;_blank&quot;><em><font color=&quot;#990000&quot; size=&quot;7&quot;>Frog</font></em></a></font><font color=&quot;#004080&quot; size=&quot;5&quot;>
Domain Registration </font></strong></td>
<td width=10 rowspan=2><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=10></td>
</tr>
<tr>
<td height=&quot;173&quot; bgcolor=&quot;#003366&quot;> <table width=690 height=&quot;191&quot; border=0 cellpadding=0 cellspacing=0 bordercolor=&quot;#CCCCCC&quot; bgcolor=&quot;#CCCCCC&quot;>
<tr>
<td width=&quot;1&quot; height=&quot;2&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td width=&quot;193&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=192></font></td>
<td width=&quot;382&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=269></font></td>
<td width=&quot;102&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=93></font></td>
<td width=&quot;1&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td width=&quot;11&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=2></font></td>
</tr>
<tr>
<td><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td colspan=3 bordercolor=&quot;#990000&quot; bgcolor=&quot;#003366&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td colspan=2 rowspan=2 bordercolor=&quot;#990000&quot; bgcolor=&quot;#003366&quot;><font color=&quot;#FFFFFF&quot;>&nbsp;</font></td>
</tr>
<tr>
<td height=&quot;5&quot;><font color=&quot;#FFFFFF&quot;><img height=5 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bordercolor=&quot;#666666&quot; bgcolor=&quot;#666666&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#999999&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#CCCCCC&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
<tr>
<td height=&quot;147&quot; bgcolor=&quot;#666666&quot;><font color=&quot;#FFFFFF&quot;><img height=82 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#666666&quot; valign=top> <table border=0 cellpadding=0 cellspacing=0 bgcolor=&quot;#666666&quot;>
<tr>
<td width=&quot;1&quot; rowspan=3 bgcolor=&quot;#003366&quot;>&nbsp;</td>
<td width=&quot;6&quot; rowspan=3><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
<td width=&quot;688&quot; valign=top bgcolor=&quot;#666666&quot;> <table cellspacing=0 cellpadding=0 border=0>
<tr>
<td width=&quot;18&quot;><p><font color=&quot;#004080&quot; size=&quot;5&quot;><strong>1.</strong></font></p></td>
<td width=&quot;1&quot;>&nbsp;</td>
<td width=&quot;36&quot; align=&quot;right&quot; valign=center class=srchBldtext><font color=&quot;#FFFFFF&quot;>&nbsp;Enter</font></td>
<td width=&quot;106&quot; align=&quot;left&quot; valign=center bgcolor=&quot;#666666&quot; class=srchBldtext><font color=&quot;#FFFFFF&quot;>&nbsp;&nbsp;<a href=&quot;DomainName&quot; target=&quot;_blank&quot;><strong><font color=&quot;#003366&quot;>Domain
Name</font></strong> </a></font></td>
</tr>
<tr bgcolor=&quot;#666666&quot;>
<td colspan=&quot;4&quot;><font color=&quot;#FFFFFF&quot;><img height=8 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
</table></td>
<td width=&quot;10&quot; rowspan=&quot;3&quot; bgcolor=&quot;#666666&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
</tr>
<tr>
<td height=&quot;105&quot; valign=&quot;top&quot;> <table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; bgcolor=&quot;#666666&quot;>
<tr>
<td width=&quot;38&quot; valign=&quot;center&quot; class=&quot;smtext&quot;><font color=&quot;#FFFFFF&quot;><b>www.
</b></font></td>
<td width=&quot;650&quot; bgcolor=&quot;#666666&quot;> <font color=&quot;#FFFFFF&quot;>
<input class=&quot;srchInput&quot; id=key23 maxlength=&quot;67&quot; size=&quot;14&quot; name=&quot;key2&quot; value=&quot;&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:key2&quot; value=&quot; &quot;>
</font></td>
</tr>
<tr>
<td rowspan=3><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td class=&quot;smtext&quot;><font color=&quot;#FFFFFF&quot;>e.g.
aitcom.net </font></td>
</tr>
<tr>
<td><font color=&quot;#FFFFFF&quot;><img height=9 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
<tr>
<td class=&quot;smtext&quot;>&nbsp;</td>
</tr>
</table></td>
</tr>
</table></td>
<td bgcolor=&quot;#999999&quot; valign=&quot;top&quot;> <table cellspacing=0 cellpadding=0 border=0>
<tr>
<td rowspan=3><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
<td valign=&quot;top&quot;> <table cellspacing=0 cellpadding=0 border=0>
<tr>
<td><font color=&quot;#004080&quot; size=&quot;5&quot;><strong>2.</strong></font></td>
<td>&nbsp;</td>
<td class=&quot;srchBldtext&quot; valign=&quot;center&quot;><font color=&quot;#FFFFFF&quot;>&nbsp;Select</font></td>
<td valign=&quot;center&quot; bgcolor=&quot;#999999&quot; class=&quot;smtext&quot;><font color=&quot;#FFFFFF&quot;>&nbsp;&nbsp;<b><a href=&quot;Extension&quot; target=&quot;_blank&quot;><font color=&quot;#003366&quot;>Extension</font></a></b></font></td>
</tr>
<tr>
<td colspan=4><font color=&quot;#FFFFFF&quot;><img height=4 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
</table></td>
<td rowspan=3><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
</tr>
<tr>
<td valign=&quot;top&quot;> <table cellspacing=0 cellpadding=1 width=248 border=0>
<tr>
<td> <table border=&quot;0&quot; cellpadding=&quot;1&quot; cellspacing=&quot;0&quot; width=&quot;200&quot;>
<tr>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.com&quot; >
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.com</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.net&quot; checked>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.net</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.us&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.us</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.biz&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.biz</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.info&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.info</b></font></td>
</tr>
<tr>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.tv&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.tv</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.org&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.org</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.ws&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.ws</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.cc&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.cc</b></font></td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><font color=&quot;#FFFFFF&quot;>
<input type=&quot;checkbox&quot; name=&quot;TLDs&quot; value=&quot;.bz&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:TLDs&quot; value=&quot; &quot;>
<b>.bz</b></font></td>
</tr>
</table>
<tr>
<td height=&quot;21&quot; align=right >&nbsp;</td>
</tr>
</table></td>
</tr>
</table></td>
<td bgcolor=&quot;#CCCCCC&quot; valign=top> <table cellspacing=0 cellpadding=0 border=0>
<tr>
<td width=&quot;6&quot; rowspan=2><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
<td width=&quot;85&quot; valign=&quot;top&quot;> <table cellspacing=0 cellpadding=0 border=0>
<tr>
<td height=&quot;31&quot;>&nbsp;</td>
<td>&nbsp;</td>
<td class=&quot;srchBldtext&quot; valign=&quot;center&quot;><font color=&quot;#FFFFFF&quot;><strong><font color=&quot;#004080&quot; size=&quot;5&quot;>3.&nbsp;</font></strong>Search</font></td>
</tr>
<tr>
<td class=&quot;smtext&quot; colspan=3><font color=&quot;#FFFFFF&quot;><br>
</font></td>
</tr>
</table></td>
<td width=&quot;10&quot; rowspan=2><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=5></font></td>
</tr>
<tr>
<td valign=center align=middle> <input type=submit value=&quot;Submit Domain&quot; file(s)&quot; name=Submit>
<input type=&quot;hidden&quot; value=&quot;&quot; priority=&quot;-10&quot; name=&quot;/servlet/purchasing/SFDomainSearchServlet.submit&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:/servlet/purchasing/SFDomainSearchServlet.submit&quot; value=&quot; &quot;>
<input type=&quot;hidden&quot; name=&quot;Search&quot; value=&quot;/en_US/name-it/searchresults.jhtml&quot;>
<input type=&quot;hidden&quot; value=&quot;false&quot; name=&quot;/beans/SFSearchRequest.allowBulk&quot;>
<input type=&quot;hidden&quot; name=&quot;_D:/beans/SFSearchRequest.allowBulk&quot; value=&quot; &quot;>
</td>
</tr>
</table></td>
<td bgcolor=&quot;#666666&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#003366&quot;><font color=&quot;#FFFFFF&quot;><img height=8 src=&quot;/en_US/images/common/spacer.gif&quot; width=8></font></td>
</tr>
<tr>
<td height=&quot;3&quot;><font color=&quot;#FFFFFF&quot;><img height=3 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#666666&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#999999&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#CCCCCC&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td colspan=2 rowspan=3 bgcolor=&quot;#003366&quot;><font color=&quot;#FFFFFF&quot;>&nbsp;</font></td>
</tr>
<tr>
<td><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td bgcolor=&quot;#666666&quot; colspan=3><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
<tr>
<td height=&quot;15&quot;><font color=&quot;#FFFFFF&quot;><img height=2 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
<td colspan=3 bordercolor=&quot;#990000&quot; bgcolor=&quot;#003366&quot;><font color=&quot;#FFFFFF&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height=&quot;38&quot; class=&quot;text&quot;><br /></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor=&quot;#cccccc&quot; colspan=&quot;4&quot; height=&quot;1&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></td>
</tr>
<tr bgcolor=&quot;#CCCCCC&quot;>
<td height=&quot;56&quot; colspan=&quot;3&quot; align=&quot;default&quot; valign=&quot;center&quot;> <p> <font color=&quot;#004080&quot;><a name=&quot;about&quot;></a><strong>&nbsp;&nbsp;&nbsp;Welcome
to Aitcom Internet Solutions.</strong></font></p>
&nbsp;&nbsp;&nbsp;Each month, thousands of new customers choose
AIT. Why? Because AIT offers <br>&nbsp;&nbsp;&nbsp;the most flexible web hosting plans
and the most profitable reseller web hosting <br>&nbsp;&nbsp;&nbsp;program in the industry.
Personal, professional, and ecommerce web hosting clients <br>&nbsp;&nbsp;&nbsp;benefit
from the features and support provided by AIT. Whether you prefer
Linux <br>&nbsp;&nbsp;&nbsp;or Windows server software, turn to AIT for your colocation,
dedicated server, or <br>&nbsp;&nbsp;&nbsp;virtual server needs. Click here to see why
hundreds of thousands of domains have <br>
&nbsp;&nbsp;&nbsp;chosen AIT as their web hosting provider. <strong><font color=&quot;#004080&quot;><a href=&quot;AboutUs&quot; target=&quot;_blank&quot;>more</a></font></strong><br> </p>
<p>&nbsp;</p></td>
<td height=&quot;113&quot; rowspan=&quot;2&quot; align=&quot;default&quot; valign=&quot;center&quot;>&nbsp;</td>
</tr>
<tr bgcolor=&quot;#CCCCCC&quot;>
<td height=&quot;57&quot; colspan=&quot;3&quot; align=&quot;default&quot; valign=&quot;center&quot; bgcolor=&quot;#003366&quot;>&nbsp;</td>
</tr>
<tr>
<td bgcolor=&quot;#cccccc&quot; colspan=&quot;4&quot; height=&quot;1&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></td>
</tr>
<tr>
<td valign=&quot;top&quot; align=&quot;right&quot;> <a href=&quot; src=&quot;/en_US/images/ads/260x151-1pagewebsite.gif&quot; width=&quot;260&quot; height=&quot;151&quot; border=&quot;0&quot; vspace=&quot;8&quot;></a>
</td>
<td bgcolor=&quot;#cccccc&quot; width=&quot;1&quot;><img src=&quot;/en_US/images/common/spacer-cccccc.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></td>
<td valign=&quot;top&quot;> <a href=&quot; src=&quot;/en_US/images/ads/295x151-personalizedemail.gif&quot; width=&quot;295&quot; height=&quot;151&quot; border=&quot;0&quot; vspace=&quot;8&quot;></a>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td bgcolor=&quot;#cccccc&quot; colspan=&quot;4&quot; height=&quot;1&quot;><img height=&quot;1&quot; src=&quot;/en_US/images/common/spacer.gif&quot; width=1></td>
</tr>
<tr>
<td valign=&quot;top&quot; colspan=&quot;4&quot;> <table border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;>
<tr>
<td><img src=&quot;/en_US/images/common/spacer.gif&quot; width=&quot;20&quot; height=&quot;1&quot; /></td>
<td class=&quot;lgtext&quot;><br> </td>
</tr>
<tr>
<td colspan=&quot;2&quot;>&nbsp;</td>
</tr>
<tr>
<td rowspan=&quot;9&quot;>&nbsp;</td>
<td class=&quot;lgtext&quot;><br /></td>
</tr>
<tr>
<td class=&quot;lgtext&quot;><b><a href=&quot;/webpage&quot; target=&quot;_blank&quot;>Web
Page Starter</a></b> - <span class=&quot;smtext&quot;>Build your own
customized Web site with a variety of templates.</span><br /></td>
</tr>
<tr>
<td class=&quot;lgtext&quot;>&nbsp;</td>
</tr>
<tr>
<td class=&quot;lgtext&quot;><b><a href=&quot;/shoppingcart&quot; target=&quot;_blank&quot;>Shopping
Cart </a></b> - <span class=&quot;smtext&quot;>No monthly payment Shopping
Cart!</span></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td class=&quot;lgtext&quot;><b><a href=&quot;/security&quot; target=&quot;_blank&quot;>Security
</a></b> - <span class=&quot;smtext&quot;>The best security in the business!</span></td>
</tr>
<tr>
<td><br />
<b><a href=&quot;/uptime&quot; target=&quot;_blank&quot;>99.9% Network Uptime</a></b>-
<span class=&quot;smtext&quot;>We work to ensure your site stays up!</span></td>
</tr>
<tr>
<td class=&quot;lgtext&quot;><br /></td>
</tr>
<tr>
<td><br /> <br /></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td bgcolor=&quot;#999999&quot; width=&quot;1&quot; rowspan=&quot;2&quot;><img height=&quot;1&quot; src=&quot;/en_US/images/common/spacer.gif&quot; width=&quot;1&quot; /></td>
<td class=&quot;smtext&quot; valign=&quot;top&quot; width=&quot;168&quot; colspan=&quot;3&quot;>
<table cellspacing=0 cellpadding=0 align=left border=0>
<tr>
<td width=14><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=14></td>
<td width=&quot;158&quot; class=&quot;text&quot;><b class=&quot;color-name&quot;><font color=&quot;#990000&quot;>Frog</font><font color=&quot;#000000&quot;>
Domain </font></b><font color=&quot;#000000&quot;><strong>Registration</strong></font><br />
<a href=&quot;domain&quot; class=&quot;novisit&quot;>frog Registration with 2 year hosting
commitment!</a></td>
</tr>
<tr>
<td colspan=&quot;2&quot; bgcolor=&quot;#cccccc&quot;><img src=&quot;/en_US/images/common/spacer-cccccc.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td class=&quot;text&quot;><p><b class=&quot;color-name&quot;> <font color=&quot;#990000&quot;>Frog</font>
Domain </b><strong>Transfer</strong><br />
<a href=&quot;transfer&quot; class=&quot;novisit&quot;>Transfer your domain name frog
with 2 year hosting commitment!</a></p>
</td>
</tr>
<tr>
<td colspan=&quot;2&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;10&quot; /><br /></td>
</tr>
<tr>
<td colspan=&quot;2&quot; bgcolor=&quot;#cccccc&quot;><img src=&quot;/en_US/images/common/spacer-cccccc.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td class=&quot;text&quot;> <b class=&quot;color-name&quot;><font color=&quot;#990000&quot;>Frog</font>
Shopping Cart</b><strong></strong><br />
<a href=&quot;transfer&quot; class=&quot;novisit&quot;>After a frog time setup fee,
there is no cost to you...ever!</a><br />
</td>
</tr>
<tr>
<td colspan=&quot;2&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;10&quot; /><br /></td>
</tr>
<tr>
<td colspan=&quot;2&quot; bgcolor=&quot;#cccccc&quot;><img src=&quot;/en_US/images/common/spacer-cccccc.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><a href=&quot;/en_US/manage-it/index.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;><img src=&quot;/en_US/images/home/manage-account.gif&quot; width=&quot;151&quot; height=&quot;25&quot; alt=&quot;Manage your Account&quot; border=&quot;0&quot;></a><br />
<a href=&quot;/en_US/manage-it/index.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;>Customer log-in</a>
</td>
</tr>
<tr>
<td colspan=&quot;2&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;10&quot; /><br /></td>
</tr>
<tr>
<td colspan=&quot;2&quot; bgcolor=&quot;#cccccc&quot;><img src=&quot;/en_US/images/common/spacer-cccccc.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;1&quot; /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td class=&quot;text&quot; nowrap=&quot;nowrap&quot;><img src=&quot;/en_US/images/home/quick-links.gif&quot; width=&quot;151&quot; height=&quot;25&quot; alt=&quot;Quick links&quot; border=&quot;0&quot;><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot;/en_US/promotions/offers/options/email-domain-bundle.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;>Personalized e-mail</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot;/en_US/enhance-it/forwarding.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;>Web forwarding</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot;/en_US/enhance-it/inktomi.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;>Search engine listing</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot; class=&quot;novisit&quot;>Multilingual domain names</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot;/en_US/build-it/package-ecommerce-basic.jhtml;jsessionid=E1HG2KGTFNULKCWLEAKSFEY&quot; class=&quot;novisit&quot;>E-commerce packages</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot; class=&quot;novisit&quot;>Digital certificates & SSL</a><br />
<img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;3&quot; /><br />
<a href=&quot; class=&quot;novisit&quot;>Payment services</a>
</td>
</tr>
<tr>
<td colspan=&quot;2&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;10&quot; /><br /></td>
</tr>
<tr>
<td bgcolor=&quot;#cccccc&quot; colspan=&quot;2&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></td>
</tr>
<tr>
<td>&nbsp;</td>
<td class=&quot;text&quot;>








<a href=&quot; &quot;><img src=&quot;/en_US/images/ads/149x68-sgms.gif&quot; width=&quot;149&quot; height=&quot;68&quot; border=&quot;0&quot; vspace=&quot;8&quot;></a>




</td>
</tr>
<tr>
<td colspan=&quot;2&quot;><img height=10 src=&quot;/en_US/images/common/spacer.gif&quot; width=1><br /></td>
</tr>
<tr>
<td bgcolor=&quot;#cccccc&quot; colspan=&quot;2&quot;><img height=1 src=&quot;/en_US/images/common/spacer.gif&quot; width=1></td>
</tr>

</table>
</td>
</tr>
</table>











<table width=&quot;759&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; bgcolor=&quot;#003366&quot;>
<!-- Section Color -->
<tr>
<td width=&quot;6&quot;><img src=&quot;/en_US/images/common/spacer.gif&quot; alt=&quot;&quot; width=&quot;6&quot; height=&quot;1&quot; /></td>

<td width=&quot;157&quot; align=&quot;center&quot;> <a href=&quot;#top&quot; >
<font color=&quot;#ffffff&quot; face=&quot;verdana,arial,helvetica&quot; size=&quot;1&quot;><b>Back
to Top</b></font></a></td>
<td width=&quot;1&quot;><img src=&quot;/en_US/images/common/spacer-ffffff.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;15&quot; /></td>
<td width=&quot;116&quot; align=&quot;center&quot;>

<a href=&quot;#about&quot; ><font color=&quot;#ffffff&quot; face=&quot;verdana,arial,helvetica&quot; size=&quot;1&quot;><b>About Us</b></font></a></td>
<td width=&quot;1&quot;><img src=&quot;/en_US/images/common/spacer-ffffff.gif&quot; alt=&quot;&quot; width=&quot;1&quot; height=&quot;15&quot; /></td>

<td width=&quot;148&quot; align=&quot;center&quot;> <a href=&quot;/tutorials&quot; target=&quot;_blank&quot;> <font color=&quot;#ffffff&quot; face=&quot;verdana,arial,helvetica&quot; size=&quot;1&quot;><b>Tutorials</b></font></a></td>
<td width=&quot;1&quot;>
<td width=&quot;162&quot; align=&quot;center&quot;> <a href=&quot;/contactus&quot; &quot;>
<font color=&quot;#ffffff&quot; face=&quot;verdana,arial,helvetica&quot; size=&quot;1&quot;><b>Contact
Us</b></font></a></td>

<td width=&quot;166&quot; align=&quot;center&quot; bgcolor=&quot;#990000&quot;> <a href=&quot;/FutureServices&quot;>
<font color=&quot;#333333&quot; size=&quot;2&quot; face=&quot;verdana,arial,helvetica&quot;><strong><em>Future
Services</em></strong></font> </a></td>
</tr>
</table>
<table width=&quot;759&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr bgcolor=&quot;#999999&quot;>
<td height=&quot;7&quot; colspan=&quot;3&quot; class=&quot;minitext&quot;><sub>&nbsp;</sub></td>
</tr>
<tr valign=&quot;top&quot;>

<td width=&quot;126&quot; align=&quot;right&quot; bgcolor=&quot;#CCCCCC&quot;><br />
</td>

<td width=&quot;517&quot; align=&quot;center&quot; valign=&quot;top&quot; bgcolor=&quot;#CCCCCC&quot; class=&quot;copyright&quot;>
<font color=&quot;#804040&quot;>Review our <a href=&quot;/privacy&quot; target=&quot;_blank&quot; >Privacy
Policy</a> Service Agreement, <a href=&quot;/legal&quot; target=&quot;_blank&quot; >Legal
Notice</a> and <a href=&quot;/disclaimer&quot; target=&quot;_blank&quot;>Disclaimer</a>. <br />
VeriSign, Inc.</font></td>
<td width=&quot;116&quot; align=&quot;right&quot; bgcolor=&quot;#CCCCCC&quot;>&nbsp;</td>
</tr>
</table>

<br />

&nbsp;







</form>
</body>
</html>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spperl
  • Locked
  • Question
Like Search using full text index
Replies
1
Views
45
spperl
spperl
AP81
  • Locked
  • Question
using COPY command with SQL query
Replies
1
Views
41
feherke
feherke
QuercusDK
  • Locked
  • Question
PostgreSQL COPY - using variable filename?
Replies
1
Views
81
feherke
feherke
splendided
  • Locked
  • Question
Extract number of days from interval.
Replies
1
Views
27
feherke
feherke
skicamel
  • Locked
  • Question
Interval conversion 1
Replies
3
Views
18
skicamel
skicamel

Part and Inventory Search

Sponsor

Back
Top