alcstudio
Last Activity: Feb 19 '08, 08:11 AM
Joined: Sep 8 '07
Location:
-
Thanks. I have used Access for to long. -
Random posts from mysql
Hey there. i wonder how i do to get 4 radom posts displayed on my webpage from mysql.
For example. If i have total 10 images and every time i reload the page it changes between this 10 and show 4. -
Setup GAL in Exchange for Outlook
Hey there. Whould like to know how i configure a Global Adress List (GAL) on Exchange for Small Business Server.
I have googeld this but only get how it works not how to do it.
So whould be more than grateful with some help on this one. -
I did get it to work with this:
strborn = ""&request.form ("yyyy")&"-"&request.form( "mm")&"-"&request.form( "dd")&""Leave a comment:
-
Please guys really need help with this.. This is the last thing thats not working.Leave a comment:
-
Ok. Anyone have a solution on this one.. I Have googeld this and just get how you do it local.Leave a comment:
-
When i do so i get:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]Incorrect datetime value: '1/1/1960' for column 'personnf' at row 1
You can see that the date is in wrong order but in the code right.
How do i fix this? if i fix it in right order do you think it will work.Leave a comment:
-
"date-to-be-inserted" Hmm dont understand =). I know that the date format is YYYY-MM-DD.
What code do you want to see ? The insert code? If it so here it is:
...Code:objconn.execute("INSERT into konton (anvnamn, losen, epost, fornamn, efternamn, personnf, personns, hur, reggad, kon) Values ('"&request.form("anv")&"', '"&request.form("losen")&"', '"&request.form("epost")&"',Leave a comment:
-
Connect application to remote mysql db
Hello everyone. Iam building a application and iam wondering how i connect the application to remote mysql db.
I know so much this far that i must add web.services to resources in the project but now what.
Whould like a guide on this. Iam a using Visual Basic 2008 express edition, -
DateTime Value 0000:00:00 in MySQL
Hey there. I have a problem whit some date insert.
I Have 3 dropdownlists and i want the code to get the values and insert them in the database,
the code looks like this:
yyyy = Request.Form("y yyy")
mm = Request.Form("m m")
dd = Request.Form("d d")
strborn = DateSerial(yyyy ,mm,dd)
Its insert everything but not the date. only get 0000:00:00.... -
Will see how I can to explain this simple.
What I want to do is that projects will be retrieved out from the table projekt
where costs in kostnader have status = 1
So if kostnader has 3 post named:
ABB and ID = 1 and projekt_id = 1 and status = 1
ABBA and ID = 2 and projekt_id = 1 and status = 1
ABBAS and ID = 3 and projekt_id = 1 and status = 1
If the...Leave a comment:
-
I want to pull out all post from projekt where status = 1 in kostnader. So if projekt named monkey in projekt table have id 3 and colum projekt_id has same id and all these 3 have status = 1 i want it to pull out monkey from projekt table.
Its a bit tricky to explain =)
I want it to check all posts in kostnader so if its 4 posts and 3 posts of these 4 have status = 1 i dont want it to pull out the post from projekt,...Leave a comment:
-
Advanced SQL and error (advanced i guess)
Have this SQL-string:
And i get this error:Code:SQL = "select id as pid from projekt union select count(*) as totalt from kostnader where id = pid and status = 1"
* No value given for one or more required parameters.
What i want to do
Now iam gonna try to explain how i want this to work. I want this code to select the projekt from the table projekt if all the posts in the table kostnader... -
Anyone knows why i get this error, nothing in the database is wrong anyway :DLeave a comment:
-
Should i just replace "oitem" whit "oRegExp" ? The thing is the only thing that you type in in the textbox is a number so dont follow why i should have a function thats just take the numbers in the textbox, thats the only thing you will be writing.Leave a comment:
-
Really good man. Thumbs up, but how do i use the function whit the code?Leave a comment:
-
The ending on the code did get wrong, i saw it when i had posted it so the extra dose not exist.
The datatype for the colum belopp is Number. and the value its suppose to put in is a number. =).
The code looks like this now.
...Code:If Request.QueryString("do") = "spara_traktamente" Then For Each oItem In Request.Form If oItem = "belopp" ThenLeave a comment:
-
Sorry for this dubble post but in other forum the response is quick, but i guess that the most of the members are asleep. Iam living in sweden so the clock is not the same i guess.,Leave a comment:
-
My SQL-string is the devil !
Hello there i have made a SQL-string thats the devil him self.
Here is the working one, here its take the value "Tim" from same table wich is "kostnader" but i want to take the "Tim" value from another table.
Working code
...Code:SQL = "SELECT projekt.projekt, projekt.id, projekt.lock, (SELECT COUNT(ID) FROM kostnader WHERE kostnader.personal_id = "& session("id") -
Now i have tried to get this to work but i wont. Whats the problem exactly, can someone give me a hint. I know what the error says but how i turn and twist this it wont work. so should be great whit some more help.Leave a comment:
No activity results to display
Leave a comment: