10 Replies - 740 Views - Last Post: 07 October 2008 - 05:21 AM Rate Topic: -----

#1 yr4icka_85  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 26-March 08

please help me....

Posted 29 September 2008 - 09:44 PM

Attached ImageAttached ImageAttached Image

Private Sub Command1_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors WHERE Author ORDER by 'g*[e-o]'"
Adodc1.Refresh
End Sub

Private Sub Command2_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors order by Author  ASC"
Adodc1.Refresh
End Sub

Private Sub Command3_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors order by 'T'"
Adodc1.Refresh
End Sub






this is my code in vb...my teacher told me to sort the authors. First in ascending order second in the authors should start from T and last all the the authors will start from G followed by and o. With that code.. Only the ascending appears correctly.. Can you help me? please i really need your help..Thankz. Ill attach the photo of my work... I am a beginner.Please help me. See the photo of my work. My codes for authors that starts with G and With T isnt working... Please help... I owe you a lot thank you so much!!

Is This A Good Question/Topic? 0
  • +

Replies To: please help me....

#2 DilutedImage  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 646
  • Joined: 20-November 06

Re: please help me....

Posted 30 September 2008 - 12:42 AM

Sorry, but I won't do your homework for you. I'll throw you a bone though. .. First, learn the correct way to use ORDER BY. Second, learn about the LIKE statement. W3Schools and Tizag are good places to start. Don't just jump to those sections though read from the beginning. They're quick and easy, and will give you a good foundation in SQL statements.

2
Was This Post Helpful? 0
  • +
  • -

#3 no2pencil  Icon User is online

  • Admiral Fancy Pants
  • member icon

Reputation: 5382
  • View blog
  • Posts: 27,350
  • Joined: 10-May 07

Re: please help me....

Posted 30 September 2008 - 12:46 AM

I have a bookmark for W3schools just for their SQL syntax. :^:
Was This Post Helpful? 0
  • +
  • -

#4 yr4icka_85  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 26-March 08

Re: please help me....

Posted 30 September 2008 - 01:51 AM

View Postno2pencil, on 30 Sep, 2008 - 12:46 AM, said:

I have a bookmark for W3schools just for their SQL syntax. :^:




can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!
Was This Post Helpful? 0
  • +
  • -

#5 yr4icka_85  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 26-March 08

Re: please help me....

Posted 30 September 2008 - 02:05 AM

View Postno2pencil, on 30 Sep, 2008 - 12:46 AM, said:

I have a bookmark for W3schools just for their SQL syntax. :^:




can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!
Was This Post Helpful? 0
  • +
  • -

#6 dlkirk03  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 36
  • Joined: 12-September 08

Re: please help me....

Posted 30 September 2008 - 06:51 AM

http://www.w3schools...sql/default.asp
Was This Post Helpful? 0
  • +
  • -

#7 DilutedImage  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 646
  • Joined: 20-November 06

Re: please help me....

Posted 30 September 2008 - 10:16 AM

View Postyr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

:D
Was This Post Helpful? 0
  • +
  • -

#8 yr4icka_85  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 26-March 08

Re: please help me....

Posted 01 October 2008 - 08:20 PM

View PostDilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

View Postyr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

:D




ok!you dont need to be like that...im sorry...
Was This Post Helpful? 0
  • +
  • -

#9 yr4icka_85  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 26-March 08

Re: please help me....

Posted 01 October 2008 - 09:53 PM

View Postyr4icka_85, on 1 Oct, 2008 - 08:20 PM, said:

View PostDilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

View Postyr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

:D




ok!you dont need to be like that...im sorry...



hey!!i got it...harhar...thnx a lot...where can i find basic game tutorial in vb 6.0...tnx
Was This Post Helpful? 0
  • +
  • -

#10 DilutedImage  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 646
  • Joined: 20-November 06

Re: please help me....

Posted 07 October 2008 - 01:05 AM

It got you to read. :D

Now as for "basic game", that's an oxymoron.
Was This Post Helpful? 0
  • +
  • -

#11 jjsaw5  Icon User is offline

  • I must break you
  • member icon

Reputation: 90
  • View blog
  • Posts: 3,060
  • Joined: 04-January 08

Re: please help me....

Posted 07 October 2008 - 05:21 AM

View Postyr4icka_85, on 1 Oct, 2008 - 11:53 PM, said:

View Postyr4icka_85, on 1 Oct, 2008 - 08:20 PM, said:

View PostDilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

View Postyr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

:D




ok!you dont need to be like that...im sorry...



hey!!i got it...harhar...thnx a lot...where can i find basic game tutorial in vb 6.0...tnx



On the internet! Go to google and search for "VB 6.0 game tutorials" not that hard.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1