Recent content by inspiraller

Same error message even with that. Cheers anyway though.

thanks Boris I tried that with forward or backslashes and that didn't work either. I appreciate what you are saying. I can only think the best way would be to first to upload data from excel into an asp or php page etc and then update sql database dynamically from there.

Hello I would like to make a connection to an excel database on an external server from sql server via a stored procedure and import the data from it. I have tried importing data from the excel database sitting on the local harddrive of the sql server and that works, however I will need to...

I have sorted it. It wasnt working because I put http:// in my domain name http:// Thanks anyway chopstik.

When you say how to GET THE TABLE? do you mean print it in HTML?

Yes, I can view the cookie from the original page, and if i traverse pages from the initial setting of the cookie. But the cookie is not there, when opening a new window. I have even tried setting the cookie with Now + 5 and the cookie is still not there when opening a new window.

Surely you can just use the window.open attributes to set the attributes of the window. window.open('somepage.htm','','titlebar') By specifying one attribute all the other attributes like scrollbars, resizable will automatically be locked. And since titlebar always shows, you can just use that.

<!-- You can do this with CSS. COPY AND PASTE THIS CODE INTO YOUR BODY. Just change the height and width accordingly --> <style type="text/css"><!-- #someLayer{ overflow:auto; height:100px; width:30px; } --> </style> <div id="someLayer"> some content with a scroll bar</div>

Whats the code in your function?

PAGE 1 Response.Cookies("loggedin")="true" Response.Cookies("loggedin").Expires = Date + 1 Response.Cookies("loggedin").Domain = strMyDomain PAGE 2 Response.Write wrapLine("START COOKIES LOOP") for each itemName in Request.Cookies Response.Write wrapLine(itemName & "=" &...

Try CONVERT(smalldatetime, '24/12/2004', 103) This will switch the date around from UK to US style.

Your problem could be ASP or Javascript related. Consider breaking it down and testing one or the other first.

Hello Chopstick, and thanks for your response. I understnd that about the session, so I have created a cookie instead. Hence, im wondering why its not even recognising the cookie?

Sorry - that should be FormatNumber(str,2) NOT ZERO

strEventCategory = parseInt("" & rs("Event_Category")) function parseInt(str) if isNumeric(str) then parseInt = FormatNumber(str,0) else parseInt = 0 end if end function