Re: [ACFUG Discuss] FW: the old record viewer wizard
Why not use the wizards that adobe has for eclipse? Can point to a DB and create simple CRUD with flex UI in mninutes. DK On 5/16/08, Dusty Hale <[EMAIL PROTECTED]> wrote: > Thanks I do have the cfgridupdate going as well. It worked perfect when > using applet but not Flash. The action page is the same page. Code below if > you see anything I am doing wrong please let me know. The primary key is all > set on the table. > > > >username="#application.db_user#" password="#application.db_pword#" > tableName = "tblARTavail" keyonly="yes"> > > > > username="#application.db_user#" password="#application.db_pword#"> > select record_id, donorid, ARTonly from tblARTavail > > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > http://www.w3.org/1999/xhtml";> > > > Untitled Document > > > > >query = "q" insert = "Yes" > delete = "Yes" sort = "Yes" > font = "Tahoma" bold = "No" italic = "No" > appendKey = "Yes" highlightHref = "No" > gridDataAlign = "LEFT" gridLines = "Yes" > rowHeaders = "Yes" rowHeaderAlign = "LEFT" > rowHeaderItalic = "No" rowHeaderBold = "No" > colHeaders = "Yes" colHeaderAlign = "LEFT" > colHeaderItalic = "No" colHeaderBold = "No" > selectColor = "Red" selectMode = "EDIT" > pictureBar = "No" insertButton = "To insert" > deleteButton = "To delete" sortAscendingButton = "Sort ASC" > sortDescendingButton = "Sort DESC"> >bold = "Yes" italic = "No" > select = "No" display = "Yes" > headerBold = "No" headerItalic = "No"> >bold = "Yes" italic = "No" > select = "Yes" display = "Yes" > headerBold = "No" headerItalic = "No"> >headerAlign = "LEFT" dataAlign = "LEFT" > bold = "Yes" italic = "No" > select = "Yes" display = "Yes" > headerBold = "No" headerItalic = "Yes"> > > > > > > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: 05/16/2008 5:30 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard > > Well, you still need to have an "action" page. On the action page you'd > have the cfgridupdate tag: > > grid = "gridname" > dataSource = "data source name" > tableName = "table name" > username = "data source username" > password = "data source password" > tableOwner = "table owner" > tableQualifier = "qualifier" > keyOnly = "yes" or "no"> > > It's very important to have the primary key for your table on the grid > itself, but you can have it hidden if you want - but the cfgridupdate tag > will not work correctly if you don't have the primary key somewhere on the > grid. > >> Thanks I switched it over to Flash. However now the grid doesn't seem >> to update the changes when entered. I'm sure there is probably some >> other attribute I need to use or something. I'll try to figure it out. >> >> Dusty >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike >> Staver >> Sent: 05/16/2008 4:37 PM >> To: discussion@acfug.org >> Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard >> >> >> >>> LOL I was already looking into cfgrid. Almost done with it I think. >>> But I would much prefer it to run in Flash rather than the Java >>> applet it seems to generate. I am trying to figure that out now but >>> would appreciate any quick advice anyone may be able to give about that. >>> >>> Thanks, >>> >>> Dusty >>> >>> -Original Message- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike >>> Staver >>> Sent: 05/16/2008 12:18 PM >>> To: discussion@acfug.org >>> Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard >>> >>> Well, even though I'm not familar with the tool you used to use and >>> I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and >>> higher are very fast to use. You can quickly add buttons for adding >>> or deleting rows, while simply highlighting and editing a row allows >>> it to update. >>> There were some bugs with those initially, but several hot fixes for >>> CF 7 cleared up most of my problems. >>> Is anyone here familiar with the record viewer wizard from CF Studio (eons ago)? If anyone knows of some new and quick way to generate a web based add/edit/delete feature for one table in an SQL Server database, please let me know. Many years ago I used the record viewer wizard in CF Studio to do this. I was hoping that there is a newer and better way to do this like some how binding a form to a database table. Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com --
RE: [ACFUG Discuss] FW: the old record viewer wizard
Thanks I do have the cfgridupdate going as well. It worked perfect when using applet but not Flash. The action page is the same page. Code below if you see anything I am doing wrong please let me know. The primary key is all set on the table. select record_id, donorid, ARTonly from tblARTavail http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> Untitled Document -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 5:30 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard Well, you still need to have an "action" page. On the action page you'd have the cfgridupdate tag: It's very important to have the primary key for your table on the grid itself, but you can have it hidden if you want - but the cfgridupdate tag will not work correctly if you don't have the primary key somewhere on the grid. > Thanks I switched it over to Flash. However now the grid doesn't seem > to update the changes when entered. I'm sure there is probably some > other attribute I need to use or something. I'll try to figure it out. > > Dusty > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver > Sent: 05/16/2008 4:37 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard > > > >> LOL I was already looking into cfgrid. Almost done with it I think. >> But I would much prefer it to run in Flash rather than the Java >> applet it seems to generate. I am trying to figure that out now but >> would appreciate any quick advice anyone may be able to give about that. >> >> Thanks, >> >> Dusty >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike >> Staver >> Sent: 05/16/2008 12:18 PM >> To: discussion@acfug.org >> Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard >> >> Well, even though I'm not familar with the tool you used to use and >> I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and >> higher are very fast to use. You can quickly add buttons for adding >> or deleting rows, while simply highlighting and editing a row allows >> it to update. >> There were some bugs with those initially, but several hot fixes for >> CF 7 cleared up most of my problems. >> >>> Is anyone here familiar with the record viewer wizard from CF Studio >>> (eons ago)? If anyone knows of some new and quick way to generate a >>> web based add/edit/delete feature for one table in an SQL Server >>> database, please let me know. Many years ago I used the record >>> viewer wizard in CF Studio to do this. I was hoping that there is a >>> newer and better way to do this like some how binding a form to a >>> database table. >>> >>> Thanks, >>> >>> Dusty >>> >>> >>> >>> - >>> To unsubscribe from this list, manage your profile @ >>> http://www.acfug.org?fa=login.edituserform >>> >>> For more info, see http://www.acfug.org/mailinglists Archive @ >>> http://www.mail-archive.com/discussion%40acfug.org/ >>> List hosted by http://www.fusionlink.com >>> - >>> >>> >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> >> >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> >> > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > --
RE: [ACFUG Discuss] FW: the old record viewer wizard
Well, you still need to have an "action" page. On the action page you'd have the cfgridupdate tag: It's very important to have the primary key for your table on the grid itself, but you can have it hidden if you want - but the cfgridupdate tag will not work correctly if you don't have the primary key somewhere on the grid. > Thanks I switched it over to Flash. However now the grid doesn't seem to > update the changes when entered. I'm sure there is probably some other > attribute I need to use or something. I'll try to figure it out. > > Dusty > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: 05/16/2008 4:37 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard > > > >> LOL I was already looking into cfgrid. Almost done with it I think. >> But I would much prefer it to run in Flash rather than the Java applet >> it seems to generate. I am trying to figure that out now but would >> appreciate any quick advice anyone may be able to give about that. >> >> Thanks, >> >> Dusty >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike >> Staver >> Sent: 05/16/2008 12:18 PM >> To: discussion@acfug.org >> Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard >> >> Well, even though I'm not familar with the tool you used to use and >> I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and >> higher are very fast to use. You can quickly add buttons for adding >> or deleting rows, while simply highlighting and editing a row allows >> it to update. >> There were some bugs with those initially, but several hot fixes for >> CF 7 cleared up most of my problems. >> >>> Is anyone here familiar with the record viewer wizard from CF Studio >>> (eons ago)? If anyone knows of some new and quick way to generate a >>> web based add/edit/delete feature for one table in an SQL Server >>> database, please let me know. Many years ago I used the record viewer >>> wizard in CF Studio to do this. I was hoping that there is a newer >>> and better way to do this like some how binding a form to a database >>> table. >>> >>> Thanks, >>> >>> Dusty >>> >>> >>> >>> - >>> To unsubscribe from this list, manage your profile @ >>> http://www.acfug.org?fa=login.edituserform >>> >>> For more info, see http://www.acfug.org/mailinglists Archive @ >>> http://www.mail-archive.com/discussion%40acfug.org/ >>> List hosted by http://www.fusionlink.com >>> - >>> >>> >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> >> >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> >> > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
Thanks I switched it over to Flash. However now the grid doesn't seem to update the changes when entered. I'm sure there is probably some other attribute I need to use or something. I'll try to figure it out. Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 4:37 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard > LOL I was already looking into cfgrid. Almost done with it I think. > But I would much prefer it to run in Flash rather than the Java applet > it seems to generate. I am trying to figure that out now but would > appreciate any quick advice anyone may be able to give about that. > > Thanks, > > Dusty > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver > Sent: 05/16/2008 12:18 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard > > Well, even though I'm not familar with the tool you used to use and > I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and > higher are very fast to use. You can quickly add buttons for adding > or deleting rows, while simply highlighting and editing a row allows > it to update. > There were some bugs with those initially, but several hot fixes for > CF 7 cleared up most of my problems. > >> Is anyone here familiar with the record viewer wizard from CF Studio >> (eons ago)? If anyone knows of some new and quick way to generate a >> web based add/edit/delete feature for one table in an SQL Server >> database, please let me know. Many years ago I used the record viewer >> wizard in CF Studio to do this. I was hoping that there is a newer >> and better way to do this like some how binding a form to a database >> table. >> >> Thanks, >> >> Dusty >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
> LOL I was already looking into cfgrid. Almost done with it I think. But I > would much prefer it to run in Flash rather than the Java applet it seems > to > generate. I am trying to figure that out now but would appreciate any > quick > advice anyone may be able to give about that. > > Thanks, > > Dusty > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: 05/16/2008 12:18 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard > > Well, even though I'm not familar with the tool you used to use and I'm > not > a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are > very > fast to use. You can quickly add buttons for adding or deleting rows, > while > simply highlighting and editing a row allows it to update. > There were some bugs with those initially, but several hot fixes for CF 7 > cleared up most of my problems. > >> Is anyone here familiar with the record viewer wizard from CF Studio >> (eons ago)? If anyone knows of some new and quick way to generate a >> web based add/edit/delete feature for one table in an SQL Server >> database, please let me know. Many years ago I used the record viewer >> wizard in CF Studio to do this. I was hoping that there is a newer and >> better way to do this like some how binding a form to a database >> table. >> >> Thanks, >> >> Dusty >> >> >> >> - >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> - >> >> > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
LOL I was already looking into cfgrid. Almost done with it I think. But I would much prefer it to run in Flash rather than the Java applet it seems to generate. I am trying to figure that out now but would appreciate any quick advice anyone may be able to give about that. Thanks, Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 12:18 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard Well, even though I'm not familar with the tool you used to use and I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are very fast to use. You can quickly add buttons for adding or deleting rows, while simply highlighting and editing a row allows it to update. There were some bugs with those initially, but several hot fixes for CF 7 cleared up most of my problems. > Is anyone here familiar with the record viewer wizard from CF Studio > (eons ago)? If anyone knows of some new and quick way to generate a > web based add/edit/delete feature for one table in an SQL Server > database, please let me know. Many years ago I used the record viewer > wizard in CF Studio to do this. I was hoping that there is a newer and > better way to do this like some how binding a form to a database > table. > > Thanks, > > Dusty > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] FW: the old record viewer wizard
Well, even though I'm not familar with the tool you used to use and I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are very fast to use. You can quickly add buttons for adding or deleting rows, while simply highlighting and editing a row allows it to update. There were some bugs with those initially, but several hot fixes for CF 7 cleared up most of my problems. > Is anyone here familiar with the record viewer wizard from CF Studio (eons > ago)? If anyone knows of some new and quick way to generate a web based > add/edit/delete feature for one table in an SQL Server database, please > let > me know. Many years ago I used the record viewer wizard in CF Studio to do > this. I was hoping that there is a newer and better way to do this like > some > how binding a form to a database table. > > Thanks, > > Dusty > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] FW: the old record viewer wizard
Is anyone here familiar with the record viewer wizard from CF Studio (eons ago)? If anyone knows of some new and quick way to generate a web based add/edit/delete feature for one table in an SQL Server database, please let me know. Many years ago I used the record viewer wizard in CF Studio to do this. I was hoping that there is a newer and better way to do this like some how binding a form to a database table. Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
