Search results for query: *

Hi i have this bit of code Dim item For Each item in Request.Form Response.write "<input type=text name=FieldName value=" & item & ">" & vblf Response.write "<input type=text name=FieldValue value=" & Request.Form(item) & ">" & vblf Next which outputs all field names and their values onto a...

Hello I've been asked to install a dll, from our software supplier as per below (see below). Never done anything with COM+ before, how can i go about this please ? i presume there are no security risks ? the dll is from a trusted supplier. My Services has COM+ event system started but COM+...

Hello I have a stored procedure below, which i call from an asp. all parameters are optional, so they may only fill out the varMake asp field for example. I do have this working for a simpler example for one parameter that is = as opposed to like, but this returns nothing ! any help...

hello in my asp i have a variable called Enquiry, which holds a value. I'd like, on the onlick of the save button to return the Enquiry variable in an alert ? how can i ? thanks rob

Hi I have this sql running which works ok, basially show potential duplicte customers by uprn and orders (DESC) by datelastmodified for the customer. problem is say a MR. SMITH is the first record (because somebody has just created him 2 minutes ago) his duplicate may have been created 2 months...

I have a SQL statement (i have a report in visual studio that creates a dataset) and calls this sqlstmt1 SELECT WARD_NAME, COUNT(*) AS CustomerCount, WARD_ID FROM dbo.vwLPGWards GROUP BY WARD_NAME, WARD_ID ORDER BY COUNT(*), WARD_NAME, WARD_ID this is based on a view (shown below) but the...

Hi I've got the following code but it does not return the value of the scope_identity in the variable llID. How can i get its value in a variable for use in another sql statement. thanks ian SQLstmt = "IF EXISTS(SELECT uniqueid FROM members WHERE uniqueID = '" & _ request("tempid") & "')"...

Hi I used the following code to find the first date from the previous month e.g. 01/05/2006 I'd like to return the date for the monday of the previous week so e.g. 19/06/2006 and also friday's date of the previous wek e.g. 23/06/2006 any ideas ? thanks rich =left(format(DateSerial(iif(...

hello I was trying to get a recordset value into a message box, which i managed and worked as so (after the user clicks save) dim oRSSaveUserMsg, msg_text set oRSSaveUserMsg = Server.CreateObject("ADODB.Recordset") getsaveusermsg oRSSaveUserMsg msg_text = oRSSaveUserMsg.Fields(1) <script...

HI I'm trying to use dynamic stored procedures. My where clause is built up in the asp code, i have a stored procedure which calls that where clause and should display the info back to the screen, except i get an error Incorrect syntax near 'Col004' here is my stored procedure CREATE PROCEDURE...

Hi I've got 2 input types of text with a value that when clicked the value (set text) clears, except i get an error 'Object expected' I have to build my asp page up as a string, so excuse that javascript LPRSearchHead1 = "<script language=""JavaScript"" type=""text/javascript"">" & VBCRLF...

Hi I have a temp table with 17 columns (Col001 - Col017) i'm trying to retrieve Col003 but do a union select -1 as SELECT DISTINCT PARSENAME(REPLACE(Col003, '/', '.'), 1) AS Expr1 FROM Temp UNION SELECT -1, '--All Licence Types--' it says must have equal number of expressions in their...

Hi How can you get the value of a select box into a hidden text box please ? thanks ian

Hi I have a SQL table witch column LICTYPE which holds such values as 06/xxxxx/LIPREM 06/yyyyy/LIPREM 06/xxxyy/CLUB 06/yyxxx/CLUB 05/xxxxy/LATEMP In an ASP form, i'd like to have a select list of distinct LICTYPES such as LIPREM CLUB LATEMP etc etc so i need to loop through the contents of...

within one report within one project can you have multiple selects, for example i may have select * from Tablea select * from Tableb i can then run off 2 graphs each based on the seperate select statement, but the 2 graphs diplaying on one report. thanks

hi I've got the code below, which works ok, allows the operator to choose parameters, for service, location and between dates. I'd like to create a timeframe graph as the result (showing total number of calls within each timeframe), for hourly timeframes 8-9, 9-10, 10-11 etc until 4-5. the time...

HI i'm trying to setup a couple of report parameters for date start(1st day of currentmonth) and date end (last day of current month) so i set the data type as string, and the default value for non-queried to (date start for example) =format(DateSerial(Year(now), Month(now), 1),"dd/mm/yyyy")...

hello I'm using sql reporting services, and i'd like a parameter for a distinct list of values (distinct d.TYPEDESC) for the user to select on the report. I'd also like to add an 'ALL TYPES' at the top (which I've seen done as union select '-1' ?) using my code below how would i go about adding...

I'm trying to retrieve the last inserted record's id from my sqlstmt below and embedd it in an email, but no joy - doesn't fail but doesn't return the value llID. excuse the sql string, but i have to do it that way. thanks ian SQLstmt = "INSERT INTO tablename (Ename, Eorg, Eaddress1...

I have the code below which works fine and outputs in report format using sql reporting. I also have a lookup table of postcodes (CTS_POSTCODES) which has a column Postcode with hunderds of rows such as M1 2AL M1 2BZ M12 2RT etc etc what i'd like to do is group the report by postcode...