Web Wiz Support and Community Forums : Databse - ASP str" command help needed https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 13:39:25 +0000 Fri, 16 Jan 2004 12:12:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8977 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Databse - ASP str" command help needed : I&#039;ve still not owrked out...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47359.html#47359 Author: WebWiz-Bruce
Subject: 8977
Posted: 16 January 2004 at 12:12pm

I've still not owrked out what you are doing.

Your best bet is give it ago and see if it works, if it doesn't mess with it somemore till it does.
]]> Fri, 16 Jan 2004 12:12:16 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47359.html#47359 <![CDATA[Databse - ASP str" command help needed : OKAY thanks -boRg- for you r answer..Is...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47357.html#47357 Author: cheops@collecto
Subject: 8977
Posted: 16 January 2004 at 11:48am

OKAY thanks -boRg- for you r answer..


Is it then right of me to understand, that I don’t have to change that part of the code.. or am I wrong…

]]> Fri, 16 Jan 2004 11:48:38 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47357.html#47357 <![CDATA[Databse - ASP str" command help needed : strUsername in that line is the...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47353.html#47353 Author: WebWiz-Bruce
Subject: 8977
Posted: 16 January 2004 at 11:33am

strUsername in that line is the name of the variable that stores the persons username throughout the forum code.

str is not an ASP command, all the str part of the variable issomething I put in as I use this as part of my naming convention whenprogramming so I know what datatype the variable contains.

I use the following naming conventions in my code for variables:-

str = string
int = interger
lng = long interger
dbl = double
bln = booleon
dtm = date
cur = currency
etc.

These are not commands just something I simply place in to help me when I am coding.
]]> Fri, 16 Jan 2004 11:33:20 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47353.html#47353 <![CDATA[Databse - ASP str" command help needed : I know - I know - And that’s just...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47350.html#47350 Author: cheops@collecto
Subject: 8977
Posted: 16 January 2004 at 11:17am

I know - I know - And that’s just what I’m doing right now...

I only need to know this last thing about the "str" command

but okay - let me try to ask another way -

What does the line strUsername do in those lines:

'Read in the users details from the form
strUsername = Trim(Mid(Request.Form("name"), 1, 15))
strPassword = LCase(Trim(Mid(Request.Form("password"), 1, 15)))
blnAutoLogin = CBool(Request.Form("AutoLogin"))


'Take out parts of the username that are not permitted
strUsername = Replace(strUsername, "password", "", 1, -1, 1)
strUsername = Replace(strUsername, "salt", "", 1, -1, 1)
strUsername = Replace(strUsername, "author", "", 1, -1, 1)
strUsername = Replace(strUsername, "code", "", 1, -1, 1)
strUsername = Replace(strUsername, "username", "", 1, -1, 1)

I have not yet tested the changes - I’m changing the name of the variables for every instance of the variable within the code and changing it right now .

]]> Fri, 16 Jan 2004 11:17:07 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47350.html#47350 <![CDATA[Databse - ASP str" command help needed : What you are proposing would not...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47347.html#47347 Author: WebWiz-Bruce
Subject: 8977
Posted: 16 January 2004 at 11:07am

What you are proposing would not work, changing the name of thevariables would mean finding every instenace of the variable within thecode and changing it.
]]> Fri, 16 Jan 2004 11:07:50 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47347.html#47347 <![CDATA[Databse - ASP str" command help needed : I know that I have changed all...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47341.html#47341 Author: cheops@collecto
Subject: 8977
Posted: 16 January 2004 at 11:00am

I know that I have changed all tables setting in and for database.

I only need to know if I need to change those variables !

and what they do and what the str command stand for ?

 

]]> Fri, 16 Jan 2004 11:00:14 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47341.html#47341 <![CDATA[Databse - ASP str" command help needed : I don&#039;t think what you are...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47338.html#47338 Author: WebWiz-Bruce
Subject: 8977
Posted: 16 January 2004 at 10:55am

I don't think what you are trying will work.

The database is a relational database so any users posting in the forumneeds an entry in the tblAuthors table to relate the post and otherfetaures in the forum to. Without this entry the forum will not run.
]]> Fri, 16 Jan 2004 10:55:21 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47338.html#47338 <![CDATA[Databse - ASP str" command help needed : The code that you&#039;ve mentioned...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47337.html#47337 Author: gavinc
Subject: 8977
Posted: 16 January 2004 at 10:53am

The code that you've mentioned in your original post won't need changing if you change the column names on the database.

What you need to be careful of is to change anything that looks like rsCommon.Fields("username") to rsCommon.Fields("intAccessUserName"). Do the same as well for the password column.

 

]]> Fri, 16 Jan 2004 10:53:12 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47337.html#47337 <![CDATA[Databse - ASP str" command help needed : gavinc wrote: Sorry if I&#039;m...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47335.html#47335 Author: cheops@collecto
Subject: 8977
Posted: 16 January 2004 at 10:46am

Originally posted by gavinc gavinc wrote:

Sorry if I'm being a bit dense here but why are you making these changes?

strusername and strpassword are just variables, not asp commands.

 



I´m making those changes in order to incorporate WWF forum to my running CMS system. 

And I´m asking couse i´m unsure if I need to rename those variables in order to make the complete database fusion....



Edited by cheops@collecto]]> Fri, 16 Jan 2004 10:46:00 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47335.html#47335 <![CDATA[Databse - ASP str" command help needed : Sorry if I&#039;m being a bit...]]> https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47334.html#47334 Author: gavinc
Subject: 8977
Posted: 16 January 2004 at 10:36am

Sorry if I'm being a bit dense here but why are you making these changes?

strusername and strpassword are just variables, not asp commands.

 

]]> Fri, 16 Jan 2004 10:36:43 +0000 https://forums.webwiz.net/databse-asp-str-command-help-needed_topic8977_post47334.html#47334