I just learned PHP and I am using it in conjunction with mySql. I just wanted to say that php rules. It is really easy. I run a wrestling roleplay site and the members can actually edit there own pages but I dont have to give them a password to my site. They run there own stable bio and things like that so for those of you who have not yet checked out php take a look into it. Also if using php all a person will see when they click on view and source is just whatever html you used which means sometimes they will see nothing at all but if there is something that I am not seeing that php is bad let me know

i found the solution if you want to use something like 'jake's bigtime' in an insert statement then you would have to simply put two apostrophies and sql will then put the one apostrophe character in the db so the query would look like this insert into test values('jake''s bigtime') and a this query select * from test would return jake's bigtime

no its not vb that has the problem its doesnt think its a comment its when its submitted to the stored procedure that it gets the problem like the stored procedure would accept this execute mystoreproc 'blah','blah' no problem but when you have something like this execute mystoreproc 'blah's','blah' the stored proc will interpet it like this execute mystoreproc 'blah' s ,'blah' because sql uses the ' character to enclose strings that are inserted or otherwise used in queries

i have a problem i have a vb6 program which at one point calls a stored procedure that accepts two strings as arguments but there are certain times when on of the strings contains a ' for example execute mystoredproc 'blahblah', 'jame's' this of course generates an error because it thinks that the letters jame is the whole string being submitted so how can i change this so it accepts it

i am trying to get the number of files returned when you use the getfiles function so i dont have to run through them first. the getlegth part accepts a parameter called dimension which is a zero based array but i dont know what to give it any help would be much appreciated

nevermind i got it

i can't seem to find this on the web. How do you not only connect to a sql database with vb.net but i need to know how to execute sql statements. Some return values other do not(like a select and a delete for instance)

hey i have a project where i need to read from a text file but i will never know how long it is. It is basically a list of numbers. I read them in and store them in a collection but how do i know when the end of file is? this is in VB.Net

nevermind i got it fixed

thanks a billion man

i have tried that but cant quite get the syntax right could you provide a little more help and by the way thanks

i have a program that goes into a folder looks into each subfolder and gets all the .jpg files and stores the file names in an array which i then use to insert the path into a msde database. My problem is either one of two things happen 1.the form freezes but the program still does what it needs to 2.or the program simply just freezes the machine i am using has 1 ghz processor and 786 mb ram and my uses will not have computers even close to this so anybody have any suggestions?

ok i work for a company and we use msde for our software that we distribute. This means we need to run creation scripts on every new customer. I know there is a tool called osql. we have the msde database using windows auth. where i run into a problem is when i put this on someones machine and try to run osql it asks me for a password. it does not ask for a user name and you can't type anything in for the password so i hit enter and then it tells me that it is invalid so how do i go about fixing this problem?

is there a way to install a msde database using an instance name that doesnt put the computer name in front of it? basically if you dont put an instance name in the setup ini file then the name of the instance will be your computer name. so i gave it one and now instead of the instance being say Developer1 its is now Developer1\Sql1 i have even tried completely uninstalling sql and installing only the msde but to no avail anyone have any ideas?

you can just store the image path in the database and then use the load picture function and use the path stored in the database if you dont know these functions i know i have the code somewhere i would have to find my .net version but i know exactly where my vb6 version is so let me know if you need further help

thats not exactly what im looking for. it is vb6 and the reason i came here was to find some help normally i would just use this one sort function but the problem is the elements in the array are all instances of the player class so not only do i need to find out the 1st 2nd and 3rd place winners but i need to know the names of them which makes it a little more noodle scratching than a normal array and the thing that sucks most is i can see the solution on the back of my brain well anyways if anyone has any ideas

hey i dont know if your still having the problem with keeping track of a user's logged in status but a simple way would be to create a loggedin field on the end of the user's record and when they login set that field equal to 1 and when they log out set it to 0

i had a similar problem with vb.net first i had coded the game yahtzee in vb6 and it worked fine then i was converting it into vb.net and after i got all the stuff out of the way i ran it in debug mode and i saw i got 5 random numbers which i use to change the pictures of the die showing but when i took it out of debug mode i get the same five numbers like i get all 1's or all 2's etc but the moment i put it into step by step debug it works perfectly again so maybe its a bug in .net cause i got pretty pissed off because i thought how in the hell do i debug something that works perfect in debug mode? don't know if this helps or not

i am in the process of writing a game called bunco and i have hit one of those walls. Basically i have an 12 element array and at the end of the game i need to find out which element holds the highest value,which holds the second highest, and what holds the third highest but i also need to find out if there is a tie for any of those spots now i know the long way to do this but was hoping that someone might know a shorter and more effiecient way

you could buy either the complete idoits guide to vb or vb6 for dummies but i recommend the idiots guide they are always better