I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.
I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.
Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb
When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record and Keith Robb into the 2nd record in the recordset.
I am using access Memo field to store text of large size. If I use <%=memofield%> in simple display, it does not look like a formatted field and all text comes in a single line without any break.
Even If the text is same like what I am posting in this thread, out come will not have break in browser's display.
I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:
I have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.
i have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,
I need to parse a string from a single, semi-colon delimited, 60 character field (el_text) in a recordset and display the results in a table on a webpage (ASP)
I can retrieve the recordset from the database and display the field data results in rows of a table but have the entire 60 character string in one cell. I need to break that string apart and put each semi-colon delimited value in it's own cell. Then move to the next record and do the same thing in the next row of the table. - and so on
I'm using ASP, VB Script with DMSII Database and OLEDB
Does anyone have some code examples on how to break this field apart and then arrange the data into an html table on a webpage?
I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote:
DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.
Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.
I need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.
is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate Home Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer) GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
I have written a asp application whihc uses a number of pages and each page connects to a sql database. Currently I have the connection script coded on each page however if i need to change the database I have to change every page. I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable. I want the array to be dynamic to store any amount of products which may added.
I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range... You can see an example of this at: http://www.foulkestudios.com/session.asp
I am getting what should be the first empty row by getting rows=UBound(myArray,2) I'm then trying to add into the next row by using rows + 1
I am b-testing a community site, with currently 1,000 or so membership, and low concurrency, say no more than 5 on-line at once.
The site is hosted on a shared server, which is sufferening from intermittent accute slowness, affecting all other hosted sites as well as mine.
The finger of suspicion is pointing at me and possible sloppy code. As this is the first site I have done of this nature, could someone recommend reading matter (knowledge bases etc), especially coding samples, in connection with data connections (opening and closing connections and objects) and record locking issues, which if improperly coded, could contribute to throughput bottlenecks due to inefficient use of resources so that I can check out my pages and correct any nasties..
I need to develop an application that will span 12 or so pages, and on the last page, it lets the user review the data and then insert it all. This is kind of like selling something on eBay, you give it information, click next, enter more info and then at the end you review and submit the item. I was thinking about sessions, but some of the fields are pretty big, like varchar(5000) so I didn't know if there was a way to handle these big fields.
I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather). So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc. How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:
results.Move 10
and things like that, but I'm not sure of the best way around this.
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?