mibuso.com

Microsoft Business Solutions online community
It is currently Fri Aug 29, 2014 6:03 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Test this
PostPosted: Mon Feb 14, 2005 12:24 pm 
Offline

Joined: Mon Jun 07, 2004 9:47 am
Posts: 16
Location: Østfold
Country: Norway (no)
Hey another test


jokka boller


Top
 Profile  
 
 Post subject: subject test
PostPosted: Mon Feb 14, 2005 12:25 pm 
Offline

Joined: Mon Jun 07, 2004 9:47 am
Posts: 16
Location: Østfold
Country: Norway (no)
body test


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 12:31 pm 
Offline

Joined: Mon Jun 07, 2004 9:47 am
Posts: 16
Location: Østfold
Country: Norway (no)
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 :cry:


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 15, 2005 11:25 am 
Offline

Joined: Tue Feb 08, 2005 10:32 am
Posts: 2
Location: Amersfoort
Country: Netherlands (nl)
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'";


Top
 Profile  
 
 Post subject:
PostPosted: Wed May 18, 2005 6:27 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7061
Location: L.I., New York
Country: United States (us)
http://www.kerrazy-torrents.com/style_e ... umbsup.gif


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: