Changing Ordinal Position
how to change the ordinal number of a field and the field datatype in Access using ASP?
View Replieshow to change the ordinal number of a field and the field datatype in Access using ASP?
View RepliesDoes anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?
View Replies View RelatedError Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
i donno what's happenning but this code is working already but i can't search for my data... but i can see it inside the database.
Anyone come across this error before? Its responding to <%=rs("FIRM")%>, but I have it declared in a sql statement in the code. Any ideas? Code:
<%
Set cst = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
DBpath = server.MapPath("../../../NHITADATABASE2.mdb")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBpath & ";"
cst.Open strConn
mysql = "SELECT lname, fname, email, firm, import_pro, export_pro, title, city, st, email, regions, country, website, address1, address2, zip, languages, product_service_description FROM NHITAmembership"
'Set rs = MyConn.Execute(mysql)
%>
I'm running a stored procedure that inserts a record into a table then
returns the Identity field value. I've done this kind of thing plenty of
times in the past, but I'm obviously doing something wrong this time..
I've tested the Stored Proc in QA and it works fine. The SQL code runs OK in
ASP (iAffected = 1 which shows the record is inserted), but when I try to
query the resulting recordset, I get an error:
"Item cannot be found in the collection corresponding to the requested name
or ordinal. " Code:
I'm querying a table and the column has 6 positions. I need to check if the 5th position is a 2,3,6 or 7. If so I want to set a variable = "Y". Can someone help me out with this?
View Replies View RelatedI am using position feature for images...although its placing the image on the HTML file using the top left corner of the image. Anybody know how to make it use the center of the image?
<img src="image.gif" style="position: absolute; left: 54; top: 34">
I have a access db and I want to pull some info out of it with VBScript. How can I specify a starting record?For example, I want to start at the 15th record and pull everything beyond that out.
View Replies View RelatedWhen a page is opened is there a way to set focus of the cursor to a named input. I want the cursor to be in the input box when the page is opened.
View Replies View RelatedAfter I read in a value from a table i need to read in the last letter of the value and check if it has an "s" as its last letter, so that i can display either ' or 's.
Does anyone know how code to view the last letter of the value or move the variable into javascript so that I can manipulate it from their?
I've just gone to Google and there's a link saying "add world cup live
scores..."
I clicked on that link and there are a whole lot of boxes containing content
that I can pick up and drag around, changing their relative position on the
screen.
Fantastic - but how do they do this (were can I read up on this?)
I have been working on this site for the last couple of weeks and i am now in the process of testing and have found a problem.
Basically it is on my jscript function. I have written that if the value is >= 2000 do something else do something else, which is fine with the exception that the value isn't always going to go up in 1000's (sometimes it will be 1-10 others 500-5000 others 1000 - 10000[these values are generated within select tags]).
Basically i am wanting to know is there any way that i can use the select tag to work out the position from within the tag. For example if the position >= 2nd in list do this else do something else.
I have put serveral panel controls within a page, each of them matching to a action defined by buttons, so I want to fix all panels in one place( they already have same size, but different left, top values), how can I do it (in code, if I do it in desgn, is there a way to put the panels in different "layers" so the contained controls will not interupt with each other)?
View Replies View RelatedI use an array of elements and I want to know the position of a given element in my array
I know the filter function that allows to determine if the element i look for is in the array but this function doesn't allow me to know its position.
how do i find the occurence and position of a variable in a csv string. e.g. how do i find "hello" in hi,who,where,how,hello,greetings,xmas,etc. The starting position and if it occurs ? I tried using instr but cant seem to get it right.
View Replies View RelatedI am having a prob with getting for example, ASP Free Forums > Programming > etc, to display properly. I can get it to work sort of but need to be able to read in a value and be able to change it before its displayed.
It works on the first page but when going to other pages it doesn't. Also when going back to the original page, topic.asp where it works, from view topic the formatting disapears which is a mystery to me. Here is the code that gets it to work on the topic.asp page:section = Trim(Request("Section")) Code:
The code below takes the script name of a page (which is always an asp file) and substitutes the asp extension with html and then inserts the file in the <frame> tag.
This code works file for a url such as www.somesite.com/file.asp But if the url includes an index eg www.somesite.com/file.asp#position1 how do I get the #position1 added to the file name that is used in the <frame> tag? Is there a server variable for # info? Code:
How can I delete an specific position within a vector?I have a list of e-mails to be sent but there's duplicated values which I'd like to remove.I added a function that locates the duplicates and tells the vector position I can find them, but don't have a clue how to remove them.
View Replies View RelatedWe have a page that loads a long list of things. Each row has an onclick where you can open a window for more information. When you do that the parent page refreshes to the top of the page....so if you were near the bottom, you would have to scroll back down to get back to where you were. I would like the parent page to hold its position when the child opens.
View Replies View RelatedIm attempting to grab results from a stored procedure and toss them in a recordset. Unfortunately, I cannot open a recordset that can move forward and backward. I have tried to simply chance the rs.CursorType but this results in a connection timeout..
Code: ....
Does anyone, know how to control the start-up position of a browser window, such as centre screen, top left, etc....
View Replies View Relatedi have a string and want to find the position of the first '-' in it.
example i have :
"RCD-0-183"
I need to output : 0-183
I'm building a text file from a database table using the ASP
Write Method and would like to position the cursor in a specific
column position before writing the fields. As I loop through and write
the fields into strings of rows, I want to be able to put field1 in
row1/column position1, field2 in row1/column position10,.....etc.
I've included the basic code to write a string of text. I understand
the process of how to write the fields and loop, etc. If you would be
kind enough to just show me in there the syntax for positioning the
cursor before the write I will then apply it to my code:
I have an asp page that shows dynamic data. I have it refreshing every 10 seconds. It is a very long page and when it refreshes it goes back to the top. I want the page to refresh and keep its same position.
View Replies View RelatedI have four select options on my page. I want to display some text for each selection of my options. This display shoould be in the previous <td>. Here is the code:
View Replies View RelatedI have an asp form. The page is kind long. After user scroll down and make some change on the items, the form needs to be refreshed with new selections (some controls may disabled based on the selection).
My question is, each time after the refresh, the form always go back to the top position. Since the form is quiet long. User may get frustrated if he/she have to scroll down the page to find the current position each time after make a selection change. Is there a way to remember the document postion before refresh the form, and reset the position after the refresh? I guess some javascript code may be able to do it. But so far I have no clue at all.
i am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
Last week I posted in the graphics forums regarding a photo I have that I needed to slowly change from day to night.Now I have the various stages, I need them to display on my site, according to the time of day.For example:
Between 5am and 7am display the early morning picture
Between 7am and 5pm display the day picture
Between 5pm and 7pm displayy the evening picture
and so forth.
I'm having a domain change foisted upon me and the test I did resulted
in every last ASP and
ASP.Net script stopping cold. Nothing but plain old html worked.
Is there a FAQ or some other document available that outlines what has
to be done when the
IIS server machine is disconnected from one domain controller and
reconnected to a totally different one? If not, does anyone here know
what would have to be changed to make the ASP code play nice in the new
domain?A relevant bit of info, they're also changing the name of the
administrator account. I don't know if that would contribute to the
death of ASP* on the system, but it might.
i have an insert record and edit record page. When inserting to the db, it uses now(). When I go to edit an existing record the date stays as the original date. How do I make the date change to the amended edit date?
View Replies View RelatedI have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
how best to convert an application which is all in English to be able to roll the app out to say Germany or France and it all appears in the correct language
View Replies View RelatedMy site uses frames.I have a header frame, a menu frame and a main frame. When the page opens, the header frame and the main frame are generic. The main frame has a log-in dialog. Once the user logs in, they are taken to a 'main' page and I want to replace the header and menu frames with other frames .
View Replies View Related