oh and sorry here is my connection string forgot i had it on another page
$con = mysql_connect("localhost","root","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("calendar", $con);
and yes i changed my password to the word 'password' for...
having a bit of an issue inserting some data into one of my mysql tables using php post from a html site. Keeps getting an error msg stating
"Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near...
a good way to do this is use WMI to get the model and then put some select case statements in to with a for each loop. This is something easy but in order to build it need to know where you are looking to find all the PC and list of all the installs. What I would really do is get a grasp on...
update on info. found a fix. some reason it doesn't like it when assign variables to the query strings. I changed the code to what is listed below and everything is running smooth now. no idea why it didn't like the variable for the query string. All the errors I get are as they should be now...
Ok I didn't go into work today, still sick so I just rebuilt it like I have it on my flash drive at work. I can't test it right now because I am fixing my VPN connection which I am sick and not to motivated to do that. So you can test this. It should post all the error codes in the excel...
To be honest hannable80 I still don't have a resolve for this. I keep getting error codes back on systems I should not get that error from. I don't have the full code on me right now, it is on my flash drive I left at work. I will post what I have come up with so far tomorrow and just so you can...
for each Computer in aMachines
wmiroot = "winmgmts:\\" & Computer & "\root\cimv2"
Err.Clear
set objwmi = Getobject(wmiroot)
If Err.Number <> 0 Then
wscript.echo err.number
else
wmiquery = "select * from Win32_SystemEnclosure"
set colsnnm = objwmi.execQuery (wmiQuery)...
I have on error resume next at the top because first 25 things this query hits are servers and it will prompt with a "access denied".
I did a
if computer.name = "computer name array" then
next
else
run script
end if
didn't want to list all my servers in this script on the net so I...
set objwmi = Getobject(wmiroot)
is already set higher in the page and I never closed it out so I should not have to set it again but I did try it out same results. just as an example to get what it is doing.
computer name Model comment
Computer1 Lenovo This is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.