Pb with conditional display with ASPdb 2.2127 EP

François · 12-06-1999, 01:19 PM

Hi,

We are trying to use a conditional display with the following DbMagicCell. But it does not work: even the same result, the first macrodisplay.
Does it the right syntax?

strDbMagicCell = "(~,)~VAL_COD,align=""center"" ,(#PVA_QTE_G_LIQ#|GT|0||"
strDbMagicCell = strDbMagicCell & " #VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_POIDS#</td></tr>"
strDbMagicCell = strDbMagicCell & "<tr><td colspan=2 align=center>dont en liquidation</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_QTE_G_LIQ#</td>"
strDbMagicCell = strDbMagicCell & "<td> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PAM_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_VALO_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PMVL_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td align=""center""> - </td></tr>~#PVA_QTE_G_LIQ#|EL|||#VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_POIDS#</td></tr>)"

François Le Palec
Oddo & Cie.

Mark · 12-06-1999, 04:32 PM

Francois,

1)
First, I've been trying to send you emails to flepalec@teknika.net
and they don't go through. Is there something wrong with your email address?

2)
Your dbMagicCell syntax is very wrong. Why do you have (~,) at the beginning? What is that for? Also why do you have lots of <table tags>. What are you trying to do? I would suggest you write a very short simple dbMagicCell and get it to work so you understand it before trying anything so complex. Please see example 2 at our Enterprise examples site to see the CORRECT syntax.

http://www.aspdb.com/V2/V2_MAGIC.asp

Mark.

------------
François at 12/6/99 1:19:53 PM

Hi,

We are trying to use a conditional display with the following DbMagicCell. But it does not work: even the same result, the first macrodisplay.
Does it the right syntax?

strDbMagicCell = "(~,)~VAL_COD,align=""center"" ,(#PVA_QTE_G_LIQ#|GT|0||"
strDbMagicCell = strDbMagicCell & " #VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_POIDS#</td></tr>"
strDbMagicCell = strDbMagicCell & "<tr><td colspan=2 align=center>dont en liquidation</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_QTE_G_LIQ#</td>"
strDbMagicCell = strDbMagicCell & "<td> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PAM_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_VALO_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PMVL_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td align=""center""> - </td></tr>~#PVA_QTE_G_LIQ#|EL|||#VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_POIDS#</td></tr>)"

François Le Palec
Oddo & Cie.

François Le Palec · 12-07-1999, 09:48 AM

Hi Mark,

1) Our mail server has some problem these days... Just answer in this forum! :-)

2) Ooohh! You're right! So, I modified my code and now it works... But I need to format two SQL field displayed in the same cell. How can I do that?

My dbMagicCell code:

strDbMagicCell = "(¤+)¤VAL_COD+align=""center"&#3 4;+(#PVA_QTE_G_LIQ#|EQ|0|| #VAL_COD#~#PVA_QTE_G_LIQ#|EL|||#VAL_COD# &nbsp

¤"
strDbMagicCell = strDbMagicCell & "VAL_LIB_ABR+align=""left""+(# PVA_QTE_G_LIQ#|EQ|0|| #VAL_LIB_ABR#~#PVA_QTE_G_LIQ#|EL|||#VAL_LIB_ABR#<center>:..dont en liquidation</center>)¤"
strDbMagicCell = strDbMagicCell & "PVA_QTE_G+align=""right""+(#P VA_QTE_G_LIQ#|EQ|0|| #PVA_QTE_G#~#PVA_QTE_G_LIQ#|EL|||#PVA_QTE_G# #P VA_QTE_G_LIQ#)¤"
strDbMagicCell = strDbMagicCell & "CRS_COURS_COT+align=""right"" +(#PVA_QTE_G_LIQ#|EQ|0|| format=[### ### ##0.00]~#PVA_QTE_G_LIQ#|EL|||format=[### ### ##0.00] #CRS_COURS_COT#)¤"
strDbMagicCell = strDbMagicCell & "PVA_PAM+align=""right""+(#PVA _QTE_G_LIQ#|EQ|0|| format=[### ### ##0.00]~#PVA_QTE_G_LIQ#|EL|||format=[### ### ##0.00] #PVA_PAM_G_LIQ#)¤"
strDbMagicCell = strDbMagicCell & "PVA_VALO_G+align=""right""+(# PVA_QTE_G_LIQ#|EQ|0|| format=[### ### ##0.00]~#PVA_QTE_G_LIQ#|EL|||format=[### ### ##0.00] #PVA_VALO_G_LIQ#)¤"
strDbMagicCell = strDbMagicCell & "PVA_PMVL+align=""right""+(#PV A_QTE_G_LIQ#|EQ|0|| format=[### ### ##0.00]~#PVA_QTE_G_LIQ#|EL|||format=[### ### ##0.00] #PVA_PMVL_LIQ#)¤"
strDbMagicCell = strDbMagicCell & "PVA_POIDS+align=""right""+(#P VA_QTE_G_LIQ#|EQ|0|| format=[### ### ##0.00]%~#PVA_QTE_G_LIQ#|EL|||format=[### ### ##0.00]% -)¤"

