• Join/Login
  • Business Software
  • Open Source Software
  • For Vendors
  • Blog
  • About
  • More
    • Articles
    • Create
    • SourceForge Podcast
    • Site Documentation
    • Subscribe to our Newsletter
    • Support Request
SourceForge logo
For Vendors Help Create Join Login
SourceForge logo
SourceForge logo
Business Software
Open Source Software
SourceForge Podcast
Resources
  • Articles
  • Case Studies
  • Blog
Menu
  • Help
  • Create
  • Join
  • Login
  • Home
  • Browse
  • Openbiz PHP Framework
  • Patches
Openbiz PHP Framework

Bug parsing multiple fields within an sqlexpression

Openbiz is a PHP Framework for building Enterprise web applications

Brought to you by: jixian2003, openbizjack, rockys
  • Summary
  • Files
  • Reviews
  • Support
  • Tickets ▾
    • Support Requests
    • Patches
  • External Link ▾
    • Donate
    • Discussion
    • Google Project Page
  • Code
  • Mailing Lists
Menu ▾ ▴
  • Create Ticket
  • View Stats

Group

Searches

  • Changes
  • Closed Tickets
  • Open Tickets

Help

  • Formatting Help

#4 Bug parsing multiple fields within an sqlexpression

open
nobody
None
5
2013-02-03
2008-01-12
Juan Carlos Gonzalez
No

There is a way to break the method:
BizDataObj::ConvertSqlExpresion()

If for any reason the replaced text after line 1199 [[sqlstr = str_replace("[$fieldname]", $tableColumn, $sqlstr);]] is shorter than the original one, the strpos calculated in that iteration might cause substr_lr to fail to find the next field name between []

So I added up at line 1200:
$startpos = strpos($sqlstr, '['); // Move startpos to the first [ (if it exists) in order to be detect by next itteration

Final version attached based on openbiz 2.2.2rc

Discussion

  • Juan Carlos Gonzalez

    Juan Carlos Gonzalez - 2008-01-12
     
    BizDataObj.php
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.

SourceForge
  • Create a Project
  • Open Source Software
  • Business Software
  • Top Downloaded Projects
Company
  • About
  • Team
  • SourceForge Headquarters
    225 Broadway Suite 1600
    San Diego, CA 92101
    +1 (858) 422-6466
Resources
  • Support
  • Site Documentation
  • Site Status
  • SourceForge Reviews
SourceForge logo
© 2025 Slashdot Media. All Rights Reserved.
Terms Privacy Opt Out Advertise
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.