grrrr!!
|
| Posted: 06/24/2005, 2:25 PM |
|
Hi, I just started using CC for an SQL Server 7 database. I keep running into this problem though.
I have used the both the application wizard to setup a search and list page and a add/edit record page for one table. As well as manually develop an add/edit record page. Everything so far works pretty good except the record page. Whenever I am editing and click "submit" it appears to work fine but nothing in the database changes. No error messages or anything but the page comes back up with the original info.
Same thing happens when adding a record only no record gets added.
Any suggestions on where to locate this problem would be great. I have looked extensively through the help files and on this website without much results. I like CC so far but if I can't get this to work I may not purchase it. I'm sure its probably something really simple but I can't find it.
|
|
|
 |
donb
Posts: 52
|
| Posted: 06/24/2005, 4:16 PM |
|
Sounds like the page doesn't submit at all. Probably the button is no located within the <FORM>...</FORM> or the action is not correctly set for it.
You also will have separate buttons for Add, Update (submit), Delete (in case you just have one button for some reason).
Other than that, you might not have the primary key defined or not defined correctly, so that the database action can't be performed.
You should try a test app using the Internet.mdb database (Access) and see if you can make that insert/update. There might be an issue with how you have SQL Server configured.
It is certainly something really simple but there are quite a few things that it could be.
_________________
http://www.gotodon.com/ccbth |
 |
|
Intexk
|
| Posted: 06/27/2005, 10:40 PM |
|
i had the same problem in new versions of codecharge (above 2.2.3)...if u select manually an sql and u add parameters, it doesn't retrieve the values of parameters to build the sql.for example: "update users set user_name={NAME} where user_id={USER_ID}" and i set the parameters to read from url...or another source...and when i look at the portion of code that codecharge autogenerate in version prior 2.2.3 it retrieves parameters ok...but in upper version it does a strange thing and never translate the parameters...
PD: i have seen that behaivour and i can send a test program...my boss updated codecharge last week and after i saw that destroyed all the work (thx to god i had backup) we reinstalled last version.
|
|
|
|
grrrr!!
|
| Posted: 06/28/2005, 9:09 AM |
|
Intexk, if thats the case we can't be the only ones having this problem and I have yet to see a workaround on this website. My trial ran out today after spending the majority of the trial period trying to figure out this issue. I spent all day yesterday going over donb's suggestions. I still don't know if I want to buy it or not. Do you think its fixed in the latest version? Would you buy it anyway and just set up some kind of custom insert/edit? Or just go back to Dreamweaver?
|
|
|
|
Intexk
|
| Posted: 06/28/2005, 2:06 PM |
|
i have being working with codecharge during 2 years...i have worked with any program that can generate asp,php or simply html...and codecharge just ROCKS!...it's the best piece of code u can find outthere...if just posted in another thread what is happening when i try to regenerate pages generated with older versions...and that new versions aren't handling them ok...Every Program has bugs...and the more bugs we catch..the better we will made the product.
I still believe codecharge is the best RAD outthere...and rad means u will not spent a lot of money to get a complex and robust webpages working...i think it worth every $ u spend in codecharge...cause u will not use it in wasting ur time in hand coding.
My advice is u download version 2.2.3..i still use that version in the company and runs fine...and i'm sure these dudes will fix actual versions.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/28/2005, 2:27 PM |
|
I think that over 90% of our customers use the version 2.3 and have upgraded from previous versions (1.0, 2.0, 2.2), sometimes with minor problems but I haven't see anything major. Most upgrade problems are related to:
1. Using old common files (like Common.asp) generated with a previous CCS version. This is easily fixed by pressing F9 and re-generating the whole project.
2. Modifications made to the generated code, rather than using events. This approach to coding with CCS is not recommended and rare anyway, but in such case indeed an upgrade may be very difficult.
To make sure that this is not happening you can quickly scan through common files and page code in CCS to see if any of the code is shown on a white background rather than gray. Gray color indicates that the code was generated by CCS and wasn't modified manually.
I am not aware of any other issues that could cause upgrade problems, although anything is possible. I can only recommend contacting the product support with any upgrade issues that you may encounter.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Intexk
|
| Posted: 06/28/2005, 2:38 PM |
|
peter...it's ok...i have a lot of experience with codecharge and asp and i have touched everything inside codecharge(commonfiles,styles,etc)....but what i'm saying in this thread and another i started is that the new versions of codecharge above 2.2.3 had a problem in generating sql when u select custom SQL instead custom TABLE.
It doesn't add the parameters properly and when it tries to execute the sql query it does it without translating the parameters.
I have regenerated the commons and let codecharge generated all...and i even started a new simple program(in the new versions) and i reproduced the error...can i send that project to anyone to make them realize of the bug?
|
|
|
|
grrrr!!
|
| Posted: 06/28/2005, 5:09 PM |
|
No upgrades here. Was using the trial version 2.3.2.24
Didn't matter whether I modified anything or not. I used the wizard for one sql table to generate search, list and record page. The record page did not work at all even without any modifications.
donb felt like it was settings on my sql server but have been using the same settings on the server for years now and I'm pretty familiar with connecting to it.
You guys seem to think its an upgrade issue but I downloaded fresh off the website with a new install. I spent nearly the entire trial period trying to get around this issue.
For the most part I have to agree that the program is pretty awesome except for this one issue I'm having. At this point I can't see purchaseing it if its only going to produce half the (working) code I need. Wish I had an earlier version to test out.
|
|
|
|
Intexk
|
| Posted: 06/29/2005, 1:21 AM |
|
send me the project tointexk@hotmail.com....generate the sql scripts for that table(s) and let me check what happens to the project.Zip it all.
And...trust on me...codecharge doesn't generate u the half of the code...i can quarantee u it can produce almost 100%...and the learning curve for this system is very fast.
Beside the posibility to change from sql server to oracle or another dbm is awesome...and the posibility u can produce working code for several web languages(asp,php,perl,etc) makes this product worth getting a personal version.
|
|
|
|
