COAddOns project site-Add-Ons for MiaCMS, Mambo & Joomla CMS

 Home arrow FAQs arrow FAQ: MosQ arrow MosQ: How to build view/edit form?
Get Chitika | Premium
Pick Language to Auto Translate:
AR | BG | CA | CS | DA | DE | EL | ES | FI | FR | HI | HR | ID | IT | IW | JA | KO | LV | LT | NO | NL | PL | PT | RO | RU | SK | SR | SL | SV | TL | UK | VI | ZH | ZT
SiteMap :: Contact Us :: About Us :: Member Blog :: Newsfeeds :: How-To :: News :: CMS Info :: MosNews :: Web Tools :: IRC Chat  

Main Menu
Home
Forums
Downloads
CMS Category
Web Links
FAQs
Blog
MoseCMS
COAddOns Wiki
COAddOns Docs
Drupal resources
Who's Online
We have 497 guests online
MosCmenuTree

FAQs

Feature Sites
Web Hosting
Q's quickdeals
OpensourceCMS
CMS Matrix
Joomla Extensions
Joomla Templates
Login Form
Username

Password

Remember me
Password Reminder
No account yet? Create one
Donate
Support OngETC in making a small donation:
Syndicate

MosNewsWriter

MosQ: How to build view/edit form? Print E-mail
User Rating: / 8
PoorBest 
MosQ has a concept call logic chaining and logic buttons which will enable you to create a data entry application using MosQ.

Q: How do I create a view/edit form?
A: The concept is you create a view searchable form and assign an "edit logic button" to your search form then on your "edit form" you chain it to a "save logic button" to save your data.

For example:
Here is a "View" searchable form where the user will enter an id:

View logic:
sql@SELECT id AS 'Entry ID', title AS Title
FROM mos_weblinks WHERE id = |Entry Number|
Note: set view type = form

Once they got the form to show the record with the id that they enter previously then this form will show the record with a button to save the info.  So when they click on the "Save" it will run the logic in the "Save button logic"

Edit button logic:
sql@SELECT id, title FROM mos_weblinks WHERE id=|id|
Note: set view type = edit

When the "Save" button was click from above this logic will be executed and save the data:

Save button logic:
sql@UPDATE mos_weblinks SET
title = '|Title|',
WHERE id=|id|
Note: set view type = none, logic chaining option = "your view logic" so it go back where it started.

I hope this article will give you some basic knowledge on how to build a more complex application that meet your need.
Comments

Hi again,

Yes, I've removed the .htaccess. Also I could find the only SEF which is in plugin manager and turned that off.
Yes, the Mosq still works.
I am using Centos5.2 linux, I've installed the xampp 1.7.0 which gives me a suite of apache 2.2 (I think), php5.2.8 and mysql5.1.30, all these
are running on joomla1.5 . I am using your mosq1.1.6

Please let me know once you find a solution, I will check this page from time to time in case you need more info also.

thank you kindly once again,

yours sincerely,
Rajan

Posted by rajanm, on 04/21/2009 at 04:21

I suggest you to rename .htaccess to something else so it won't be use and turn off all SEF related setting to see if MosQ work. If it is then I will try to see if I can track down where and what with MosQ for future release.
Please provide all the specific components and version of all related in your CMS, including your CMS, PHP, Apache or Windows, etc so I can try to recreate the problem on my machine.

Thanks

Posted by Chanh Ong, on 04/19/2009 at 22:11

hi again,

yes, SEF was already turned on. I found it as 'System-SEF' in Plugin Manager and it was public access level.
But this is what I decided to do. Firstly I changed the access level to 'Special'. I tried again but to no avail.

Same with 'registered' level.
At the global configuration level, and at the SEO Settings box, I also changed to 'Search Engine Friendly URLs' from no to yes,
and likewise 'Use Apache mod_rewrite' to yes and of course renamed the htaccess.txt to .htaccess.
Unfortunately all did not work.

Please advise is there anything else I need installed or turned on.

Thank you kindly once again,

yours sincerely,
Rajan

Posted by Rajan, on 04/19/2009 at 21:03

Do you have SEF turn on?
Please turn that off and see if that work.
Thanks

Posted by Chanh Ong, on 04/16/2009 at 07:52

Hi,

I was trying out mosq samples provided , and with 'Edit User Note' sample, when I click 'Edit User Note' in the 'Admin'
window, Nothing came out. I have the same problem with 'Add User Note' example.

'View User Note' and 'Search Notes' worked ok, I was able to search and bring up the data on the webpage.

I tried playing with the syntax according to my phpmyadmin but still nothing appeared. I imagine for the example I should be able to edit after
selecting the id number ?

Appreciate your kind input as this will help me understand how to use mosq.

yours sincerely,
Rajan

Posted by rajan, on 04/16/2009 at 04:15

 1  2  3  4  5  ....  Next Page >
Page 1 of 6 ( 28 Comments )

You are not authorized to leave comments. Please login first.
<Previous   Next>




Sponsors

Reseller hosting (free)

000webhost (free)

HostUpon (w/ ssh)

Hosting24 (w/ ssh)

Free TK domain

CO.CC:Free Domain

Get Chitika Premium

Free Windows Hosting


Renegade Motorhomes - Credit Card Consolidation - Credit Counseling - Credit Consolidation
Validate XHTML
Validate CSS