Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
Testing
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
310
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Test this
dagviggo
Member
Posts:
20
2005-02-14
edited 2005-05-18
in
Testing
Hey another test
jokka boller
0
Comments
dagviggo
Member
Posts:
20
2005-02-14
body test
0
dagviggo
Member
Posts:
20
2005-02-14
I also experience the same problem when searching in php.
<?php
$db = odbc_connect ("Navision", "user", "pass") or die("Unable to connect to ODBC");
$query = "select * from Customer where Name like '$search_str'";
?>
No matter how I write the search string, it always does a case sensitive search
0
mvdvis
Member
Posts:
2
2005-02-15
Try something like this:
$query = "select * from Customer where UPPER(Name) like '$search_str'";
OR
$query = "select * from Customer where LOWER(Name) like '$search_str'";
0
Savatage
Member
Posts:
7,142
2005-05-18
http://www.kerrazy-torrents.com/style_e ... umbsup.gif
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org
0
Sign In
or
Register
to comment.
Comments
<?php
$db = odbc_connect ("Navision", "user", "pass") or die("Unable to connect to ODBC");
$query = "select * from Customer where Name like '$search_str'";
?>
No matter how I write the search string, it always does a case sensitive search
$query = "select * from Customer where UPPER(Name) like '$search_str'";
OR
$query = "select * from Customer where LOWER(Name) like '$search_str'";
http://www.BiloBeauty.com
http://www.autismspeaks.org