Comments by Member 13812021 (Top 22 by date)

I have gotten the file to upload but I am still not able to save the file name in the database that it uploads. So when I upload an image I would like the record to save the filename in the column ProductImage

I am using jqgrid to show my records. Since it has the capability of adding and editing also I thought it was the clean way to go. Ultimately I would like to add a record with a image link included with the product. The link would be where the file Upload creates the folder and image storage preferably the category that it is in. So create a folder inside of the images folder (if not there already) and put the photo in it. I believe that I can handle the thumbnail with just Css when the page is loaded. But if you think, for display purposes it would be better to load a thumbnail instead than I would probably have to agree that it would make load time quicker. Also not looking for inline editing either. The popup provided is good enough.

The save is the 'Create Customer' in the controller section above. I will have to look at it later. The same code is being used in another table and it works, that is what it confusing to me. I thought I may have missed something in the copy.

Right now the table is empty. There is no row selected. I will put a record in the table manually as I did before to make sure it was showing in the grid. I deleted them with the delete button so both of those work. I also have a users table that appears to be working but it already has records in the table. I will post my findings. However if this is the case, why does it require that there be data in the table before it will work?

Okay added a record manually. Not sure what is going on. It still uses the edit and when I go to edit a record it saves it in the table as a new record. So edit is using add and add is using edit????

Thank you for the reply, I had to add a reference to the top also. Which I thought I had there already.

That is why I explained that if I manually put the dates in the parameters it works. I need to pass the dates to the stored procedure through the view form. I have tried a few things with "mydata" and it still wants to run the stored procedure on refresh or load. I think I might try to put the grid in a partial and maybe an if statement for the dates so it will not run the Proc unless there is parameters. Thanks for your help although some sample code would have helped.

Look here: https://stackoverflow.com/questions/2915748/convert-a-series-of-parent-child-relationships-into-a-hierarchical-tree

You have a record in the table that you are querying with nothing in it and it is set to NotNull. If you are going to have a null reference in a null space than you should select the default value as being (''). Then it will be blank or whitespace and should take care of the error you are getting.

Perhaps you will find some help here: https://stackoverflow.com/questions/28874531/6x6-bingo-game-when-a-drawn-number-is-on-the-card-add-1-to-the-7th-column-and

Could you explain maybe why you are in need of counting? Also what is this doing, the text box. If someone puts a url in it, why would they click on it. Just trying to get my head wrapped around the procedure.

This is better served as either a data sheet or stored in a secure table. I am not sure what the reasoning is but if you do hold this data anywhere every time someone is logging in, you are going to end up with a very large set of data. If you are trying to accomplish user logins, maybe consider adding a column in the table as an int that increments every time they login with a current date and maybe an IP address if you want.

There are many ways to this however it depends on what you are doing this in. Is it a Web Razor page, a win app, or something else. A pie chart is going to be based on a % or int value. What are you using to create the chart?

When they select a coarse what is taking place? Is there a table with courses that are with associated user? Meaning is there a course table, user table, and then a UserCourses table? Or is there a User table, coarse table, UserToCourse Table?

It would help to see JavaScript and css. I would think you should be using to correspond with the javascript so that it will drop down. You are showing a list of links.

You should place some code so we can see what is causing the error.

Is there a reason you are separating them? Where are the "crdt" and "time" coming from?

I guess i am wondering where the matching data comes from? Database? Also where are they inputting this? You show a dropdown list but not an entry textbox.