https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:37:46 +0000 Fri, 29 Feb 2008 00:46:58 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25321 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131652.html#131652 Author: freakdaddy
Subject: 25321
Posted: 29 February 2008 at 12:46am

Ok, I bet if I say I'll pay someone money I'll get a response.

I need someone to work out this issue, and also pull data from WWF's cookies properly. If someone is interested in doing this, PM me.
]]> Fri, 29 Feb 2008 00:46:58 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131652.html#131652 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131643.html#131643 Author: freakdaddy
Subject: 25321
Posted: 28 February 2008 at 7:15am

Everything is running 100% fine. I just need to know how to open the database. I've tried everything that I think would be beyond obvious, and I just can't get it to work. ]]> Thu, 28 Feb 2008 07:15:44 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131643.html#131643 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131640.html#131640 Author: StarDust
Subject: 25321
Posted: 28 February 2008 at 6:38am

Is everything else is running? The forum? If it is, the solution is unknown to me. Sorry.
]]> Thu, 28 Feb 2008 06:38:52 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131640.html#131640 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131637.html#131637 Author: freakdaddy
Subject: 25321
Posted: 28 February 2008 at 1:25am

Thanks..

Yeah, I had done all of the above already. There's something else that's not right, but I don't know enough about mysql to figure it out. It's kind of beyond frustrating because it shouldn't be that difficult. I just want to open the WWF mysql database and from the author_id, or actually the user_code table.

My whole syntax may be incorrect, so just some direction about how you'd set this up to open the database would be very very helpful.


]]> Thu, 28 Feb 2008 01:25:08 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131637.html#131637 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131613.html#131613 Author: StarDust
Subject: 25321
Posted: 27 February 2008 at 9:13am

freakdaddy,

If the problem still persists, then there might be some other things wrong. Here is a checklist for you:

1. Make sure the changes you have made in the code of wwf is correct.
2. In some rare occasions, when database is corrupt, i have seen the same error. Try with a fresh database.
3. Make sure GID has a numeric value when executing the SQL statement. Change it from GID = "5" to GID = 5
4. In your code, the value of strDBNoLock might be wrong. Try following SQL statement:

strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author " & _
    "WHERE " & strDbTable & "Author.Author_ID=" & GID & " ;"

This way my problems were gone.



Edited by StarDust - 27 February 2008 at 9:18am]]> Wed, 27 Feb 2008 09:13:35 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131613.html#131613 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131611.html#131611 Author: freakdaddy
Subject: 25321
Posted: 27 February 2008 at 7:49am

help... still stuck ]]> Wed, 27 Feb 2008 07:49:23 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131611.html#131611 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131579.html#131579 Author: freakdaddy
Subject: 25321
Posted: 25 February 2008 at 7:02am

Thanks... so technically, this should work?

     strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author" & strDBNoLock & " " & _
    "WHERE " & strDbTable & "Author.Author_ID = " & GID & " " &";"

Do I need the end semi-colon or not? I dunno, but I just need some kind of syntax for mysql so that I can open the database and select data from the author_ID table. So lost at this point. Wasn't expecting it to be this difficult to find the correct format.
]]> Mon, 25 Feb 2008 07:02:49 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131579.html#131579 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131570.html#131570 Author: StarDust
Subject: 25321
Posted: 24 February 2008 at 11:00am

WebWiz-Bruce wrote: The part strDBNoLock is only used for SQL Server databases.

Freadkdaddy, as Bruce said, it is only used for SQL Server databases.

However there is another variable which controls the value of "strDBNoLock". This variable "strDatabaseType". When you set strDatabaseType = "mySQL" in database/database_connection.asp off WWF installation, strDBNoLock becomes an empty variable with no value. So, it is all the same using the variable or not. But make sure you have a trailing space in your SQL syntax after these variables.
]]> Sun, 24 Feb 2008 11:00:25 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131570.html#131570 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131569.html#131569 Author: freakdaddy
Subject: 25321
Posted: 24 February 2008 at 6:13am

WebWiz-Bruce wrote: The part strDBNoLock is only used for SQL Server databases.

Yeah, I was just following the syntax that you guys had in their. It seems to be used all of the time, and it's value was set in another file. So should I take this out when using MySQL?
]]> Sun, 24 Feb 2008 06:13:27 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131569.html#131569 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131525.html#131525 Author: StarDust
Subject: 25321
Posted: 21 February 2008 at 9:37am

WebWiz-Bruce wrote: The part strDBNoLock is only used for SQL Server databases.

Bruce isn't wwf use different values for strDBNoLock and strDBRowLock according to strDatabaseType variable value?
]]> Thu, 21 Feb 2008 09:37:58 +0000 https://forums.webwiz.net/mysql-newbie-syntax-question_topic25321_post131525.html#131525