Solved

a guidance needed in the following code

Posted on 2013-01-22
3
128 Views
Last Modified: 2013-06-20
i have a following screenshot, whereas in one form, i need to add the products for single invoice and i can add multiple products.

I can create the new products and price easily, i am facing issue during insert/update, i am doing an insert into two tables rather in one. one for products and other for the invoice so 1 invoice can have n products,

i am having some issues in CRUD, need a bit of guidance in this

i know this will be asked [what you have done so far], honestly nothing, i need fresh idea where i should go ahead
color.bmp
0
Comment
  • 2
3 Comments
 
LVL 10

Expert Comment

by:stu215
ID: 38812141
What kind of problem are you having? Error?

- when you submit the form it should do 2 inserts, one into the header table and the other should loop over line items ( name, qty, price )...?  then return to a printable invoice page?
0
 
LVL 15

Accepted Solution

by:
Gurpreet Singh Randhawa earned 0 total points
ID: 38823713
i solved it
0
 
LVL 15

Author Closing Comment

by:Gurpreet Singh Randhawa
ID: 39261883
Solved by adding a different set to the post
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now