This topic is locked

ASPrunner pro general dbase

2/11/2009 6:39:18 AM
ASPRunnerPro General questions
J
joseph_707 author

hi all,
I am new to this software and need some help.I am using standard ms access 2007 database and the latest asprunner pro.
The fields containing them are
Name

Date

EmailID

Session

Application Data

I need to achieve the following.
a. How to have a file upload to the database (not pictures but documents word.) in the application data field.

b.How to have check box in my Email Header Field, so I can tick and have a Email button where I can click to sent email to all/selected the addresses in the database. Simple explanation the one in all Inbox system like yahoo,hotmail etc.Instead email addresses are selected individually and I can click on a button so that my default emailing client program would open and I can send email to the addresses....sounds complicated...to me..

c.Thanks for all ya help !
I am a newbie ...please be gentle..with me <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=10890&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Thanks (if any coding is available i would do and learn myself but some basic steps for a start-up)

J
Jane 2/13/2009

Hi,
please see my answers below:

  1. set up this field as File/File on the "View as" settings/"Edit as" settings dialog on the Visual Editor tab. To open these dialogs double click on the field.
  2. I'm not sure that I understand your question.

    Where do you add email button? Please give me more detailed description of what you want to achieve. May be a screenshot or two can help.

J
joseph_707 author 2/14/2009

Hi,

please see my answers below:

  1. set up this field as File/File on the "View as" settings/"Edit as" settings dialog on the Visual Editor tab. To open these dialogs double click on the field.
  2. I'm not sure that I understand your question.

    Where do you add email button? Please give me more detailed description of what you want to achieve. May be a screenshot or two can help.


  1. I did that . Please click on this link. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=37788&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />


    2.Test site

J
Jane 2/16/2009

Hi,

  1. what field do you select in the Choose field that stored filename or database file on the "View as" settings/"Edit as" settings dialogs?
  2. here are some tips:

  • proceed to the Visual Editor tab
  • turn on HTML mode, find this line:
    {BEGIN delete_link}



and add following code just before:

<A onclick="frmAdmin.a.value='update'; frmAdmin.submit(); return false;" href="#">email</A>


And add some code to theBeforeDeleteevent on the Eventstab:

'Delete selected records

if Request.Form("a") = "delete" then

BeforeDelete = True

exit function

end if
'email selected records

'

'add your code here

'

BeforeDelete = False

J
joseph_707 author 2/17/2009



  1. I did that . Please click on this link. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=37862&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />


    2.Test site


  1. My field name is ApplicationData and the field type is OLE Object in MS Access. But in the field,I can't seem to find this field in the "View as" nor "Edit As" settings dialog box. Thus I choose the option None

J
Jane 2/17/2009

Hi,
to save file in the database you need two fields: one (OLE Object) for the file actually and one (text field) for the file name.

J
joseph_707 author 2/20/2009

Hi,

to save file in the database you need two fields: one (OLE Object) for the file actually and one (text field) for the file name.


Thanks Jane it worked for the file upload path. I was able to upload and download the file. Excellent thanks..
But for my second part, I have no clue. I can't get it to work nor do I have some programming skills. Is there any work-around to this solution as per my question 2 in the previous post.
Also, what if I have 20 Fields and I don't want all the 20 fields to be displayed across horizontally.I need to select individual fields to display. Ex- Name,Location,EmpID,Date of Registration and so on. I want now to display only Name and Date of Registration only.How can it done with ASP runner.
I know... i am not good at this..but I am learning.... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38057&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
Thanks jane and the community for your support. !!!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38057&image=2&table=forumreplies' class='bbc_emoticon' alt=':P' />

J
Jane 2/20/2009

Hi,
you can select fields on the pages on the Choose fields tab.

J
joseph_707 author 2/20/2009

Hi,

you can select fields on the pages on the Choose fields tab.


Yep. But that is in the program. I am talking in the website end. 20 Fields are there and in the website I want to display (as and when) may be 3 fields out of the 20. Sometimes I choose Name,ID,Location or at times I just need to select/tick box to view ID and Location only instead of the entire 20 fields.
In the program it is custom i.e mean these fields won't appear on the webpages and can't view the records. I need something in the web end so I can select what fields to display rather than goint to ASPrunner prog.
Hope you understood my question ? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38091&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
thanks