r1xliquid
Posts: 41
|
| Posted: 11/14/2006, 6:33 AM |
|
I am trying to create a simple page to display 1 record from a VIEW, but i will be using a STORED PROCEDURE for insert, update and delete.
what is the easiest way to handle this with ccs?
i appreciate any guidance.
|
 |
 |
Motaro
Posts: 8
|
| Posted: 11/14/2006, 12:10 PM |
|
I think you are better off putting the sql statements in the Grid Record from the design view. Instead of using a Stored Procedure, at least that's my opinion.
_________________
"Democracy is the name we give others when we need something from them" |
|
|
|
slynch401k
Posts: 15
|
| Posted: 11/14/2006, 4:42 PM |
|
Here's what I do. I create a wizard. Drop a table or view panel on a page. Delete everything except the submit button. Set the submit button to run the stored procedure and then go to your edit table page.
HTHs
Steve
|
|
|
|
sirichai
Posts: 22
|
| Posted: 11/14/2006, 7:41 PM |
|
Hi slynch401k,
I also have like this problem. It's very interesting for this way to do. Could you press the custom code on submit button for me to study?
(Due to I less on codeing in asp code)
Thanks,
Sirichai
|
|
|
|
r1xliquid
Posts: 41
|
| Posted: 11/17/2006, 8:29 AM |
|
hey guys, i am on codecharge v3.0 and i did a regualr editable grid, i did a custom insert and told it to use the stored procedure. Everything in code charge looks good, the insertRow method and Insert method look ok to me. When i click Add on my live page the page posts and nothing happens. As far as i know the stored procedure isnt even called.
i am ready to tell my boss to ditch this program; its so hard to use!
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 11/17/2006, 9:34 AM |
|
r1xliquid,
I would strongly suggest to contact support!
Yhe are friendly and helpful.
They can probably tell you what to do or where to (environmetly friendly) ditch.
(meant to cheer you up)
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
r1xliquid
Posts: 41
|
| Posted: 11/17/2006, 1:52 PM |
|
Walter,
thank you for the reply, i took your advice and used the web form to enter a support ticket. I have yet to here back. I was hoping to solve this problem by then end of the day!
regards,
Brian
|
|
|
|
