Breadcrumbs

[Dummy1912]

Hello,

can anyone tell me why this don't work?

i get as error can't find an column with the name: cast.month & cast.year

Code: Select all

SQLcommand.CommandText = "SELECT DISTINCT cast.id,cast.name Relation FROM cast LEFT JOIN address ON cast.description=address.id LEFT JOIN users ON cast.by=users.id where cast.month='" & Date.Today.Month & "' and cast.year='" & Date.Today.Year & "'"

it must select the current month and date to show the cast user
but is not working.

thank you

[Dummy1912]

hello

even this code has the same error

Code: Select all

SQLcommand.CommandText = "SELECT cn.id, cn.type, cl.name FROM loananddebt AS cn JOIN addresspayee as cl ON cn.description = cl.id WHERE cn.month ='October' AND cn.year ='2013'"

no such column with the name cn.month and cn.year

why??
the tables does exist in the database

[smashapps]

go into the table in the database and check if you have the rows in that corresponding table.

you might say the table exists, but does the rows in the table exist?

[Dummy1912]

yes it does exists #smashapps

[smashapps]

#Dummy1912

Could it be you're using the wrong case? Like the table could be capitals but you're calling it using lowercase? I don't have too much information so I can't help too much

[Dummy1912]

as you can see #smashapps the month and year are lowercase
so i don't know why it don't work

so what else do you need to help??

[smashapps]

add ' ' to the column names

[Dummy1912]

its okay got it working
seems i got a little nerner;

seems i got the column name month_
so thats why

so thanks anyway #smashapps
and sorry :(