Minimizing the Browser Window - Web Development Discussion Boards

Xavier Shay13-Feb-02 14:33

13-Feb-02 14:33

I'm trying to create a forums site, and I would like to add a date to all posts. At the moment I have the following code:

SQLStmt = "INSERT INTO Messages (ForumID, ParentID, PosterID, Title, Body, Date) "
SQLStmt = SQLStmt & " VALUES (" & forumID & ", " & parentID & ", " & userID & ", '" & subject & "', '" & message & "', #" & Date() & "#)"
set RS = conn.Execute(SQLStmt)

Which when expanded prints something like:
INSERT INTO Messages (ForumID, ParentID, PosterID, Title, Body, Date) VALUES (22, 0, 1, 'Test', 'Test Text', #2/14/2002#)

This all works fine if I exclude the Date Field. The most descriptive error I get is:

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.

Any help would be greatly appreciated
- X

Re: Adding dates to a database

Konstantin Vasserman13-Feb-02 17:01

Konstantin Vasserman

13-Feb-02 17:01

I think you need to replace # signs with '. For example:

INSERT INTO Messages (ForumID, ParentID, PosterID, Title, Body, Date) VALUES (22, 0, 1, 'Test', 'Test Text', '2/14/2002')

Re: Adding dates to a database

Xavier Shay14-Feb-02 23:43

Xavier Shay

14-Feb-02 23:43

I'm afraid that didn't work.

But, Alas! I found the solution! I changed the 'Date' field to 'DatePosted'. I presume 'Date' is a reserved word. It took me three hours to figure that out. Oh well.

Thanks for you help anyway

- X

Re: Adding dates to a database

15-Feb-02 20:08

Yup .. your right Date is a preserve word ... but by adding brackets [] it will work also like this [Date] .
Sometimes I use it when I have a field contain 2 words like [Date Posted]

Using ocx in intranet

12-Feb-02 22:26

I want to use mscomctl.ocx (tree) in intranet.
When some persone requesting site where this control is use mscomctl.ocx download and run.
But in some persone this control don't want to download.
help me.
I know that all people don't have this control.

Maybe this is only problem with properties in Security in Local Intranet. But every field is enabled.

How i can packing this to cab and give this all people in firm???

HELP ME !!! Confused | :confused:

Olek

Re: Using ocx in intranet

12-Feb-02 23:02

Another think Wink | ;)

I go to person, where the tree do not run.
I search registry and find that this control are registring as Treeview control.

What's hapend wiht that.

Netscape file upload problem

AG12-Feb-02 19:30

12-Feb-02 19:30

Hello,

If we try to upload a file from netscape 4.7 in which the file name contains non english characters, eg if the filename is in japanese then netscape gives error. Though this thing works fine thru' IE 5.0.

We are using WinNT 4.0 SP6 and also Win2K Adv server SP2.

Pl. help me solving the problem.

Regards,
A.

Minimizing the Browser Window

Paul Watson11-Feb-02 23:27

Paul Watson

11-Feb-02 23:27

How do you minimize the browser window (Internet Explorer in this case) using client side script (VBscript or JavaScript) ?

Unfortunatley the JavaScript ResizeTo method is not an option.

Also preferably not using COM components, ActiveX etc. It does run on W2K but unfortunatley WSH (Windows Script Host) is also not an option.

thanks guys.

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

Re: Minimizing the Browser Window

Konstantin Vasserman12-Feb-02 18:14

Konstantin Vasserman

12-Feb-02 18:14

It looks like you are out of luck on this one. It seems that MS removed all the positioning methods and properties from the window object. No more MoveTo, MoveBy, ResizeTo, ResizeBy. They really don't want you to control the window anymore - I guess it is a security thing.

Re: Minimizing the Browser Window

Paul Watson12-Feb-02 20:02

Paul Watson

12-Feb-02 20:02

Konstantin Vasserman wrote:
It looks like you are out of luck on this one. It seems that MS removed all the positioning methods and properties from the window object. No more MoveTo, MoveBy, ResizeTo, ResizeBy. They really don't want you to control the window anymore - I guess it is a security thing.

Same conclusion I have come to Konstantin. The odd thing is that you can fully control the position, status, size and modal-properties of a browser window if you open it via script. i.e. You cannot control an already open window, but any window you open can be fully controlled.

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

Re: Minimizing the Browser Window

Nish Nishant12-Feb-02 18:29

Nish Nishant

12-Feb-02 18:29

Now I wonder why anyone would want to do that?

Huh Paul Wink | ;-)

Nish

Nish was here, now Nish has gone;
He left his soul, to turn you on;
Those who knew Nish, knew him well;
Those who didn't, can go to hell.

I like to Jig | [Dance]

on the Code Project

Sonork ID 100.9786 voidmain
www.busterboy.org

ASP blocks in XML

Paul Watson11-Feb-02 22:12

Paul Watson

11-Feb-02 22:12

So who knows how to put ASP into XML elements without having to use &<test>l<test>t<test>;<test>%?

e.g.:

HTML

<?xml version="1.0"?>
<page>
	<title>BGCMS: Home</title>
	<content>
		<h1>Welcome to BGCMS</h1>
		<p>
			This is a wonderful <b>place!</b> <img src="test.gif"/>
		</p>
		<p>
			The time is approximatley <%=Now()%>
		</p>
	</content>
</page>

If I run that through an XSL processor, or even validated the XML, naturally the parser goes haywire and tells me that <% is an inavalid way to start a new element.

And yes Konstantin, it is another confusing and weird question Big Grin | :-D

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

Re: ASP blocks in XML

Paul Watson11-Feb-02 22:33

Paul Watson

11-Feb-02 22:33

Paul Watson wrote:
So who knows how to put ASP into XML elements without having to use <%?

So sometimes I wonder if I was born stupid, or whether my mother dropped me shortly after birth.

I figured it out and it is far easier than I imagined.

!CDATA is the way

e.g:

<?xml version="1.0"?>
<page>
	<title>BGCMS: Home</title>
	<content><![CDATA[
		<h1>Welcome to BGCMS</h1>
		<p>
			This is a wonderful <b>place!</b> <img src="test.gif"/><br/> make love not war
		</p>
		<p><%=Now()%></p>]]>
	</content>
</page>

!CDATA basically tells the XML parser to totally ignore everything within the !CDATA section. Very handy Smile | :)

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

System.Web.HttpBrowserCapabilities

Wictor Wilén11-Feb-02 21:20

Wictor Wilén

11-Feb-02 21:20

Heya,
does anyone know where the browserinformation is stored for this class? Or does it use the old Browscap stuff (ie the .ini file)?

/WW

is cold fusion the only way to do a login system?

tbbooher11-Feb-02 9:53

tbbooher

11-Feb-02 9:53

Hello -- I am trying to create a web-site for our church that has a 'profiles' section for members and also has a forums section where people can leave message simliar to the code project.

Our main question is how do we set up the login system -- the company that is hosting our site has front page server extensions installed, but also has cold-fusion. from my brief beginners knowledge it looks like cold-fusion is the only way to really do a login system.

what would you all recommend? should i just go out and buy a cold-fusion book, or are their other ways to do this.

right now we are really looking for general guidance more than anything else,

tim

---------------------------------------
Tim Booher

Re: is cold fusion the only way to do a login system?

Jon Sagara11-Feb-02 10:01

Jon Sagara

11-Feb-02 10:01

tbbooher wrote:
what would you all recommend? should i just go out and buy a cold-fusion book, or are their other ways to do this.

If you want to use the Code Project discussion forums on your site, then you'll need to find a host that supports ASP. Ask your current host, they may already support it.

You could go either way with this. I'm sure there are plenty of Cold Fusion login systems available for free, and I know there are plenty of ASP login apps available (HotScripts.com). Personally, I would use ASP, but only because I don't know Cold Fusion.

If you have to stick with your current host, then find out whether or not they support ASP. If they do, then you can use Code Project's discussion forums. If not, then you'll have to find a Cold Fusion forum to use. In the latter case, buy yourself a good book on Cold Fusion and have fun!

If you have any more questions, please feel free to ask. Smile | :)

Jon Sagara

What about ?

Sonork ID: 100.9999 jonsagara

Re: is cold fusion the only way to do a login system?

tbbooher11-Feb-02 12:15

tbbooher

11-Feb-02 12:15

Thanks for your reply . . . I definitely want to use ASP -- I was just talking with somebody and they hinted that I wanted to use the Global ASA. I have done a lot of visual basic stuff, how do I make the leap to web programming. Is there a good tutorial on ASP out there?

thanks,

tim

---------------------------------------
Tim Booher

Re: is cold fusion the only way to do a login system?

Jon Sagara11-Feb-02 13:09

Jon Sagara

11-Feb-02 13:09

Some good online references:

http://www.learnasp.com
http://www.4guysfromrolla.com
http://www.15seconds.com

You can Google for "ASP Tutorial" and you'll find tons more.

But since you already know VB, I *highly* recommend the following book:

Professional Active Server Pages 3.0 (Alex Homer et al)

If your host doesn't support ASP, then ReadyHosting.com is a nice affordable host with lots of options.

Good luck!

Jon Sagara

What about ?

Sonork ID: 100.9999 jonsagara

Re: is cold fusion the only way to do a login system?

Philip Patrick14-Feb-02 23:47

Philip Patrick

14-Feb-02 23:47

Look also in ASPIn.com. This site has references to other sites with tutorials, examples, etc.

If you are looking for paying ASP host, you can try 123HostNow.com(Feel free to strip referral info from link). Cheap and a lot of features with great support.
If you want a free web hosting, look at same ASPIn.com, you'll find there a list of them

Philip Patrick
"Two beer or not two beer?" (Shakesbeer)
Web-site: www.saintopatrick.com

Re: is cold fusion the only way to do a login system?

Paul Watson11-Feb-02 20:58

Paul Watson

11-Feb-02 20:58

tbbooher wrote:
what would you all recommend?

You can do a login system using ASP, VBScript and a database (SQL or Access or Oracle or even XML flat file etc.)

I recommend you read these very easy articles on 4GuysFromRolla.com: 4GuysFromRolla.com on Security

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

alex.barylski11-Feb-02 5:50

alex.barylski

11-Feb-02 5:50

How would a login system work...?

Client side cookies can be used to store yer name/ID can scripts on the server read client cookies...?

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Re: Login...?

Nish Nishant11-Feb-02 6:39

Nish Nishant

11-Feb-02 6:39

HockeyDude wrote:
can scripts on the server read client cookies...?

Check out:-

Request.Cookies
Response.Cookies

Smile | :)

Nish

Nish was here, now Nish has gone;
He left his soul, to turn you on;
Those who knew Nish, knew him well;
Those who didn't, can go to hell.

I like to Jig | [Dance]

on the Code Project

Sonork ID 100.9786 voidmain
www.busterboy.org

Re: Login...?

alex.barylski11-Feb-02 16:20

alex.barylski

11-Feb-02 16:20

Is that ASP...?

I've only read quickly about ASP. However it's syntax is VB and thats what i started programming in, so i'm sure it easy enough. I've only done server side programming in Perl and it doesn't have Request.Cookies object which if my memory serves me correctly...ASP does...

Anyways...what yer saying then...is yes it is possible to read client side cookies...?

This is the only way i can think of implementing a login sytem like here a codeproject.

Happy thoughts!

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Re: Login...?

Jon Sagara11-Feb-02 16:26

Jon Sagara

11-Feb-02 16:26

Don't forget the almighty database! DBs are invaluable in creating login systems.

Jon Sagara

What about ?

Sonork ID: 100.9999 jonsagara

Re: Login...?

Paul Watson11-Feb-02 21:11

Paul Watson

11-Feb-02 21:11

HockeyDude wrote:
How would a login system work...?

The easiest way is to try this simple login system from 4GuysFromRolla.com.

Simply put it uses ASP, VBScript and a database.

HockeyDude wrote:
Client side cookies can be used to store yer name/ID can scripts on the server read client cookies...?

Ok cookies are stored on the clients machine. When the client requests a page from the server the cookies that the site can access are passed long to the server in headers (I think.)

You can then use Request.Cookies() to process and change the cookies. It is VBScript and ASP but they are really easy and if you know VB you will have no problems.

Remember you only have access to cookies that you created or that are valid for your site. e.g. if your site is www.cnn.com and there is a cookie on the clients machine from www.bbc.co.uk then you will not even be able to see them.

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge

Sonork ID: 100.9903 Stormfront

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.