|
Thanks,that was exactly you said
Mazy
Don't Marry a Person You Can Live With...
Marry Someone You Can Not Live Without
|
|
|
|
|
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
|
|
|
|
|
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')
|
|
|
|
|
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
|
|
|
|
|
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]
|
|
|
|
|
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 !!!
Olek
|
|
|
|
|
Another think
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Now I wonder why anyone would want to do that?
Huh Paul
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 on the Code Project
Sonork ID 100.9786 voidmain
www.busterboy.org
|
|
|
|
|
So who knows how to put ASP into XML elements without having to use &<test>l<test>t<test>;<test>% ?
e.g.:
<?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
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
|
|
|
|
|
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
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
Jon Sagara
What about ?
Sonork ID: 100.9999 jonsagara
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
HockeyDude wrote:
can scripts on the server read client cookies...?
Check out:-
Request.Cookies
Response.Cookies
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 on the Code Project
Sonork ID 100.9786 voidmain
www.busterboy.org
|
|
|
|
|
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
|
|
|
|
|
Don't forget the almighty database! DBs are invaluable in creating login systems.
Jon Sagara
What about ?
Sonork ID: 100.9999 jonsagara
|
|
|
|