Menu
▾
▴
web-erp-developers
|
From: Jesse P. <je...@st...> - 2004-10-12 17:57:58
|
Steve, please be mindful to have a grasp of the problem before posting = things... this may simply confuse everyone or get 2 or 3 people doing = the same things, especially since you have posted a bit of code that is = different than what Melvin on the Users list is using. I know you are = trying to be helpful, but, in general, having to wade through emails = with lots of guesses & maybes, but little solid information is not = horribly helpful. That said, I have his version of this, from the 2.9 version and have not = been able to recreate the error. The first thing I tested was this = section, and it seems fine so far. I do wonder about the "+3", as 2.9 = does has it as "+1" - that may be the point of contention, but I need a = little more testing to tell for sure. I'm also in the middle of a work = day, though, so it may not be in the next 30 minutes... If I find a problem for sure, I will let everyone know. jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 12:53 To: web...@li... Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry Actually, looks like a variable may be assembling or disassembling the parameter incorrectly. Possibly...the Select variable. $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch =3D substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select']," = - ")); You get dashes and then they are stripped where used. Only I think that Branch Code with the minus sign in it is not being stripped correctly. = I'm thinking this info will help someone who has more experience in that = code know what the issue is... Steve ----- Original Message -----=20 From: "Melvin Sequera" <kat...@ya...> To: <web...@li...> Sent: Tuesday, October 12, 2004 11:11 AM Subject: [Web-erp-users] Order Entry > Good morning guys. > > Right now I'm trying to introduce a nuew order to be > billing later. But the system throw me this error: > > The branch details for branch code: against customer > code: 0130000200 could not be retrieved. Check the set > up of the customer and branch. > The SQL that failed to get the branch details was: > SELECT CustBranch.BrName, > CustBranch.BrAddress1,BrAddress2, BrAddress3, > BrAddress4, PhoneNo, Email, DefaultLocation, > DefaultShipVia From CustBranch WHERE > CustBranch.BranchCode=3D'- 0130000202' AND > CustBranch.DebtorNo =3D '0130000200' > > The question is why? I've configured the master > customer record and configured two branchs, one of tis > branchs has the code 0130000202 so I don't understand > where is the problem. > > Could you help me please? > > Thanks in advance. > > Melvin > > _________________________________________________________ > Do You Yahoo!? > Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! = Noticias. > Vis=EDtanos en http://noticias.espanol.yahoo.com > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-users mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give = us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Jesse P. <je...@st...> - 2004-10-12 18:20:58
|
That would explain why I am having such a god-awful time trying to = figure this out... One point here that gets back to versioning issues... it would be best = if this change was also made in the 2.9 code and a new version (2.9a or = something) released to Sourceforge so new users don't have problems that = have been corrected... jesse -----Original Message----- From: Daintrees [mailto:p.d...@pa...] Sent: Tuesday, October 12, 2004 14:20 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry It's to do with the treatment of strrpos and strpos between versions of=20 PHP - PHP 5 has this function re-written I side stepped the issue by = using a=20 function that worked in both versions the same way ... as I recall. Phil ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 6:57 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > Steve, please be mindful to have a grasp of the problem before posting = > things... this may simply confuse everyone or get 2 or 3 people doing = the=20 > same things, especially since you have posted a bit of code that is=20 > different than what Melvin on the Users list is using. I know you are=20 > trying to be helpful, but, in general, having to wade through emails = with=20 > lots of guesses & maybes, but little solid information is not horribly = > helpful. > > That said, I have his version of this, from the 2.9 version and have = not=20 > been able to recreate the error. The first thing I tested was this=20 > section, and it seems fine so far. I do wonder about the "+3", as 2.9 = does=20 > has it as "+1" - that may be the point of contention, but I need a = little=20 > more testing to tell for sure. I'm also in the middle of a work day,=20 > though, so it may not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch =3D > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] =3D = substr($_POST['Select'],0,strpos($_POST['Select']," - > ")); > > You get dashes and then they are stripped where used. Only I think = that > Branch Code with the minus sign in it is not being stripped correctly. = > I'm > thinking this info will help someone who has more experience in that = code > know what the issue is... > > Steve > > ----- Original Message -----=20 > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode=3D'- 0130000202' AND >> CustBranch.DebtorNo =3D '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! = Noticias. >> Vis=EDtanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal >> Use IT products in your business? Tell us what you think of them. = Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find = out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > >=20 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give = us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Jesse P. <je...@st...> - 2004-10-12 19:54:42
|
Sure, kudos to you... did you not see anything I wrote back to him? = Speed is not a problem - but I think if you find yourself replying to a = message again or to yourself fairly quickly that possibly a little more = time could have been taken... jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 15:39 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry I would like to point out that I was the one who quickly answered = Melvin's problem, who discovered that the value had a negative and narrowed it to being something in the assembly and disassembly of those values. I also posted code similar to that which is likely to be the problem. This, in = my opinion, is why we are so far into solving this problem already. Anyway, I can sit back and not answer this fast in the future. That's = no problem for me to do. Steve ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 1:57 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Steve, please be mindful to have a grasp of the problem before posting things... this may simply confuse everyone or get 2 or 3 people doing = the same things, especially since you have posted a bit of code that is different than what Melvin on the Users list is using. I know you are = trying to be helpful, but, in general, having to wade through emails with lots = of guesses & maybes, but little solid information is not horribly helpful. That said, I have his version of this, from the 2.9 version and have not been able to recreate the error. The first thing I tested was this = section, and it seems fine so far. I do wonder about the "+3", as 2.9 does has it = as "+1" - that may be the point of contention, but I need a little more = testing to tell for sure. I'm also in the middle of a work day, though, so it = may not be in the next 30 minutes... If I find a problem for sure, I will let everyone know. jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 12:53 To: web...@li... Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry Actually, looks like a variable may be assembling or disassembling the parameter incorrectly. Possibly...the Select variable. $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch =3D substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select']," = - ")); You get dashes and then they are stripped where used. Only I think that Branch Code with the minus sign in it is not being stripped correctly. = I'm thinking this info will help someone who has more experience in that = code know what the issue is... Steve ----- Original Message -----=20 From: "Melvin Sequera" <kat...@ya...> To: <web...@li...> Sent: Tuesday, October 12, 2004 11:11 AM Subject: [Web-erp-users] Order Entry > Good morning guys. > > Right now I'm trying to introduce a nuew order to be > billing later. But the system throw me this error: > > The branch details for branch code: against customer > code: 0130000200 could not be retrieved. Check the set > up of the customer and branch. > The SQL that failed to get the branch details was: > SELECT CustBranch.BrName, > CustBranch.BrAddress1,BrAddress2, BrAddress3, > BrAddress4, PhoneNo, Email, DefaultLocation, > DefaultShipVia From CustBranch WHERE > CustBranch.BranchCode=3D'- 0130000202' AND > CustBranch.DebtorNo =3D '0130000200' > > The question is why? I've configured the master > customer record and configured two branchs, one of tis > branchs has the code 0130000202 so I don't understand > where is the problem. > > Could you help me please? > > Thanks in advance. > > Melvin > > _________________________________________________________ |
|
From: skaill <sk...@ro...> - 2004-10-12 20:02:46
|
It takes some time for messages to come through. On the one message I knew you responded and I added to it by saying he could try to recreate the issue in our demo system to see if it did the same. I will try to keep in mind your point, Jesse. I'll try to hold back some ;) I do know though that users like quick response, even if it is not an entire answer. If they get attention then they know we understand their problem is real and important. In fact sometimes they figure the rest out when some things are pointed out such as the negative sign. Steve ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 3:54 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Sure, kudos to you... did you not see anything I wrote back to him? Speed is not a problem - but I think if you find yourself replying to a message again or to yourself fairly quickly that possibly a little more time could have been taken... jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 15:39 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry I would like to point out that I was the one who quickly answered Melvin's problem, who discovered that the value had a negative and narrowed it to being something in the assembly and disassembly of those values. I also posted code similar to that which is likely to be the problem. This, in my opinion, is why we are so far into solving this problem already. Anyway, I can sit back and not answer this fast in the future. That's no problem for me to do. Steve ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 1:57 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Steve, please be mindful to have a grasp of the problem before posting things... this may simply confuse everyone or get 2 or 3 people doing the same things, especially since you have posted a bit of code that is different than what Melvin on the Users list is using. I know you are trying to be helpful, but, in general, having to wade through emails with lots of guesses & maybes, but little solid information is not horribly helpful. That said, I have his version of this, from the 2.9 version and have not been able to recreate the error. The first thing I tested was this section, and it seems fine so far. I do wonder about the "+3", as 2.9 does has it as "+1" - that may be the point of contention, but I need a little more testing to tell for sure. I'm also in the middle of a work day, though, so it may not be in the next 30 minutes... If I find a problem for sure, I will let everyone know. jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 12:53 To: web...@li... Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry Actually, looks like a variable may be assembling or disassembling the parameter incorrectly. Possibly...the Select variable. $_POST['Select'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch = substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] = substr($_POST['Select'],0,strpos($_POST['Select']," - ")); You get dashes and then they are stripped where used. Only I think that Branch Code with the minus sign in it is not being stripped correctly. I'm thinking this info will help someone who has more experience in that code know what the issue is... Steve ----- Original Message ----- From: "Melvin Sequera" <kat...@ya...> To: <web...@li...> Sent: Tuesday, October 12, 2004 11:11 AM Subject: [Web-erp-users] Order Entry > Good morning guys. > > Right now I'm trying to introduce a nuew order to be > billing later. But the system throw me this error: > > The branch details for branch code: against customer > code: 0130000200 could not be retrieved. Check the set > up of the customer and branch. > The SQL that failed to get the branch details was: > SELECT CustBranch.BrName, > CustBranch.BrAddress1,BrAddress2, BrAddress3, > BrAddress4, PhoneNo, Email, DefaultLocation, > DefaultShipVia From CustBranch WHERE > CustBranch.BranchCode='- 0130000202' AND > CustBranch.DebtorNo = '0130000200' > > The question is why? I've configured the master > customer record and configured two branchs, one of tis > branchs has the code 0130000202 so I don't understand > where is the problem. > > Could you help me please? > > Thanks in advance. > > Melvin > > _________________________________________________________ ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Stins, D. <DR...@Zi...> - 2004-10-12 21:05:04
|
Steve, Jesse, You are both right. Please stop "fighting". A solution for this issue might be: use tracker of sourceforge http://sourceforge.net/tracker/?group_id=70949 I guess that the Admin (Phil) is triggered when a new issue is added and forward (or assigns) it to de developerslist so it can be solved by someone. This will reduce the huge amount of e-mails at the developers list and there will be no loss of information, because everything what might be important can be registrated in tracker. The main advantage is that you can read the progress of open issues in tracker, but you never be bothered with the usefull analyses of the issues (the many follow up e-mails of Steve and ... about open issues) in the developers list. What are your thought about this? with best regards, Dick Stins p.s. when we do not like tracker, then we might select another tool to help us ( http://www.osticket.com/server/ , http://www.support-logic.com/index.php or ....) ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 9:54 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Sure, kudos to you... did you not see anything I wrote back to him? Speed is not a problem - but I think if you find yourself replying to a message again or to yourself fairly quickly that possibly a little more time could have been taken... jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 15:39 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry I would like to point out that I was the one who quickly answered Melvin's problem, who discovered that the value had a negative and narrowed it to being something in the assembly and disassembly of those values. I also posted code similar to that which is likely to be the problem. This, in my opinion, is why we are so far into solving this problem already. Anyway, I can sit back and not answer this fast in the future. That's no problem for me to do. Steve ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 1:57 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Steve, please be mindful to have a grasp of the problem before posting things... this may simply confuse everyone or get 2 or 3 people doing the same things, especially since you have posted a bit of code that is different than what Melvin on the Users list is using. I know you are trying to be helpful, but, in general, having to wade through emails with lots of guesses & maybes, but little solid information is not horribly helpful. That said, I have his version of this, from the 2.9 version and have not been able to recreate the error. The first thing I tested was this section, and it seems fine so far. I do wonder about the "+3", as 2.9 does has it as "+1" - that may be the point of contention, but I need a little more testing to tell for sure. I'm also in the middle of a work day, though, so it may not be in the next 30 minutes... If I find a problem for sure, I will let everyone know. jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 12:53 To: web...@li... Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry Actually, looks like a variable may be assembling or disassembling the parameter incorrectly. Possibly...the Select variable. $_POST['Select'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch = substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] = substr($_POST['Select'],0,strpos($_POST['Select']," - ")); You get dashes and then they are stripped where used. Only I think that Branch Code with the minus sign in it is not being stripped correctly. I'm thinking this info will help someone who has more experience in that code know what the issue is... Steve ----- Original Message ----- From: "Melvin Sequera" <kat...@ya...> To: <web...@li...> Sent: Tuesday, October 12, 2004 11:11 AM Subject: [Web-erp-users] Order Entry > Good morning guys. > > Right now I'm trying to introduce a nuew order to be > billing later. But the system throw me this error: > > The branch details for branch code: against customer > code: 0130000200 could not be retrieved. Check the set > up of the customer and branch. > The SQL that failed to get the branch details was: > SELECT CustBranch.BrName, > CustBranch.BrAddress1,BrAddress2, BrAddress3, > BrAddress4, PhoneNo, Email, DefaultLocation, > DefaultShipVia From CustBranch WHERE > CustBranch.BranchCode='- 0130000202' AND > CustBranch.DebtorNo = '0130000200' > > The question is why? I've configured the master > customer record and configured two branchs, one of tis > branchs has the code 0130000202 so I don't understand > where is the problem. > > Could you help me please? > > Thanks in advance. > > Melvin > > _________________________________________________________ ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: skaill <sk...@ro...> - 2004-10-12 21:11:58
|
Thanks, Dick. I know we are both right. As I say, for my part, I will try to be more careful before responding so there are less messages. ----- Original Message ----- From: "Stins, Dick" <DR...@Zi...> To: <web...@li...> Sent: Tuesday, October 12, 2004 5:09 PM Subject: [Web-erp-developers] huge amount of emails > Steve, Jesse, > > You are both right. > > Please stop "fighting". > > A solution for this issue might be: > use tracker of sourceforge http://sourceforge.net/tracker/?group_id=70949 > > I guess that the Admin (Phil) is triggered when a new issue is added and > forward (or assigns) it to de developerslist so it can be solved by someone. > > This will reduce the huge amount of e-mails at the developers list and there > will be no loss of information, because everything what might be important > can be registrated in tracker. > The main advantage is that you can read the progress of open issues in > tracker, but you never be bothered with the usefull analyses of the issues > (the many follow up e-mails of Steve and ... about open issues) in the > developers list. > > What are your thought about this? > > with best regards, > > Dick Stins > > p.s. when we do not like tracker, then we might select another tool to help > us ( http://www.osticket.com/server/ , > http://www.support-logic.com/index.php or ....) > > > ----- Original Message ----- > From: "Jesse Peterson" <je...@st...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 9:54 PM > Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Sure, kudos to you... did you not see anything I wrote back to him? Speed is > not a problem - but I think if you find yourself replying to a message again > or to yourself fairly quickly that possibly a little more time could have > been taken... > > jesse > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 15:39 > To: web...@li... > Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > I would like to point out that I was the one who quickly answered Melvin's > problem, who discovered that the value had a negative and narrowed it to > being something in the assembly and disassembly of those values. I also > posted code similar to that which is likely to be the problem. This, in my > opinion, is why we are so far into solving this problem already. > > Anyway, I can sit back and not answer this fast in the future. That's no > problem for me to do. > > Steve > > ----- Original Message ----- > From: "Jesse Peterson" <je...@st...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 1:57 PM > Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Steve, please be mindful to have a grasp of the problem before posting > things... this may simply confuse everyone or get 2 or 3 people doing the > same things, especially since you have posted a bit of code that is > different than what Melvin on the Users list is using. I know you are trying > to be helpful, but, in general, having to wade through emails with lots of > guesses & maybes, but little solid information is not horribly helpful. > > That said, I have his version of this, from the 2.9 version and have not > been able to recreate the error. The first thing I tested was this section, > and it seems fine so far. I do wonder about the "+3", as 2.9 does has it as > "+1" - that may be the point of contention, but I need a little more testing > to tell for sure. I'm also in the middle of a work day, though, so it may > not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch = > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] = substr($_POST['Select'],0,strpos($_POST['Select']," - > ")); > > You get dashes and then they are stripped where used. Only I think that > Branch Code with the minus sign in it is not being stripped correctly. I'm > thinking this info will help someone who has more experience in that code > know what the issue is... > > Steve > > ----- Original Message ----- > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > > > Good morning guys. > > > > Right now I'm trying to introduce a nuew order to be > > billing later. But the system throw me this error: > > > > The branch details for branch code: against customer > > code: 0130000200 could not be retrieved. Check the set > > up of the customer and branch. > > The SQL that failed to get the branch details was: > > SELECT CustBranch.BrName, > > CustBranch.BrAddress1,BrAddress2, BrAddress3, > > BrAddress4, PhoneNo, Email, DefaultLocation, > > DefaultShipVia From CustBranch WHERE > > CustBranch.BranchCode='- 0130000202' AND > > CustBranch.DebtorNo = '0130000200' > > > > The question is why? I've configured the master > > customer record and configured two branchs, one of tis > > branchs has the code 0130000202 so I don't understand > > where is the problem. > > > > Could you help me please? > > > > Thanks in advance. > > > > Melvin > > > > _________________________________________________________ > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Jesse P. <je...@st...> - 2004-10-12 20:15:12
Attachments:
SelectOrderItems.php
|
Not that this ended up being a difficult fix, but Melvin was running = PHP5 and was bitten by this bug. I worked with him off list to find this = out and get him running a corrected version of the SelectOrderItems.php = scripts.=20 It is attached... Phil, as I mentioned before, a working 2.9 verion may = need to be posted, OR requirements should be posted noting that PHP5 is = not actually 100% supported in 2.9 and previous version. jesse -----Original Message----- From: Daintrees [mailto:p.d...@pa...] Sent: Tuesday, October 12, 2004 14:20 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry It's to do with the treatment of strrpos and strpos between versions of=20 PHP - PHP 5 has this function re-written I side stepped the issue by = using a=20 function that worked in both versions the same way ... as I recall. Phil ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 6:57 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > Steve, please be mindful to have a grasp of the problem before posting = > things... this may simply confuse everyone or get 2 or 3 people doing = the=20 > same things, especially since you have posted a bit of code that is=20 > different than what Melvin on the Users list is using. I know you are=20 > trying to be helpful, but, in general, having to wade through emails = with=20 > lots of guesses & maybes, but little solid information is not horribly = > helpful. > > That said, I have his version of this, from the 2.9 version and have = not=20 > been able to recreate the error. The first thing I tested was this=20 > section, and it seems fine so far. I do wonder about the "+3", as 2.9 = does=20 > has it as "+1" - that may be the point of contention, but I need a = little=20 > more testing to tell for sure. I'm also in the middle of a work day,=20 > though, so it may not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch =3D > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] =3D = substr($_POST['Select'],0,strpos($_POST['Select']," - > ")); > > You get dashes and then they are stripped where used. Only I think = that > Branch Code with the minus sign in it is not being stripped correctly. = > I'm > thinking this info will help someone who has more experience in that = code > know what the issue is... > > Steve > > ----- Original Message -----=20 > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode=3D'- 0130000202' AND >> CustBranch.DebtorNo =3D '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! = Noticias. >> Vis=EDtanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal >> Use IT products in your business? Tell us what you think of them. = Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find = out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on = ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > >=20 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give = us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Daintrees <p.d...@pa...> - 2004-10-13 05:34:22
|
It is fixed already in CVS. I think that we could do with an interim release before 3.0 multi-languag= e=20 version is complete, web-site finished etc. Phil ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 9:15 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Not that this ended up being a difficult fix, but Melvin was running PHP5= =20 and was bitten by this bug. I worked with him off list to find this out a= nd=20 get him running a corrected version of the SelectOrderItems.php scripts. It is attached... Phil, as I mentioned before, a working 2.9 verion may n= eed=20 to be posted, OR requirements should be posted noting that PHP5 is not=20 actually 100% supported in 2.9 and previous version. jesse -----Original Message----- From: Daintrees [mailto:p.d...@pa...] Sent: Tuesday, October 12, 2004 14:20 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry It's to do with the treatment of strrpos and strpos between versions of PHP - PHP 5 has this function re-written I side stepped the issue by usin= g a function that worked in both versions the same way ... as I recall. Phil ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 6:57 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > Steve, please be mindful to have a grasp of the problem before posting > things... this may simply confuse everyone or get 2 or 3 people doing t= he > same things, especially since you have posted a bit of code that is > different than what Melvin on the Users list is using. I know you are > trying to be helpful, but, in general, having to wade through emails wi= th > lots of guesses & maybes, but little solid information is not horribly > helpful. > > That said, I have his version of this, from the 2.9 version and have no= t > been able to recreate the error. The first thing I tested was this > section, and it seems fine so far. I do wonder about the "+3", as 2.9 d= oes > has it as "+1" - that may be the point of contention, but I need a litt= le > more testing to tell for sure. I'm also in the middle of a work day, > though, so it may not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch =3D > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select'],= " - > ")); > > You get dashes and then they are stripped where used. Only I think tha= t > Branch Code with the minus sign in it is not being stripped correctly. > I'm > thinking this info will help someone who has more experience in that co= de > know what the issue is... > > Steve > > ----- Original Message -----=20 > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode=3D'- 0130000202' AND >> CustBranch.DebtorNo =3D '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! Noticias. >> Vis=EDtanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJourn= al >> Use IT products in your business? Tell us what you think of them. Give= us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out mo= re http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: skaill <sk...@ro...> - 2004-10-13 09:44:01
|
Sounds like a good idea. ----- Original Message ----- From: "Daintrees" <p.d...@pa...> To: <web...@li...> Sent: Wednesday, October 13, 2004 1:36 AM Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry It is fixed already in CVS. I think that we could do with an interim release before 3.0 multi-language version is complete, web-site finished etc. Phil ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 9:15 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Not that this ended up being a difficult fix, but Melvin was running PHP5 and was bitten by this bug. I worked with him off list to find this out and get him running a corrected version of the SelectOrderItems.php scripts. It is attached... Phil, as I mentioned before, a working 2.9 verion may need to be posted, OR requirements should be posted noting that PHP5 is not actually 100% supported in 2.9 and previous version. jesse -----Original Message----- From: Daintrees [mailto:p.d...@pa...] Sent: Tuesday, October 12, 2004 14:20 To: web...@li... Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry It's to do with the treatment of strrpos and strpos between versions of PHP - PHP 5 has this function re-written I side stepped the issue by using a function that worked in both versions the same way ... as I recall. Phil ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 6:57 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > Steve, please be mindful to have a grasp of the problem before posting > things... this may simply confuse everyone or get 2 or 3 people doing the > same things, especially since you have posted a bit of code that is > different than what Melvin on the Users list is using. I know you are > trying to be helpful, but, in general, having to wade through emails with > lots of guesses & maybes, but little solid information is not horribly > helpful. > > That said, I have his version of this, from the 2.9 version and have not > been able to recreate the error. The first thing I tested was this > section, and it seems fine so far. I do wonder about the "+3", as 2.9 does > has it as "+1" - that may be the point of contention, but I need a little > more testing to tell for sure. I'm also in the middle of a work day, > though, so it may not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch = > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] = substr($_POST['Select'],0,strpos($_POST['Select']," - > ")); > > You get dashes and then they are stripped where used. Only I think that > Branch Code with the minus sign in it is not being stripped correctly. > I'm > thinking this info will help someone who has more experience in that code > know what the issue is... > > Steve > > ----- Original Message ----- > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode='- 0130000202' AND >> CustBranch.DebtorNo = '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Información de Estados Unidos y América Latina, en Yahoo! Noticias. >> Visítanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Daintrees <p.d...@pa...> - 2004-10-12 18:17:53
|
It's to do with the treatment of strrpos and strpos between versions of=20 PHP - PHP 5 has this function re-written I side stepped the issue by usin= g a=20 function that worked in both versions the same way ... as I recall. Phil ----- Original Message -----=20 From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Wednesday, October 13, 2004 6:57 AM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > Steve, please be mindful to have a grasp of the problem before posting=20 > things... this may simply confuse everyone or get 2 or 3 people doing t= he=20 > same things, especially since you have posted a bit of code that is=20 > different than what Melvin on the Users list is using. I know you are=20 > trying to be helpful, but, in general, having to wade through emails wi= th=20 > lots of guesses & maybes, but little solid information is not horribly=20 > helpful. > > That said, I have his version of this, from the 2.9 version and have no= t=20 > been able to recreate the error. The first thing I tested was this=20 > section, and it seems fine so far. I do wonder about the "+3", as 2.9 d= oes=20 > has it as "+1" - that may be the point of contention, but I need a litt= le=20 > more testing to tell for sure. I'm also in the middle of a work day,=20 > though, so it may not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch =3D > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select'],= " - > ")); > > You get dashes and then they are stripped where used. Only I think tha= t > Branch Code with the minus sign in it is not being stripped correctly.=20 > I'm > thinking this info will help someone who has more experience in that co= de > know what the issue is... > > Steve > > ----- Original Message -----=20 > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode=3D'- 0130000202' AND >> CustBranch.DebtorNo =3D '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! Noticias. >> Vis=EDtanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJourn= al >> Use IT products in your business? Tell us what you think of them. Give= us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out=20 > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out=20 > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > >=20 |
|
From: skaill <sk...@ro...> - 2004-10-12 19:37:49
|
I would like to point out that I was the one who quickly answered Melvin's problem, who discovered that the value had a negative and narrowed it to being something in the assembly and disassembly of those values. I also posted code similar to that which is likely to be the problem. This, in my opinion, is why we are so far into solving this problem already. Anyway, I can sit back and not answer this fast in the future. That's no problem for me to do. Steve ----- Original Message ----- From: "Jesse Peterson" <je...@st...> To: <web...@li...> Sent: Tuesday, October 12, 2004 1:57 PM Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry Steve, please be mindful to have a grasp of the problem before posting things... this may simply confuse everyone or get 2 or 3 people doing the same things, especially since you have posted a bit of code that is different than what Melvin on the Users list is using. I know you are trying to be helpful, but, in general, having to wade through emails with lots of guesses & maybes, but little solid information is not horribly helpful. That said, I have his version of this, from the 2.9 version and have not been able to recreate the error. The first thing I tested was this section, and it seems fine so far. I do wonder about the "+3", as 2.9 does has it as "+1" - that may be the point of contention, but I need a little more testing to tell for sure. I'm also in the middle of a work day, though, so it may not be in the next 30 minutes... If I find a problem for sure, I will let everyone know. jesse -----Original Message----- From: skaill [mailto:sk...@ro...] Sent: Tuesday, October 12, 2004 12:53 To: web...@li... Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry Actually, looks like a variable may be assembling or disassembling the parameter incorrectly. Possibly...the Select variable. $_POST['Select'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch = substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] = substr($_POST['Select'],0,strpos($_POST['Select']," - ")); You get dashes and then they are stripped where used. Only I think that Branch Code with the minus sign in it is not being stripped correctly. I'm thinking this info will help someone who has more experience in that code know what the issue is... Steve ----- Original Message ----- From: "Melvin Sequera" <kat...@ya...> To: <web...@li...> Sent: Tuesday, October 12, 2004 11:11 AM Subject: [Web-erp-users] Order Entry > Good morning guys. > > Right now I'm trying to introduce a nuew order to be > billing later. But the system throw me this error: > > The branch details for branch code: against customer > code: 0130000200 could not be retrieved. Check the set > up of the customer and branch. > The SQL that failed to get the branch details was: > SELECT CustBranch.BrName, > CustBranch.BrAddress1,BrAddress2, BrAddress3, > BrAddress4, PhoneNo, Email, DefaultLocation, > DefaultShipVia From CustBranch WHERE > CustBranch.BranchCode='- 0130000202' AND > CustBranch.DebtorNo = '0130000200' > > The question is why? I've configured the master > customer record and configured two branchs, one of tis > branchs has the code 0130000202 so I don't understand > where is the problem. > > Could you help me please? > > Thanks in advance. > > Melvin > > _________________________________________________________ > Do You Yahoo!? > Información de Estados Unidos y América Latina, en Yahoo! Noticias. > Visítanos en http://noticias.espanol.yahoo.com > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-users mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Daintrees <p.d...@pa...> - 2004-10-13 05:34:26
|
Gentlemen please :-) P ----- Original Message -----=20 From: "skaill" <sk...@ro...> To: <web...@li...> Sent: Wednesday, October 13, 2004 8:39 AM Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry >I would like to point out that I was the one who quickly answered Melvin= 's > problem, who discovered that the value had a negative and narrowed it t= o > being something in the assembly and disassembly of those values. I als= o > posted code similar to that which is likely to be the problem. This, i= n=20 > my > opinion, is why we are so far into solving this problem already. > > Anyway, I can sit back and not answer this fast in the future. That's = no > problem for me to do. > > Steve > > ----- Original Message -----=20 > From: "Jesse Peterson" <je...@st...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 1:57 PM > Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Steve, please be mindful to have a grasp of the problem before posting > things... this may simply confuse everyone or get 2 or 3 people doing t= he > same things, especially since you have posted a bit of code that is > different than what Melvin on the Users list is using. I know you are=20 > trying > to be helpful, but, in general, having to wade through emails with lots= of > guesses & maybes, but little solid information is not horribly helpful. > > That said, I have his version of this, from the 2.9 version and have no= t > been able to recreate the error. The first thing I tested was this=20 > section, > and it seems fine so far. I do wonder about the "+3", as 2.9 does has i= t=20 > as > "+1" - that may be the point of contention, but I need a little more=20 > testing > to tell for sure. I'm also in the middle of a work day, though, so it m= ay > not be in the next 30 minutes... > > If I find a problem for sure, I will let everyone know. > > > jesse > > > -----Original Message----- > From: skaill [mailto:sk...@ro...] > Sent: Tuesday, October 12, 2004 12:53 > To: web...@li... > Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry > > > Actually, looks like a variable may be assembling or disassembling the > parameter incorrectly. Possibly...the Select variable. > > $_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; > ... > $_SESSION['Items']->Branch =3D > substr($_POST['Select'],strpos($_POST['Select']," - ")+3); > ... > $_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select'],= " - > ")); > > You get dashes and then they are stripped where used. Only I think tha= t > Branch Code with the minus sign in it is not being stripped correctly.=20 > I'm > thinking this info will help someone who has more experience in that co= de > know what the issue is... > > Steve > > ----- Original Message -----=20 > From: "Melvin Sequera" <kat...@ya...> > To: <web...@li...> > Sent: Tuesday, October 12, 2004 11:11 AM > Subject: [Web-erp-users] Order Entry > > >> Good morning guys. >> >> Right now I'm trying to introduce a nuew order to be >> billing later. But the system throw me this error: >> >> The branch details for branch code: against customer >> code: 0130000200 could not be retrieved. Check the set >> up of the customer and branch. >> The SQL that failed to get the branch details was: >> SELECT CustBranch.BrName, >> CustBranch.BrAddress1,BrAddress2, BrAddress3, >> BrAddress4, PhoneNo, Email, DefaultLocation, >> DefaultShipVia From CustBranch WHERE >> CustBranch.BranchCode=3D'- 0130000202' AND >> CustBranch.DebtorNo =3D '0130000200' >> >> The question is why? I've configured the master >> customer record and configured two branchs, one of tis >> branchs has the code 0130000202 so I don't understand >> where is the problem. >> >> Could you help me please? >> >> Thanks in advance. >> >> Melvin >> >> _________________________________________________________ >> Do You Yahoo!? >> Informaci=F3n de Estados Unidos y Am=E9rica Latina, en Yahoo! Noticias. >> Vis=EDtanos en http://noticias.espanol.yahoo.com >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJourn= al >> Use IT products in your business? Tell us what you think of them. Give= us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out=20 > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out=20 > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out=20 > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >=20 |
×
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.
Thanks for helping keep SourceForge clean.
X