I tried to add these lines, but it changed nothing:

strDbMagicCell = strDbMagicCell & "CRS_COURS_COT++format=[### ### ##0.00]¤"
strDbMagicCell = strDbMagicCell & "PVA_PAM_G_LIQ++format=[### ### ##0.00]¤"
strDbMagicCell = strDbMagicCell & "PVA_VALO_G_LIQ++format=[### ### ##0.00]¤"
strDbMagicCell = strDbMagicCell & "PVA_PMVL_LIQ++format=[### ### ##0.00]¤"

Thanx for your help,
François.

------------
Mark at 12/6/99 4:32:48 PM

Francois,

1)
First, I've been trying to send you emails to flepalec@teknika.net
and they don't go through. Is there something wrong with your email address?

2)
Your dbMagicCell syntax is very wrong. Why do you have (~,) at the beginning? What is that for? Also why do you have lots of <table tags>. What are you trying to do? I would suggest you write a very short simple dbMagicCell and get it to work so you understand it before trying anything so complex. Please see example 2 at our Enterprise examples site to see the CORRECT syntax.

http://www.aspdb.com/V2/V2_MAGIC.asp

Mark.

------------
François at 12/6/99 1:19:53 PM

Hi,

We are trying to use a conditional display with the following DbMagicCell. But it does not work: even the same result, the first macrodisplay.
Does it the right syntax?

strDbMagicCell = "(~,)~VAL_COD,align=""center"" ,(#PVA_QTE_G_LIQ#|GT|0||"
strDbMagicCell = strDbMagicCell & " #VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""78""> #PVA_POIDS#</td></tr>"
strDbMagicCell = strDbMagicCell & "<tr><td colspan=2 align=center>dont en liquidation</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_QTE_G_LIQ#</td>"
strDbMagicCell = strDbMagicCell & "<td> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PAM_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_VALO_G_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td> #PVA_PMVL_LIQ_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td align=""center""> - </td></tr>~#PVA_QTE_G_LIQ#|EL|||#VAL_COD#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""191""> #VAL_LIB_ABR#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_QTE_G#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #CRS_COURS_COT_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PAM_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_VALO_G_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_PMVL_" & strCurrency &"#</td>"
strDbMagicCell = strDbMagicCell & "<td bgcolor=D2E7C8 width=""82""> #PVA_POIDS#</td></tr>)"

François Le Palec
Oddo & Cie.

Mark · 12-07-1999, 10:07 AM

