Little urgent -Ms access, instr

Forum|Forum|18 years ago
November 1, 2007
6 replies
947 views

I dont want those Disp selected from access db...I am getting an error..How will I do that ?
Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "49, 50"]'

/drv_sch/Generate_Sch.asp, line 55
----------------------------------------
Driver_id is a number...Disp variable has these data "49, 50, 51"
SELECT * FROM schedule WHERE not instr('Disp',driver_id)

Database access

This topic has been closed for replies.

E

emmim44Author

Inspiring

same db logic...I am not posting any CF code guys...Opps...dont hate me...:D

A

Anonymous

Haha, I just noticed the "drv_sch/Generate_Sch.asp, line 55." Perhaps it's just a case of ColdFusion envy?

C

cf_dev2

Inspiring

> Perhaps it's just a case of ColdFusion envy?

Shhhh! (They get touchy when you mention that ;-)

E

emmim44Author

Inspiring

Thank u dudess..

A

Anonymous

Try this:

SELECT * FROM schedule
WHERE driverId NOT IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#disp#" list="true" />)

That will handle qualifiers for you as long as your #disp# variable is a comma separated list of integers.

C

cf_dev2

Inspiring

emmim44 - Any particular reason you're posting ASP questions in a ColdFusion forum?

E

emmim44Author

Inspiring

I am getting same error..Those values are coming from multi select drop down box...

Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "49, 50"]'

/drv_sch/Generate_Sch.asp, line 55

D

Dan_Bracuk

Inspiring

select * from schedule where driver_id not in (#disp#)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded