Visit this site, I used this and it worked very well for a client... they've been using it for over a year...
http://www.nopdesign.com/freecart/index.html
It's easy to setup...
Try This...
<BEGIN CODE>
<head>
<script language="JavaScript1.2">
/*
Full Screen Window
Submitted by Paul Deron (paul1.web.com)
To add more shock to your site, visit www.DHTML Shock.com
*/
<!-- Begin
function fullScreen(theURL) {
window.open(theURL, '', 'fullscreen=yes...
THANK YOU....
rsAds.Source = "SELECT AD_ID, convert(int, AD_EXPIRED) - convert(int, getDate()) AS DAYS FROM ADS"
This did it for me, I was going blind reading... I owe you big...
THANKS AGAIN...
Just to add a note, I sell OS software and SBE cost you about $350.00 more then Server 2000 by it self. In SBE you get BackOffice Small Business Server 2000 w/ 5-Client License, w/NT Server 2000, SQL 2000, Exchange 2000, New Proxy, Modem Sharing & Internet Info, Mail & Fax Serv.
This is the connection string I use to access my SQL Server...
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connDUclassified_STRING = "Provider=sqloledb;" & _...
I use ASP Mail so I'm informed when an Ad is placed or edited so it can be re-approved, I place the code in the Thankyou.asp. You'll find the edit on the DU web site.
This is data on my SQL Server and the data in the AD_EXPIRED column read 4/18/2003 2:27:00 PM.
What's being displayed is 1/30/1900 10:21:13 PM , and what I want to display is 4/18/2003 the expired date without the time.
I have code that reads below:
rsAds.Source = "SELECT AD_ID, AD_EXPIRED - getDate() AS DAYS, FROM ADS,
DAYS is referred to later in the script for display, my problem is the script is using statement to display data from a DB using " smalldatetime " in the AD_EXPIRED column.
I...
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.