.
François,
Just separate them with semi-colons (

. See the Example at:
http://www.aspdb.com/V2/V2_MAGIC.asp
-------------------------------------------------------------------
Now, on the other matter you emailed us about on November 30 ...

You wrote:
When I use your example on my IIS with ASPdb Pro
version 1.1314, I get two <TR>'s at the beginning
of the table generated by ASPdb ...

Dear François,

I am sorry to hear you are having a problem with ASP-db.

We have not had any other complaints regarding the behavior that
you described. If you would like to submit an "Incident" we can
investigate it for you for a charge of $95. If the problem is due
to a bug in ASP-db, the Incident fee will be waived - AND we will
send you a FREE UPDATE that fixes the reported problem if at all
possible. In either case, we would ask that you try to reproduce
this problem using either Microsoft's Access Northwind database or
the SQL Server PUBS database.

Please submit the source code (asp file) that repoduces this
problem, along with a description of the steps we will need to go
through to see the problem that you are reporting. It would also
be VERY HELPFUL if you could send the SHORTEST, SIMPLEST
example that demonstrates this problem.

Thanks.
Mark.

François Le Palec · 12-07-1999, 10:24 AM

Hi Mark,

MMmmm... Actually, this is not what I need. Here is a simple example of what I want. Imagine I have the following SQL request:

Mydb.dbSQL = "SELECT Value1, Value2 FROM MyTable"

But I want to display these two values in the same <table> cell. So I use the following code:

MyDb.GridDisplayFlds = "0"
MyDb.dbMagicCell = "Value1,,format=[### ##0.00] #Value2#"

Ok... So Value1 is formatted. But how can I do to format Value2?

Thanx for your help.
François.

PS: concerning the other problem, I checked everything... and I think this is a bug which has been corrected in the last ASPdb versions... but this application will be hosted by InnerHost and I don't want to wait for us to update their ASPdb... So I have re-written the table display function in pure ASP.

------------
Mark at 12/7/99 10:07:26 AM

.
François,
Just separate them with semi-colons (

. See the Example at:
http://www.aspdb.com/V2/V2_MAGIC.asp
-------------------------------------------------------------------
Now, on the other matter you emailed us about on November 30 ...

You wrote:
When I use your example on my IIS with ASPdb Pro
version 1.1314, I get two <TR>'s at the beginning
of the table generated by ASPdb ...

Dear François,

I am sorry to hear you are having a problem with ASP-db.

We have not had any other complaints regarding the behavior that
you described. If you would like to submit an "Incident" we can
investigate it for you for a charge of $95. If the problem is due
to a bug in ASP-db, the Incident fee will be waived - AND we will
send you a FREE UPDATE that fixes the reported problem if at all
possible. In either case, we would ask that you try to reproduce
this problem using either Microsoft's Access Northwind database or
the SQL Server PUBS database.

Please submit the source code (asp file) that repoduces this
problem, along with a description of the steps we will need to go
through to see the problem that you are reporting. It would also
be VERY HELPFUL if you could send the SHORTEST, SIMPLEST
example that demonstrates this problem.

Thanks.
Mark.

Mark · 12-07-1999, 09:26 PM

-
François,

Format 2 fields with MagicCell? It can't be done. Someone else just asked
about this recently. You'd have to write a java script function then call
it from MagicCell similar to example D63 at:

http://www.aspdb.com/apps/mh-java-magic.asp

If you write it, we'll publish it so others may use it too.

mark.

------------
François Le Palec at 12/7/99 10:24:12 AM

Hi Mark,

MMmmm... Actually, this is not what I need. Here is a simple example of what I want. Imagine I have the following SQL request:

Mydb.dbSQL = "SELECT Value1, Value2 FROM MyTable"

But I want to display these two values in the same <table> cell. So I use the following code:

MyDb.GridDisplayFlds = "0"
MyDb.dbMagicCell = "Value1,,format=[### ##0.00] #Value2#"

Ok... So Value1 is formatted. But how can I do to format Value2?

Thanx for your help.
François.

PS: concerning the other problem, I checked everything... and I think this is a bug which has been corrected in the last ASPdb versions... but this application will be hosted by InnerHost and I don't want to wait for us to update their ASPdb... So I have re-written the table display function in pure ASP.

------------
Mark at 12/7/99 10:07:26 AM

.
François,
Just separate them with semi-colons (

. See the Example at:
http://www.aspdb.com/V2/V2_MAGIC.asp
-------------------------------------------------------------------
Now, on the other matter you emailed us about on November 30 ...

You wrote:
When I use your example on my IIS with ASPdb Pro
version 1.1314, I get two <TR>'s at the beginning
of the table generated by ASPdb ...

Dear François,

I am sorry to hear you are having a problem with ASP-db.

We have not had any other complaints regarding the behavior that
you described. If you would like to submit an "Incident" we can
investigate it for you for a charge of $95. If the problem is due
to a bug in ASP-db, the Incident fee will be waived - AND we will
send you a FREE UPDATE that fixes the reported problem if at all
possible. In either case, we would ask that you try to reproduce
this problem using either Microsoft's Access Northwind database or
the SQL Server PUBS database.

Please submit the source code (asp file) that repoduces this
problem, along with a description of the steps we will need to go
through to see the problem that you are reporting. It would also
be VERY HELPFUL if you could send the SHORTEST, SIMPLEST
example that demonstrates this problem.

Thanks.
Mark.

Thread: Pb with conditional display with ASPdb 2.2127 EP

Thread Tools

Display

Pb with conditional display with ASPdb 2.2127 EP

Pb with conditional display with ASPdb 2.2127 EP (reply)

Yes!!! But how to format two fields in the same cell

Yes!!! But how to format two fields in the same cell (reply)

Yes!!! But how to format two fields in the same cell (reply)

Format two fields in the same cell using javascript.

Posting Permissions