Search results

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??

same too the record of 04/05/2006 is not showing.

if the beween statement is use as "number between 1 and 7" so record with number 1,2,3,4,5,6,7 will be showing right?? but what if using in date?? example mydate between #04/01/2006# and #04/05/2006# the record i aspect is 04/01/2006, 04/02/2006, 04/03/2006, 04/04/2006, 04/05/2006 but it just...

ya got it... but actually this is just part of it, when i apply this to my query, other record might not be able to query out.. my table consist of start_date, end_date, NumberOfFail... what i need is i need to know got how many days in the record, get the total of NumberOfFail, and get the...

it does not group in distinct. it return the number of all record. if my table have 22 record, it return 22. what i want is distinct out the date and count the record.

How can i get the count of date inside a database. the date might be duplicate, so i would like to know how many days are in the table. i try in this way... SELECT count(distinct( format([mydate],"dd/mm/yyyy"))) as DayCount from tbl but error message "undefined function 'distinct' in...