Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sysadmin07

    MS Access VBA

    Hi, Within Access, I have some data in a table that I'd like to use to selectively populate another table. Per the example table below, I'd like to dump all data into another table, although where the State is equal to California, I'd like to only populate the values where LName is equal to...
  2. sysadmin07

    Converting for Internet View

    Hi, I'd like to make my Access forms viewable online, in which there is a lot of VBA code behind them. Ideally, there would be a converter to transition them to whatever language necessary. Regardless, what are your opinions and recommendations? Thanks.
  3. sysadmin07

    "Invalid Data" Error When Editing Records

    Got it working! Was related to the code on my action page. Thanks very much for your help
  4. sysadmin07

    "Invalid Data" Error When Editing Records

    Thanks, that sounds like it might work. However, when adding the revisions, as outlined in Phil's post, I receive the error "The given fieldname "primarykey_1" could not be found in the table "tbltest"." I believe this is because the name of the field in the database (which I cannot change due...
  5. sysadmin07

    "Invalid Data" Error When Editing Records

    Does anyone please have any ideas from my question in the above post? I've been researching the issue and I can't determine a way to traverse row by row, when the values are tied to a single variable and separated by commas. Thanks
  6. sysadmin07

    "Invalid Data" Error When Editing Records

    I've come across another issue now. On my form page, if I display all rows that contain the value "r1", and then submit to my action page, the variable "PrimaryKey" contains "1,2", "Column 1" contains "r1,r1" and "Column2" contains "r2,r4". When I'm looping through the values on the action...
  7. sysadmin07

    Hiding a sub-area for non-users

    Thanks PlanningCouncil. It is a site. As of right now, only the members have permission, but the non-members can still see it. If they attempt to enter, they are given the option to request access. Any more ideas? Thank you.
  8. sysadmin07

    "Invalid Data" Error When Editing Records

    The unique identifier is a non-primary key field. If multiple rows have the same unique identifier, then they will be displayed on the form. Unfortunately, I can't post the form, as it contains proprietary information. Thank you for your help. I will report back, based upon my progress.
  9. sysadmin07

    "Invalid Data" Error When Editing Records

    Thanks, GUJUm0deL. The number of rows displayed is dependent upon the amount of records equal to, in this example, "r1" so there could be more than two. Should I place your code on the action page, in place of the cfupdate? Also, what does the cfsqltype perform? I'm not using sql in this...
  10. sysadmin07

    Hiding a sub-area for non-users

    Hi, I have a sub-area in SharePoint, in which the members of it have been appropriately defined. Although non-members can't access it, they can still see that the link to the sub-area exists. Is there any way that I can hide the link for non-members? Thanks.
  11. sysadmin07

    "Invalid Data" Error When Editing Records

    Anyone have any more ideas? Thanks a lot!
  12. sysadmin07

    "Invalid Data" Error When Editing Records

    To be honest, I've never used an update query before. Also, all of my other pages use a cfupdate command. I'd be willing to research the function and implement it, if it's the cause for my problem. If not, please let me know if you have any other ideas. Thanks.
  13. sysadmin07

    "Invalid Data" Error When Editing Records

    Here is an example of how I'm displaying the records: <CFQUERY NAME="displayData" DATASOURCE="test"> SELECT * FROM tbltest WHERE recordID='#session.recordID#' </CFQUERY> Upon submission, the page utilizes an "action" page to use the code below to perform the update: <cfupdate...
  14. sysadmin07

    &quot;Invalid Data&quot; Error When Editing Records

    Hi, I have a CF page that allows me to edit records in a MS Access database (the primary key in the database is autonumber-based). If I try to edit one row of the database from my CF page, everything works fine. However, if more than one row needs edited and is displayed on my CF page, upon...
  15. sysadmin07

    mysql.err File

    Thank you for the fast reply. So, this is something that does not need backed up?
  16. sysadmin07

    mysql.err File

    Hi, Our nightly backups are approaching capacity and I've noticed that the mysql.err file is rather large. Can this be excluded from the backups? Would it have an effect on recovery, if a disaster occurred and the mySQL databases needed recovered from backup? Thanks.
  17. sysadmin07

    Dynamic Number of Tables

    Does anyone have any ideas? I believe I know the cause for the "Invalid data 1,2 for CFSQLTYPE CF_SQL_INTEGER" error, I just can't figure out a workaround for it. When there is more than one table displayed (two in the following example), the table entries are modified, and the "submit" button...
  18. sysadmin07

    Dynamic Number of Tables

    Hi, Here is the ColdFusion portion of the update page: <cfupdate datasource="YourDataSource" tablename="YourTable"> It works with only one table, but when there are two or more tables present, I get the following error (where 1 and 2 are the primary keys of two different rows in the Access...
  19. sysadmin07

    Dynamic Number of Tables

    Anyone know why I'm getting the primary key-related error in my post above? I still can't figure it out. Thanks.
  20. sysadmin07

    Dynamic Number of Tables

    Thanks! The lack of <BR> before the </cfoutput> tag was the cause of the tables not displaying properly. However, with more than one table, I am getting an error on my cfupdate page. My primary key is an autonumber and when I edit the tables and then click "Submit" (which goes to my cfupdate...

Part and Inventory Search

Back
Top