Recent content by lsy

how can i put default in the switch function?

I have a column name priority, in this column, the data consists "Very High, High, Medium, Low and etc" how can i make a order clause acording to the Priority level? i found from this from net, but is only applicable in SQL server... how can i modify this to suit mine? SELECT * FROM TABLE...

i'm using ADO... how can i apply the parameterized query in a string of my sql statement?? i have string variable for my sql, during inserting, how can i apply parameterized query to those variable that in used? if valA is abc'de"f valB is aaa CString sql = "INSERT INTO TABLE (COLA, COLB)...

is there any one know how to transform this to VC++?? if i use replace, that would be bit messy as i need to replace ' to '' and " to \"... or anyone got any good suggestion? help...

sorry, i don't understand what is parameterized queries??

how if i want to enter a string with the combination of ' and "?? example: ab'c"def

i would like to insert an SQL statement from my application which writing in visual c++, but due to my insert data contain ' and " so is prompt error during inserting. So would like to know how can i insert an ' and " in MS Access database using the sql statement.

How can i insert a single quotation ' or double quotation " to the Ms Access database?

Is it possible to link 2 table in 1?? i wish to link tblConfiguration1 and tblConfiguration2 into tblMaster table??which like i select Configuration1 in tblMaster table it will show the data in tblConfiguration1 and select Configuration2 in tblMaster table it will show the data in...

i don't get what you means by creating view??

Is it possible i create one master table and link few table together?? In the mdb that i attached there have 3 table - tblMaster, tblConfiguration1 and tblConfiguration2. Using the relationship to link tblMaster's field Configuration to other 2 table Configuration field but there only showing 1...

i'm looking for work week not month... i try using datepart... but it unable to show me "ww yyyy" in one record. thanks.

i would like to querry a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when go to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this?

is it "IS NULL" and "IS NOT NULL" same with " = NULL" and "<> NULL"?

there is a end_date column record with date/time datatype, how could i query datat that showing the particular is empty. i try end_date = NULL, no record is showing and end_date = ' ' , datatype mismatch... so which one should i write??