How Do I Make A Repeat Region On A Recordet Go Left To Right Instead Of Just Down
I have a dynamic driven web page which get's a select value from the menu choice.
I querry the database recordset and pull back the correct values.
I want to display them in a grid fashion. I want to limit how many items per page are show in each grid and then I'll use the standard DW behaviors to move to next page, etc.
The challenge I have is making the repeat region go left to right instead of repeating down.
Not sure if this is possible, I have a memofield that contains a data string (e.g. name1, name2, name3, name4 .... name 30) I would like to represent the data in a table so that each name is on a different row eg
I have some fields in the database that are not used in certain records, the problem being of course the it displays these feilds in the webpage and then the size of the webpage gets rather big, full of empty spaces .its just to fields in particular I need to apply this to?
I am on the last part of my ecommerce site but I've hit a problem I can't seem to figure out. I have an asp page with an Orders table that lists the OrderID and the customer name and what they have bought.
Then if you click on the ID number you go to a details page that lists their name, credit card details, address etc. Also I want to show all the items that they have purchased but so far it only enters the first item they've purchase. I have tried making just the products a repeat region but I get an error when I do that.
Anone know of free code available to create a vertical repeating region? (I've found code for a horizontal repeating region.). I want to display my data from an Access table vertically, not horizontally.
I have a database that displays its records on a webpage, The information displayed on the webpage is included in a repeat region so that the related records repeat down the page.
I want to add the totals of the displayed records at the end of the page. How do i do this. Im assuming that it goes outside the repeat region? Does anyone have any code or a walk through of how this is done?
i am not sure if i am on the right section to place this thread, but my code is in .asp and i am using a access database and i wanted to link a text to another text in a seperate page that contains a repeat region that its pulling from the access database.
this lists like 7 records at a time and i was using the anchor method to link the text from the home page to the text in one of the fields that is in the repeat region and was not succesfull, It would take me to the page but would not go to that specific recordset that i have placed the anchor.
I am displaying multiple records returned in a resultset using a Do While loop. I've set the form field names like the following:
<select name="fieldnameA<%=ID%>"...
where <%=ID%> is a hidden field on the page that holds the id value for each record.
I want to append that number to the end of each form field
So, "fieldnameA" would be fieldnameA1 or fieldnameA2, etc.
I thought this would work, but the field names remain the same for every record...i.e. fieldnameA just repeats and the hidden field value isn't appended to the end of the field name.
Is there a way to append the value of the hidden field to the end of the form fields? So, the form field names are different for each new record displayed?
I have a single access database file with several tables, two of which are tblPanels and tblAssignedPanels. The table tblPanels has a panel ID number and a name for the panel. In the table tblAssignedPanels, there is a record ID, the panel ID of the panel that has been assigned, and the user ID of the user account the panel has been assigned to.
Then, there is a third table (tblManuals) that has a manual ID, the ID of the panel the manual is for, and the path to the manual on the server. What I would like to do is have a repeat region that lists all the panel names (from tblPanels) that are assigned to the currently logged in user based on userID (assigned panels found in tblAssignedPanels), and makes each a link using the path in tblManuals.
Currently, my repeat region is showing all of my repeated records that are being brought in from my database. I would like to display these records in a confirmation page, but I am having problems having them display in my confirmation page.
I tried to assign a hidden value to the repeat region, but I am getting no data to come across. Below is the code that I'm using: Code:
Ok now i am not sure if what i am trying to achive is done by css or asp code. what i am trying to do is when data is outputed on a page that has a repeat region set to a table. How do i get the rows to show in diffrent colours, eg. 1st row the baground is blue than second is green than third is blue again and so on.
I have information pulled from a database and it works ok. However, I have several records in each repeat region and I want to add the values in these fields together.
So in the first record I have cont1 = value from database (1000) cont2 = value from database (2000) cont3 = value from database (1000)
Second Record cont1 = value from database (2000) cont2 = value from database (1000) cont3 = value from database (1000)
I have a page which on default will display 5 rows per page. I would the user to be able to select from a listbox (on the recordset page)and change the number of rows displayed on the page.
I have tried a page with a listbox on and submitting to itself. But on re-load the listbox returns to its default value.
I've created an ASP/VB page completely with DWMX2004, very minimal code tweaking, using mostly the tools available in DW.
Created a Table with a bunch of columns pulling info from MS Access DB, and set a Repeat Region on that table.. I also have Add/Update/Delete pages, etc..
I've been trying to figure out how to add a dropdown box (or maybe several) to Sort on various columns..
like above the Name column, i'd like to be able to sort by Name.. then Zipcode, State, etc..
Maybe if I could Sort the table by clicking on the column Headings, that would be even better..
I have a table with 3 rows and 5 colums.. top row is where my column Headings are.. then a spacer row, and then the info pulled from DB.. i've set the repeat region just on the bottom Row..
I have an ASP page that users print off onto headed paper, question is how do I force a new page when the length of the data varies from at times less than a page to many pages at other times?
I know this can be done with CSS but not too sure how to implement it.
I'm doing some text manipulation and I'm getting a strange error. My code is: [vbs] modT = trim(left(CommandArray(x), inStr(CommandArray(x), "-") - 1)) [/vbs]
CommandArray is an array created by a split() statement (so it contains strings). It's content at the time if execution (if I response.write it) is "Policies -name:Board -public:yes". What I the line above to do is return "Policies". All the math should work out, but I get this error:
Code: Error Type: Microsoft VBScript runtime (0x800A0005) Invalid procedure call or argument: 'left' buildLinks.inc, line 10 Line 10 is the line pasted above.
i got two tables (sDetail and newTable).i'm using a left join to find the dif from the two tables using the pk tutor on both tables . then i need to display the table dif on my browser but where am i suppose to take the result from?
I want to use the two first numbers of a user-input as a flag, but don't know how to get them in ASP... How can I use a function like 'variable = left(user_input, 2)' in ASP?
<% If Len(TestRS.Fields.Item("Testimonial").value) > 150 Then Response.Write(Left(TestRS.Fields.Item("Testimonial").Value,150)&""... <br><font size=1><a href=""/Testimonials.asp"">Read More</a></font>") Else Response.Write(TestRS.Fields.Item("Testimonial").Value) End If %>
I am getting a null response from TestRS.Fields.Item("Tesimonial").Value after it is processed by the Len function.
I am getting the following result: Quote: "... Read More This tells me that the len function is analysing the string to be greater than 150 charachters yet the string is not being expressed.
I am working with two databases. One is dockets which holds all kinds of information about upcoming legal hearings. The second one is additional parties which holds additional records related to the dockets data table. Not all dockets have additional parties so when I need to display information about a case I may or may not need records from there so I am using a left outer join. It works perfectly EXCEPT for one small matter. The field that I am joining on (petitionCaseNumber) is turning up empty after the join. Below is the join.
varSQL = "SELECT * FROM Dockets LEFT OUTER JOIN additionalParties ON Dockets.petitionCaseNumber = additionalParties.petitionCaseNumber WHERE dockets.petitionCaseNumber = '" & numberIn &"'"
When I say something like response.write rst("petitionCaseNumber") I get nothing if I say response.write rst("dockets.petitionCaseNumber") I get an error. How do I refer to this field or how do I get this field to contain the case number?
I need to be able to pull the table names and values from each checkbox name (for example, I would need to pull the "table_city" and "20" from the checkbox above).
In short, how do I pull out the table_city and 20 from the first example. Since the table names and values vary in size, I can't just do a regular mid, left, right function.
I'm trying to pull a value onto my web page from a joining table and all I keep getting is the id instead of the actual value. table_status has has sid and status. for some reason I'm getting the id number instead of the value of the status. this is my error message when I try to join tables. Code:
Many a page has ADO Connection objects that were opened but never closed. The Connection object allocates its own resources when it is opened. When the object goes out of scope without being explicitly closed, the resources ASP allocated for it are freed, but the resources it allocated on its own are not. These eventually clutter up the server and slow it down to a crawl.
My question is, is there a way to track down these orphaned resources and forcibly free them from ASP, without restarting IIS or the server? Or does one have to wait for the unused Connections to time out and release themselves? I know that good coding practice is best, but is there a temporary fix to tidy up these connections left open?
am using an XML feature to web crawl on my provider's site to get a response of an sms message sent. Am using code:
ehioze = left(sResult,3) However, i only want the results of ehioze only if its numeric characters. and if there are any alphabets, it shoudl exlude it. How woudl this be done ?
It works fine but when I use this same code to get x characters plus display it using VBCRLF, with the <br> with writing the code :
<%=Replace LEFT (Recordset1.Fields.Item("Detail").Value,VbCrLf,"<br><br>",50)%>
it gives me error so please can you tell me how can i trim the characaters and at the same time use VBCRLF. why does this above code with LEFT + vbCrLF doesn't work.
When a student taking a quiz having a duration of 2 hrs, a timer will start and keep track the time.
So if he logout or close the window, the remaining time should be recorded into the database. And when he take the same quiz again, the timer will not restart but continue from the previous time.
E.g i take a quiz having a duration of 60mins, and when i logout the time duration remain is 30mins. And when i logon and take the quiz again, the timer countdown from there 30mins but not begining of 60mins.
I am currently having a problem with one of my ASP pages; Currently, in the SELECT, I am using JOIN LEFT functions which work fine (see the code below). However, I have now created a new table which I have successfully linked to the other tables. However, I am not sure how I would word the JOIN LEFT statement for the new table.
The new table is located at Report.Report I have tried to have a go, but am I missing something? I always get an error message saying, Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. Code:
I need to be able to execute some code or display a popup when a user leaves the site. Does anyone know if it is possible to detect this? Is there an event that is called before the user leaves where I could put some code?