473,378 Members | 1,236 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

% and * not consistent

BeemerBiker
% works fine in the Access SQL query windows. % does not work at all in C# code using the AccessDataSource.SelectCommand. I have to use * for my wildcard in dotnet c#

I tried googleing my question but got too many hits because of those symbols

Is there some meta command where I can tell asp dotnet access to use % instead of * ?

unaccountably, % also seems to work fine in perl using

$dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);dbq='.
etc


just seems to be a problem in VS2008 with C# and asp dotnet.

thanks for looking
Mar 24 '09 #1
2 1341
ChipR
1,287 Expert 1GB
You'll get plenty of leads if you google with the words "percent" and "asterisk"
Mar 25 '09 #2
NeoPa
32,556 Expert Mod 16PB
ANSI Standards in String Comparisons may help, at least with understanding where the complications come from.

NB. I would expect that the ANSI-92 standard (% & _) is where everything will move to eventually.
Apr 4 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Robert Oschler | last post by:
Is there a Javascript function, or library, that will take a URL and make it uniform/consistent? Something that will resolve all relative pathing and the current domain and protocol and return a...
3
by: ssb | last post by:
Hello, I have multiple forms in my access application. I want all the forms to have consistent formatting for fields appearing on the forms (i.e. same background color, fonts, font color etc). ...
2
by: RBohannon | last post by:
I need to create a report in MS Word populated with data from A2K. I have been asked to create the report in Word so that parts of it can be edited as necessary later. The data in the report are...
1
by: Bret Pehrson | last post by:
I've converted a non-trivial C++ library to managed, and get the following unhelpful linker error: Assignment.obj : error LNK2022: metadata operation failed (80131195) : Custom attributes are...
1
by: Tamas Demjen | last post by:
I started to experiment with VC++ 2005 Beta1. So far everything went fine, and already have a working project, but soon I realized that the compiler was ancient (not supporting half of the C++/CLI...
1
by: lovecreatesbeauty | last post by:
There is a warning/(error? I remember it is an error for line 10 on some compilers before. At least on g++, it is an error.) for line 10. I first read a similar example from `Expert C Programming...
8
by: digitalorganics | last post by:
What are the reason one would get this error: TypeError: Cannot create a consistent method resolution order (MRO) for bases object ?? I can provide the code if needed....
8
by: jpullam | last post by:
It was suggested elsewhere by a moderator that it is a good practice to use "* {margin:0}" at the beginning of my style sheet to turn off the browser-dependent spacing. Presumably this is one step to...
2
by: Ryan Liu | last post by:
Hi, I am using TreeNode.NextVisibleNode to loop though all nodes in a tree. I think this is faster than using recursive algorithm. But I found this method is not consistent. Sometime it...
0
by: TimeHorse | last post by:
Is there a consistent way to map a frame object to a function / method object? Methods usually hang off of parameter 1, and functions usually in the global or local scope. But lambda functions...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.