This topic is locked

Error in 5.2

3/9/2008 7:42:23 PM
ASPRunnerPro General questions
G
goomba author

I have three issues/questions so I thought I'd post them together.
I'm trying to add a record using 5.2 eval. I have 2 tables (very simple ones for testing).
T1 (Master) has 3 columns:

  1. CatID, (P)
  2. CatDesc,
  3. DateAdded
    T2
  4. CatID (IDX - used to related to T1),
  5. DateAdded,
  6. Comments
    When I try to add a record to T2, I get this
    <<< Record was NOT added >>>
    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
    I know that my DB is fine, cause i can do this with ASPmaker, so I think I'm doing something wrong here.
    Also, how do I enable Captcha support in 5.2 for the Login Page?
    I've used Captcha code in ASPmaker for about a year and I know my code works, but I can't even see any place on the page to enable Captcha and as this is an eval version, I don't want to spend a bunch of time adding and testing my code to ASPrunner.
    Finally, when I create a List page, the WYSWIG editor doesn't allow me to change the Column Display width of a text column that is 60 characters. I'd like to display either all 60, or 30 with wrapping. Can I do this, if so how?
    Thanks to all.

Sergey Kornilov admin 3/9/2008

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
this error message is generic. Usually it means you trying to update field that is not updatable like key column. This also happens when you trying to enter text into numeric field.
You can publish your application to Demo Account and send the URL to support@xlinesoft.com for investigation.
To enable CAPTCHA proceed to Security->User Login Settings Dialog. Make sure you running the final version of ASPRunnerPro 5.2.
To make column wider in Visual Editor you need to drag it's edge to the right.

G
goomba author 3/10/2008

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

this error message is generic. Usually it means you trying to update field that is not updatable like key column. This also happens when you trying to enter text into numeric field.
You can publish your application to Demo Account and send the URL to support@xlinesoft.com for investigation.
To enable CAPTCHA proceed to Security->User Login Settings Dialog. Make sure you running the final version of ASPRunnerPro 5.2.
To make column wider in Visual Editor you need to drag it's edge to the right.


Thanks for the reply admin.
I think I got the Multi-step figured out. For some reason (don't know why), but it seems that Runner was trying to update a key column in my table. I'm going to play to figure out which on (only have one so it shouldn't be too hard).
Column Wider: when I slide the column indicator, everything moves left/right. I mean all the contents on the page and it doesnt really resize perperly.
CAPTCHA, I have my own captcha code that I want to use, Can I do so, if so how?
Thanks for the reply.

J
Jane 3/12/2008

Hi,
you can edit column width manually in the HTML mode on the Visual Editor tab.
To add your CAPTCHA code edit templates/register.htm and register.asp files.

G
goomba author 3/13/2008

Thanks, editing the HTML was so simple an answer I feel dumb asking it.
My Captcha code works. Thanks for the pointers.
ps: I use mine, cause it creates BMP file that is displayed instead of transmitting text to the user.