Problem with MagicCell and Format

[yodamon]

Please tell me whats wrong with this format usage. It used to work with older versions.

MyDb.dbMagicCell = "GraphicsAutoNumber,align=right,<A HREF=M:\Graphics\Format=[0000000#].#FileExtension#>Format=[0000000#].#FileExtension#</A>;"

in the generated html it gives me this:
<TD align=right><font Face=Arial Size=2 color=000000><A HREF=M:\Graphics\Format=[0000000ErrorFileExtensionError].pdf</A></font></TD>

Thanks
Les Taylor

[Frank]

there is a change in Tornado in "Format". I think the syntax is like

#field:len:format# so in your case try -

<A HREF=M:\Graphics\#GAN::0000000##.#FileExtension#># GAN::0000000##.#FileExtension#</A>;"

GAN =graphicsautonumber


I also included this examplein TED under <Magic Format> and the code is -

<script language='vb' runat='server'>
Sub Page_Load(Source as Object, E as EventArgs)
Dim Mydb As New Tornado.Z()
With Mydb
.dbQP = "U=1|S=4|D=Nwind.mdb|M=grid"
.dbSQL = "Select orderid from orders"
.dbGridMagicCell = "(;,[]!|~/+{})fi=0|mac=Filename=!0:000000#!.ext"
.dbTextHolder = "Title=MagciCell Format"
.ASPdbNET()
End With
'...Note that when using a numeric format, the field wrapper # must be changed.
'...Also note that macro can be either Field:len:Format or Field:Format.
End Sub
</script>

[yodamon]

The problem is in Classic at this moment, but I will need this in the short futrue fot Tornado. I am sorry that I did not give you tis data in my first post.

Thanks
Les

[Frank]

seems like at the least your field wrapper is wrong. This is same for both classic and Tornado. Change that first and see what happens.


FK

[yodamon]

Thanks!!! I got it now. Here is the code.

(;,[]!|~/+{})GraphicsAutoNumber,align=right,<A HREF=M:\Graphics\!GraphicsAutoNumber:8:Format=[0000000#]!.!FileExtension!>!GraphicsAutoNumber:8:Format=[0000000#]!.!FileExtension!</A>

You are the greatest!

[Frank]

can you try w/o the Format=[...] like ->

(;,[]!|~/+{})GraphicsAutoNumber,align=right,<A HREF=M:\Graphics\!GraphicsAutoNumber:8:000
0000#!.!FileExtension!>!GraphicsAutoNumber:8:00000 00#!.!FileExtension!</A>